CIS 228 - Oracle Database Administration II

3 Hours

In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test our own backup and recovery scenarios. Students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices. This course counts towards the hand-on course requirement for the Oracle Database 11g Administrator Certification. This course is the second of two courses required to acquire certification as Oracle Database Administrator - oracle Certified Associate (OCA) - Maps to Oracle Exam 1Z0053.