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

5 Day Course
Hands On
Code O11G9

Book Now - 1 Delivery Method Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online

Overview

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

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Course Contents (36 topics)

  • 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

Prerequisites

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

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections