A good Oracle database administrator must gain and maintain a mastery of his or her environment, its physical structures, and its maintenance routines. An administrator must understand the data being stored well enough to tune and improve performance, to anticipate and prevent data failure, and to recover lost data should a failure occur.
In this course, you will develop an advanced understanding of complex Oracle database concepts, maintenance and recovery routines, and database management. You have an Oracle installation and need to broaden your knowledge of advanced Oracle administrative functionality so that you can maintain the healthiest possible database.
Course Objectives
The course will cover the following elements:
- Using Oracle ASM
- Performing User Managed Backups
- Performing Managed Database Recoveries
- Configuring and Backing Up Using RMAN
- Using the RMAN Recovery Catalog
- Recovering Database with RMAN
- Reporting, Monitoring, and Tuning with RMAN
- Performing Advanced Recovery
- Understanding Flashback Technology
- Diagnosing the Database and Managing Performance
- Managing Database Resources
- Using the Scheduler to Automate Tasks
- Implementing Globalization Support
Prerequisites
The following courses are suggested prerequisites:
- Introduction to Programming (Second Edition)
- SQL: Fundamentals of Querying (Second Edition)
- Object-Oriented Programming Principles
- Java 2: Object-Oriented Analysis and Design Using UMI
Course Benefits
Oracle 11g is designed to handle the ever-increasing data needs of modern organizations. Effective management of Oracle 11g capabilities can help organizations ensure the integrity and security of data. In this hands-on course, you maximize the features of Oracle 11g to build and maintain databases, configure memory and storage for optimal performance, and manage large amounts of data.
Course Duration: 72 Hours