Oracle 11g Release 2 for Experienced Oracle 9i Database Administrators

Prerequisites:

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

Course Description:

This Oracle Database 11g Release 2 for Experienced 9i Database Administrators course course will give experienced Oracle 9i database administrators practical experience in installing, configuring, administering and implementing an Oracle Database 11g.DBAs will gain a practical understanding of the new features of Oracle Database 11g Release 1 and Release 2 and how these can be implemented in their current Oracle installations.

The delegate will practise:

• Installing Oracle Database 11g Software
• Creating an Oracle Database using New Features
• Upgrading a Database to 11g Release 1 and Release 2
• Using the New Enterprise Manager
• Proactively Monitoring with Database Advisors
• Using New Memory Management Features
• Using New Data Storage Features
• Using Automatic Storage Management
• Using New Space Management Features
• Using New Optimizer and Index Features
• Using New SQL and PL/SQL Features
• Using the Data Pump Utility
• Using New Backup and Recovery Features
• Using New Availability Features
• Using New Security Features
• Automating Tasks with the New Scheduler
• Using Real Application Testing
• Using Database Replay to Capture, Process and Replay Workloads
• Using the Data Recovery Advisor and Flashback
• Managing Transactions using Flashback and LogMiner
• Using Performance Tuning New Features
• Implementing New Schema Management Functionality

This course includes the following modules:

Course Contents

• 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