Database 11g: New Features for 9i DBAs

Scheduled Dates Locations filtered. Show all UK course locations.

Course Overview

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.

Audience

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

Skills Gained

• 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.

Examinations

N/A

Prerequisites

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

Course Outline

• 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

Follow On Courses

• SQL Performance Tuning
• Oracle 10g Application Server Administration

Database 11g: New Features for 9i DBAs / O11G9