Oracle 11g and 11g Release 2 New Features for Administrators:
35-Hour Online Class and Hands-On Workshop.

• Module 01 – Installation and Upgrade Enhancements
  
  • Installation Considerations
    
    • 11g Release 1 Installation Enhancements / New Features
    • 11g Release 2 Installation Enhancements / New Features
    • Oracle Universal Installer Enhancements for RAC
    • Depreciated Items in Oracle Database 11g
  • Configuration Assistant Enhancements
    
    • ASM Configuration Assistant (ASMCA)
    • Database Configuration Assistant (DBCA)
    • Database Upgrade Assistant (DBUA)
  • Upgrade Considerations
    
    • Upgrade Process
    • Upgrade Paths for 11g R1
    • Upgrade Paths for 11g R2
  • Patching
• Module 02 – Oracle Storage Enhancements
  
  • Overview of Oracle Database 11g Automatic Storage Management (ASM)
    
    • What is ASM
    • ASM and Real Application Clusters
    • ASM Requirements
    • ASM Implementation
  • New Storage Features for Oracle Database 11g
    
    • New Storage Features for Oracle Database 11g Release 1
    • New Storage Features for Oracle Database 11g Release 2
    • ASM Command-Line Utility (ASMCMD) Enhancements
    • ACFS Command-Line Tools
    • Enterprise Manager Support for ASM
  • Oracle Storage Recommendations
• Module 03 – Intelligent Infrastructure Enhancements
  
  • Intelligent Infrastructure Overview
  • What’s new in Oracle 11g?
    
    • Automated Maintenance Tasks
    • AWR Baselines
    • Enhanced Advisor Framework
    • Simplified Initialization Parameter Management
    • Temporary Tablespace Enhancements
    • Database Resident Connection Pooling
    • Resource Manageability
• Module 04 – Diagnosability Enhancements
  
  • Fault Diagnosability Infrastructure
  • Automatic Diagnostic Repository (ADR)
  • Health Monitor
  • Incident Packaging Services
  • Enterprise Manager Support Workbench
  • ADRCI Command-Line utility
• Module 05 – Performance Enhancements
  
  • Database Performance Enhancements
    
    • Automatic Memory Management
    • Active Session History enhancements
    • ADDM enhancements
    • AWR performance enhancements
    • Other Database Performance enhancements
  • General Server Performance Enhancements
    
    • Direct NFS Client
    • Invisible Indexes
    • Deferred Segment Creation
    • Database Smart Flash Cache
    • Other General Server Performance enhancements
  • Basic SQL and PL/SQL Enhancements
    
    • Intelligent Cursor Sharing
    • SQL Access Advisor
    • Cost-Based Optimizer enhancements
    • Query Result Cache
    • Other SQL and PL/SQL enhancements
  • Online Application Maintenance and Upgrades
    
    • Edition-Based Redefinition
    • Fine-Grained Dependencies for Triggers
    • Other enhancements
• Module 06 – Partitioning and Storage-Related Enhancements
  
  • Partitioning Enhancements
    
    • Composite Partitioning
    • Interval Partitioning
    • Reference Partitioning
    • System Partitioning
    • Virtual Column-based Partitioning
    • Other Partitioning Enhancements
  • Partitioning-related Enhancements
    
    • OLTP Table Compression
    • Partition Advisor
    • Partition Exchange Load
    • Enhanced Partition Pruning Capabilities
• Module 07 – Flashback and Logminer
  
  • Flashback and LogMiner New Features in Oracle 11g
  • Overview of Flashback Technology
    
    • Enabling Flashback Technology
    • Using Flashback Technology
  • Overview of the LogMiner Utility
• Module 08 – New Security Features
  
  • Security Overview
  • New Security Features
  • Security Add-ons
  • Maintaining Secure Databases
• Module 09 – RMAN Enhancements
  
  • RMAN New Features in Oracle 11g
  • Optimized Backups
  • Parallel backup and restore for Very Large Files
  • Large Backups for Data Warehouses
  • Using RMAN Multi-Section Backups
  • Active Database Duplication
  • Creating an Using Virtual Private Catalogs
• Module 10 – Data Recovery Advisor
  
  • Data Recovery Advisor Overview
  • DRA RMAN Command-Line Interface
  • Repairing Data Failures
  • Best Practice Proactive Checks
  • Setting Parameters to Detect Corruption
• Module 11 – Database Management New Features
  
  • Oracle Scheduler Enhancements
  • Online Application Maintenance and Upgrade
  • Enterprise Manager Enhancements
  • Other New Features for Database Management
• Module 12 – Automatic SQL Tuning
  
  • Automatic SQL Tuning Overview
  • New Features for Oracle 11g
  • Automatic Tuning Optimizer Overview
  • Automatic SQL Tuning Advisor Overview
  • SQL Access Advisor Overview
• Module 13 – Real Application Testing
  
  • Overview of Real Application Testing
  • Real Application Testing New Features in Oracle 11g
  • Using Database Replay
  • Using SQL Performance Analyzer
• Module 14 – Oracle RAC New Features
  
  • Overview of Oracle Real Application Clusters
  • RAC New Features – 11g R1 and R2
• Module 15 – Data Guard New Features
  
  • Data Guard Overview
  • Data Guard New Features – 11g R1 and R2
• Module 16 – Data Loading and ETL
  
  • Overview of Extraction, Transformation, and Load
  • Improved Data Loading
    
    • Execute Privilege for DIRECTORY objects
    • Extended syntax for ORACLE_LOADER access driver
  • Improvements to Oracle Utilities
    
    • Data Pump Enhancements
    • Oracle Warehouse Builder Enhancements
• Module 17 – Times Ten In-Memory Database (Optional module)
  
  • Overview of Oracle TimesTen In-Memory Database
  • Overview of Oracle In-Memory Database (IMDB) Cache
  • Features Summary of TimesTen and IMDB
  • New Features added in TimesTen 11g
  • Benefits of TimesTen

Students must be familiar with administration of Oracle 9i or Oracle 10g databases.

Read reviews of all SkillBuilders classes.

4.5 out of 5

Student Rating