Training

How We're Different

Course Summaries

Course Logistics

Client-site Classes

Virtual Classes

FAQ

Cancellation Policy

Request Information

Course Surveys

Overview

This 5-day course provides students an opportunity to learn about key enhancements in Oracle Database 11g R1. Students will examine the benefits and use of features in managing change, diagnosing and resolving problems, improving scalability and performance, strengthening security, and several other areas covering database administration. In addition, hands-on lab exercises will be used to reinforce key concepts and capabilities.

Course Objectives

• Using SQL Performance Analyzer
• Upgrading to Oracle 11g Release 1
• Automatic database diagnostic monitor
• Flashback data archive

Course Agenda

Discuss Oracle 11g R1 enhancements and new features in the following areas:

• Installation and Upgrade Enhancements
• Storage Enhancements
• Database Replay
• Automatic SQL Tuning
• Intelligent Infrastructure Enhancements
• Performance Enhancements
• Partitioning and Storage-Related Enhancements
• Using RMAN Enhancements
• Using Flashback and LogMiner
• Diagnostic Enhancements
• Using the Data Recovery Advisor
• New Security Features
• Oracle RAC & Data Guard

Prerequisites

• A skill level equivalent to a working Oracle 9i or 10g database administrator (DBA), or familiarity with administering an Oracle 9i or 10g database instance
• A minimal skill set in UNIX operating systems, such as how to navigate the UNIX/Linux operating system
• Basic UNIX/Linux operating system navigation skills, including the ability to use ls, cd, and pwd commands
• Basic Oracle skills, including the ability to use sqlplus as well as how to find alert logs, configuration files

Lab Work

This course includes hands-on labs where the student can build on their existing knowledge of Oracle by becoming familiar with and trying out the new features of Oracle 11g.

Delivery