Oracle 11g Release 2 for Experienced Oracle 10g Database Administrators

Prerequisites:

Course Description:

This Oracle Database 11g Release 2 for Experienced 10g Database Administrators course is designed to provide the knowledge and skills needed to maintain successful and efficient day-to-day operation of Oracle Database 11g Release 1 and Release 2.The Oracle Database 11g Release 2 for Experienced 10g Database Administrators course will give experienced Oracle database administrators practical experience in installing, configuring, administering and implementing an Oracle Database 11g Release 1 and Release 2.Database administrators 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
• Hot Patching
• Using SQL and PL/SQL New Features
• Using New Memory Management Features
• Real Application Testing
• Using Database Replay to Capture, Process and Replay Workloads
• Using the Data Recovery Advisor and Flashback
• Transaction Management using Flashback and LogMiner
• Using RMAN New Features
• Using Data Pump Data Compression
• Using Performance Tuning New Features
• Using New Security Features
• Using New Schema Management Functionality
• Using AutoTask
• Using Data Warehouse and BI New Features

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
• Enterprise Manager Changes
• Hot Patching
• SQL New Features
• PL/SQL New Features
• New Memory Management Features
• Real Application Testing
• Use Database Replay to Capture, Process and Replay Workloads
• Setup and Use ASM New Features
• The Data Recovery Advisor and Flashback
• Transaction Management using Flashback and LogMiner
• RMAN New Features
• Data Pump Data Compression
• Data Guard Improvements
• Using Log Miner from Enterprise Manager
• Performance Tuning New Features
• New Security Features
• New Schema Management Functionality
• Data Warehousing Enhancements
• Miscellaneous New Features
• Desupported and Deprecated Features