Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
Oracle Database 11g: New Features for Administrators
 
 
 
 
oracle certified training  
 
code. 11gDB-NF   length. 5 days
type. Instructor-Led   partner. Oracle
price.
$3,000  
 
 
This course gives students the opportunity to learn about-and practice with the new change management features and other key enhancements in Oracle Database 11g Release 1. Students examine the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas that concern database administrators. In addition, the hands-on practice sessions help reinforce students understanding of these new capabilities in Oracle Database 11g Release 1.

Learn to:

Implement manageability features to simplify database management
Utilize database advisors to provide proactive database monitoring
Increase data availability by using improved ASM, RMAN, and Flashback features.
Use change management features to master database changes
 
course schedule  
 
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.
   
Request course date Request on site training
 
who can benefit
  
 

Data Warehouse Administrator
Database Administrators
Database Designers
Project Manager
Sales Consultants
Support Engineer
Technical Consultant
 
prerequisites
  
 
Required Prerequisites:

Strong Oracle Database 10g concepts
Oracle Database 10g: New Features for Administrators Release 2
Oracle Database 10g: Administration Workshop II Release 2
 
skills gained
  
 

Use the SQL Performance Analyzer
Upgrade your database to 11g Release 1
Record and replay workloads
Use the automatic database diagnostic monitor
Explore advanced RMAN capabilities
Manage a flashback data archive
Use the data recovery advisor
Setup and use ASM
 
related courses, exams and materials
  
 


 
course content details  
 


  Installation and Upgrade Enhancements

Use the SQL Performance Analyzer
Upgrade your database to 11g Release 1
Record and replay workloads
Use the automatic database diagnostic monitor
Explore advanced RMAN capabilities
Manage a flashback data archive
Use the data recovery advisor
Setup and use ASM




  Installation and Upgrade Enhancements

Oracle Database 11g Installation: Changes
Oracle Database 11g: Software Installation
Oracle Database Upgrade Enhancements
Upgrade Performance Enhancement
Upgrade Process
Oracle Database 11g Release 1: Upgrade Paths
Database Upgrade Assistant (DBUA)
Hot Patching: Overview


  Storage Enhancements

ASM Fast Mirror Resync: Overview
ASM Preferred Mirror Read: Overview
ASM Scalability and Performance Enhancements
ASM Scalability in Oracle Database 11g
ASM Disk Group Compatibility
ASMCMD Extensions




  Change Management Unit Overview

Change Management in Oracle Database 11g
Challenges Faced by DBAs When Performing Changes
Lifecycle of Change Management
Setting Up a Test Environment by Using the Snapshot Standby Database
SQL Performance Analyzer: Overview
Capturing the SQL Workload
SQL Performance Analyzer: Data Dictionary Views




  SQL Plan Management

SQL Plan Management: Overview
SQL Plan Baseline: Architecture
Evolving SQL Plan Baselines
SQL Plan Selection
Possible SQL Plan Manageability Scenarios
SQL Performance Analyzer and SQL Plan Baseline Scenario
Loading a SQL Plan Baseline Automatically
Purging SQL Management Base Policy




  Database Replay

System Architecture: Capture
System Architecture: Processing the Workload
System Architecture: Replay
Pre-Change Production System
Supported Workloads
Database Replay Workflow in Enterprise Manager
Using the Capture Wizard
Packages and Procedures




  Automatic SQL Tuning

Automatic SQL Tuning in Oracle Database 11g
Selecting Potential SQL Statements for Tuning
Maintenance Window Timeline
Automatic Tuning Process
DBA Controls
Automatic SQL Tuning Task
Automatic SQL Tuning: Fine Tune
Automatic SQL Tuning Considerations




  Intelligent Infrastructure Enhancements

Automatic Workload Repository Baselines
Performance Monitoring and Baselines
Automated Maintenance Tasks
Resource Manager: New EM Interface




  Performance Enhancements

ADDM Enhancements in Oracle Database 11g
Oracle Database 11g: Automatic Database Diagnostic Monitor for RAC
New ADDM Views
Automatic Memory Management: Overview
Oracle Database 11g Memory Parameters
Automatic Memory Parameter Dependency
Monitoring Automatic Memory Management




  Partitioning and Storage-Related Enhancements

Oracle Partitioning
Partitioning Enhancements
Interval Partitioning
System Partitioning
Virtual Column–Based Partitioning
Reference Partitioning
Table Compression: Overview
SQL Access Advisor: Overview




  Using RMAN Enhancements

RMAN: New Features
Optimized Backups
Parallel Backup and Restore for Very Large Files
Using RMAN Multisection Backups
Duplicating a Database
Managing Recovery Catalogs
Creating and Using Virtual Private Catalogs
Using RMAN Virtual Private Catalogs




  Using Flashback and LogMiner

New and Enhanced Features for Flashback and LogMiner
Flashback Data Archive Overview: “Oracle Total Recall”
Flashback Data Archive: Architecture
Flashback Data Archive: Workflow
Guidelines and Usage Tips
Flashback Transaction Backout
Flashback Transaction Wizard
Using LogMiner




  Diagnosability Enhancements

Oracle Database 11g R1 Fault Management
Ease Diagnosis: Automatic Diagnostic Workflow
Automatic Diagnostic Repository
Location for Diagnostic Traces
Incident Packaging Service (IPS)
EM Support Workbench: Overview
Health Monitor: Overview
Data Recovery Advisor




  Using the Data Recovery Advisor

Repairing Data Failures
Data Recovery Advisor
Data Recovery Advisor RMAN Command-Line Interface
Best Practice: Proactive Checks
Setting Parameters to Detect Corruption




  Security: New Features

Secure Password Support
Automatic Secure Configuration
Managing Default Audits
Setting Database Administrator Authentication
Transparent Data Encryption
Hardware Security Module
Using RMAN Security Enhancements




  Oracle SecureFiles

Managing Enterprise Information
Problems with Existing LOB Implementation
Oracle SecureFiles
Shared I/O Pool
Altering SecureFiles
Accessing SecureFiles Metadata
Migrating to SecureFiles
SecureFiles Monitoring




  Miscellaneous New Features

Foreground Statistics
Online Redefinition Enhancements
Minimizing Dependent Recompilations
Locking Enhancements
Invisible Index: Overview
SQL Query Result Cache: Overview
Adaptive Cursor Sharing: Overview
Temporary Tablespace Shrink





 
Give your team direction. Authorized IT education.


ExitCertified - Oracle 100% Student Satisfaction


find a course
 
phone us
 
view course schedule





Give your team direction. Authorized IT education.

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware