Oracle 11g - Experienced Oracle 9i Database Administrators

Delegates:
 
Database administrators who need to update their current Oracle 9i skills to create, administer, monitor, backup and support Oracle Database 11g. 

Objectives:
 
This course is designed to provide the knowledge and skills needed to maintain successful and efficient day-to-day operation of Oracle Database 11g.  The course will give experienced Oracle 9i database administrators practical experience in installing, configuring, administering and implementing an Oracle Database 11g.  Database administrators will gain a practical understanding of the new features of Oracle Database 11g and how these can be implemented in their current Oracle installations. 

Topics Covered:
 
Installing Oracle Database 11g Software
Creating an Oracle Database Using New Features
Upgrading a Database to 11g Release 1
The New Enterprise Manager
Implementing New Manageability Features
Proactive Monitoring with Database Advisors
New Memory Management Features
New Data Storage Features
Automatic Storage Management
New Space Management Features
New Optimizer and Index Features
New SQL and PL/SQL Features
Improved VLDB Support
Database Resource Manager Enhancements
New LogMiner Features
The Data Pump Utility
New Backup and Recovery Features
Transportable Tablespace Enhancements
Overview of Oracle Secure Backup
Install Oracle Secure Backup
RMAN and Oracle secure Backup
New Availability Features
New Security Features
Automating Tasks with the New Scheduler
New Network Features
Desupported and Deprecated Features
Hot Patching
Real Application Testing
Use Database Replay to Capture, Process and Replay Workloads
The Data Recovery Advisor and Flashback
Transaction Management using Flashback and LogMiner
Data Guard Improvements
Using Log Miner from Enterprise Manager
Performance Tuning New Features
New Schema Management Functionality
Data Warehousing Enhancements
 

Requirements:
 
Delegates should have good understanding of Oracle 9i Database Administration.