Oracle 11g New Features for Developers Training

Course #:WA1633

Oracle 11g New Features for Developers Training

This one (1) day course gives students the opportunity to learn about and practice with the new developer-related features and enhancements in Oracle Database 11g Release 1. Students examine the benefits and use of the new features in hands-on practice sessions to reinforce their understanding of the new developer capabilities in Oracle Database 11g Release 1.


At the end of this course the students should be able to:

  • Understand the Upgrade Paths to Oracle 11g Release 1
  • Identify and Use the Application Development New Features and Enhancements
  • Use the SQL Performance Analyzer


Oracle Database Developers.


At least 6 months of Oracle Database developer experience.


One day

Outline of Oracle 11g New Features for Developers Training

1. Oracle Database 11g Release 1: Upgrade Paths

2. Application Development New Features 

  • Client-Side Query Cache
  • Sequences in PL/SQL Expressions
  • Named and Mixed Notation for PL/SQL Programs in SQL
  • New Compound Trigger Type
  • PL/Scope
  • PL/SQL CONTINUE Statement

3. Performance Enhancements 

  • Automatic SQL Tuning
  • SQL Performance Analyzer Overview
  • SQL Performance Analyzer Data Dictionary Views
  • SQL Plan Management Overview
  • SQL Plan Baseline Architecture

4. Miscellaneous New Features and Enhancements

We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.