Oracle® 11g New Features Workshop

Public Training Price : $2295 per student
Private Training Price : $8500 for up to 3 students*
*Additional students subject to a nominal fee
Print this outline
Enroll in this Public Class Get a Quote for a Private Class

 

 

 

Oracle 11g New Features Workshop Training Class Summary

Oracle Database 11g provides the power of grid computing, with even greater ease of maintenance. Grid computing gives us higher availability and central administration of a database deployed across multiple hosts. 11g aims to provide easier ways to manage this grid, as well as giving users and administrators other new features that they’ve been asking for.

This four day workshop will get students hands-on with all of the important new features they will need. Students will start with upgrades and downgrades and move on to real application testing, diagnosability and failure repair. DBA features for memory management, flashback, tables and new Enterprise Manager tabs will then be covered. The course covers new performance and security features, backup, recovery and data pump changes. Students will also work with several ASM and data warehousing changes. This course uses a companion text book, “Oracle Database 11g: New Features for DBAs and Developers,” with 21 hands-on lab exercises for lots of hands-on practice.

Audience: Oracle 10g database administrators.

Prerequisites: Oracle 10g Database Administration or equivalent experience.

Class Length: 4 days

Oracle 11g New Features Workshop Training Class Objectives
  • Install and upgrade to an 11g database.
  • Downgrade an 11g database back to 10g Release 2.
  • Navigate the fault infrastructure and recover failures.
  • Switch between AMM and ASMM for memory management.
  • Create and manage automated jobs.
  • Perform transaction backouts with flashback data archive.
  • Create tables with virtual columns and invisible indexes.
  • Manage and shrink a temporary tablespace.
  • Create restore points for database recovery.
  • Create lightweight jobs.
  • Manage 11g secure passwords.
  • Create an encrypted tablespace.
  • Use new RMAN commands to shred backups and create archival backups.
  • Use new import/export features of Data Pump.
  • Work with ASM including backups and restores of diskgroups.
  • Use the pivot and unpivot commands to transform data.
  • Use Enterprise Manager to create a system partitioned object.
Oracle 11g New Features Workshop Training Class Detailed Outline
  1. Installing, Upgrading, and Managing Change
    • Preinstallation
    • Oracle Database 11g Installation
    • Database Creation New Features
    • Documentation Format
    • Upgrading to Oracle Database 11g
    • Upgrading with the DBUA
    • Downgrading
    • Real Application Testing
    • Real Application Testing – Capture/Playback
    • Real Application Testing – Analysis
  2. Database Diagnosability and Failure Repair
    • The Oracle Fault Infrastructure
    • adrci Command Interpreter
    • Recovery Advisors
    • Data Corruption
  3. Database Administration
    • Memory Management
    • Manual Memory Management
    • Automated Maintenance Tasks
    • Flashback Data Archive
    • New DDL Features
    • New Index and Table Features
    • DB Administration Features
    • Miscellaneous New Features
    • Advanced Table Compression
    • New OEM Features
  4. Performance Management
    • SQL and PL/SQL Performance Enhancements
    • SQL and PL/SQL Performance
    • Adaptive Cursor Sharing
    • Result Caching
    • Automatic SQL Tuning
    • Optimizer Statistics
    • OEM Enhancements
  5. Database Security
    • Database Security
    • Enhanced Default Security
    • Password Enhancements
    • Tablespace Encryption
    • UTL_* Networking Packages
  6. Backup and Recovery
    • RMAN Enhancements
    • Multisection Backups
    • Backup Management
    • Active Database Duplication
    • Recovery Catalog Management
  7. Data Pump
    • Data Pump Enhancements
    • Compression and Dump Files
    • Remapping Data
    • Partition Export/Import
    • Ignoring Errors, External Tables
  8. Storage Management and ASM
    • General ASM Knowledge
    • Storage Management and ASM
    • ASM Upgrade
    • ASM Preferred Reads
    • The asmcmd Command-Line Tools
    • asmcmd Commands
    • Metadata Backup and Restore
    • md_backup and md_restore
    • Oracle Direct NFS
  9. Application Development
    • New PL/SQL Features
    • Subprogram Call Enhancements
    • Trigger Enhancements
    • XMLDB Enhancements
    • APEX – Application Express
  10. Data Warehousing
    • Next-Generation LOBs (SecureFiles)
    • Using SecureFiles
    • db_securefile Parameter
    • Partition Change Tracking
    • Pivot Operators
    • Partitioning
    • Extended Composite Partitioning
    • Virtual Column and System Partitioning

.