Oracle Database: 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. Required prerequisites include: Oracle Database 11g & Administration Workshop 1 Release 2.

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

In this workshop, you 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.

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,500
Date: March 18-April 25
Class Meets: Mondays and Thursdays from 6-10 p.m.