Oracle Database 11: Administration Workshop II

This course takes the database administrator beyond the basic tasks in the first workshop. You’ll gain a deeper understanding of one of the most important jobs of a DBA – backup and recovery.

During this workshop, participants will learn how to automate DBA tasks with the scheduler; diagnose and repair data failures with Flashback technology; manage space to optimize database storage and to be able to respond to growing space requirements; monitor and manage major database components, including as memory, performance and resources; and secure the availability of your database by appropriate backup and recovery strategies.

This program is designed for database administrators, support engineers, technical administrators, and technical consultants to prepare for the corresponding Oracle Certified Associate exam.

Course topics include:
-Core Concepts and Tools of the Oracle Database
-Configuring for Recoverability
-Using the RMAN Recovery Catalog
-Creating Backups with RMAN
-Restore and Recovery Task
-Using RMAN to Perform Recovery
-Monitoring and Tuning RMAN
-Diagnosing the Database
-Using Flashback Technology
-Performing Flashback Database
-Managing Performance by SQL Tuning
-Managing Resources
-Automating Tasks with the Scheduler
-Managing Space in Blocks
-Managing Space for the Database
-Duplicating a Database

Hours: 40
Cost: $1,050

*Required prerequisites include: Oracle Database 11g & Administration Workshop 1 Release 2.

*Class meets August 27-October 4, Monday and Thursdays from 6-10 p.m