Oracle 11G New Features for 10G Developers

Audience

Developers on existing platforms wishing to take on the new features offered by Oracle 11G.

Prerequisites

Delegates should be familiar with Oracle SQL and PL/SQL development environments at a previous release level of Oracle.

Duration

2 days. Hands on.

Course Objectives

The course is intended for Oracle development specialists who need to familiarise themselves with the new development features embodied in the ORACLE 11G database. The course covers a wide range of topics showing the main changes in techniques used by developers.

Course Content

Overview of enhancements and new features for developers
Oracle configuration parameter changes
New parameters
Deprecated Parameters spfile changes

ASM - Automatic storage management enhancements

Rman enhancements
Flashback new features
Transaction backout
Data Archives

Standby database enhancements
lost-write detection
Archive log compression
Physical standby real time query
Snapshot databases

Data Pump new features

Oracle security enhancements
Password related changes
Fine grained access control new features
Tablespace Encryption
Oracle Data Warehousing new features
Interval, reference, system partitioning
extended composite partitioning
Virtual columns
Materialized View enhancements
pivot and unpivot clauses
Table Compression

SQL enhancements
Invisible Indexes
DDl locking changes
new add column functionality
read only tables
SQL query result cache

PL/SQL enhancements
Trigger enhancements
- Created enabled/disabled
- Follows clause
- Compound
Inlining
function result cache
Dynamic SQL enhancements
Ref cursor enhancements
sequence enhancement
continue statement
Bind aware peeking views

XMLDB new features
Binary XML storage
partitioning support XMP
XQuery enhancements
XML DB Repository enhancements
XML Developers Kit
XML index support
XML columns,tables,partitions
XML schema

Java new features
JDK support in 11g
JDBC 4.0 support