back to Course Categories | back | print
Oracle 11g New Features for Developers          

Duration: 3 days

Description 
This course will take a comprehensive look at the new features in Oracle11g for developers. These new features will add significant functionality to Oracle based applications. Topics will include the new SQL features, PL/SQL enhancements, new syntax and enhancements to Oracle development environments.

Topics

  • SQL Enhancements
  • Optimizer hints
  • CREATE/ALTER TABLE
  • Edition-Based Redefinition
  • Multi-column Statistics
  • In-Memory Parallel Execution
  • Online Redefinition Enhancements
  • Fine Grained Dependencies
  • Utility features
  • Oracle SecureFiles
  • Extended Statistics
  • Table Compression
  • Partition Features
  • SQL Plan Management
  • Adaptive Cursor Sharing
  • Read Only Tables
  • Index features
  • Table lock enhancements
  • Virtual columns
  • Invisible indexes
  • WAIT option for DDL statements
  • Encryption features
  • PL/SQL enhancements
  • Triggers
  • Compound triggers
  • Trigger FOLLOWS and PRECEDES
  • SIMPLE_INTEGER, SIMPLE_FLOAT and SIMPLE_DOUBLE
  • Inline sequence calls
  • Result Cache
  • Dynamic SQL
  • Compiler options
  • Flashback enhancements
  • Database Replay
  • DBMS_SQL features
  • Convert REF CURSOR to DBMS_SQL cursor
  • Convert DBMS_SQL cursor to REF CURSOR
  • User-defined types and bulk binds
  • Gather Stats
  • Security enhancements
  • Data Warehousing
  • Pivot and Unpivot operations
  • Wildcards and alias pivot operations
  • Cross-tab queries and pivot
  • Flashback new features
  • DBMS_COMPARISON
  • ACL
  • XML enhancements
  • XMLTYPE Data Indexes
  • XMLCAST, XMLEXISTS, XMLPATCH, XMLDIFF
  • Data Pump and External Table additions

Prerequisites
Strong Oracle10g development experience is strongly recommended. Experience with SQL, PL/SQL, SQL*Plus, and Oracle environments is required to successfully complete the course.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design