This Oracle 11g textbook will present some of the most advanced features available to database developers. In addition to receiving the print copy of this textbook, all students may receive e-Learning modules.

This textbook can be used for advanced self-study, or for instructor-led training in both in-class or virtual-class environments. Textbooks can also be used for ongoing reference long after the course is completed.

The following Sideris courses are mandatory prerequisites:

• ORACLE DATABASE 11g R2: INTRODUCTION TO SQL

• ORACLE DATABASE 11g R2: PROGRAM WITH PL/SQL

MOVING DATA: EXPORT & IMPORT

SECURITY ENHANCEMENTS

ORACLE SECUREFILES

INDEXES WITHIN THE APPLICATION SCHEMA

ADVANCED TABLES: CLUSTERS & IOTS

ADVANCED TABLES: EXTERNAL TABLES

ADVANCED TABLES: SPECIALIZED TABLES

PROCESSING HIERARCHIES

USING THE DATABASE RESULT CACHE

SQL NEW & ADVANCED FEATURES

PL/SQL PROGRAMMING ENHANCEMENTS

EDITION - BASED REDEFINITION

REDEFINITION WITH CROSS - EDITION TRIGGERS

Many of the new features are either newly available with the Oracle 11g release or have been substantially improved with that release. Among the specific subjects presented in this course are:

 

• Creating and using directory objects within the database.

 

• A comprehensive look at all index types available when building an application schema, including B-tree internals, function-based, compressed, reverse key, invisible, linguistic, bitmap and bitmap join indexes.

 

• A comprehensive look at all table types available when building an application schema, including heap-organized tables, index clusters, hash clusters, index-organized tables, external tables, temporary tables, read-only and compressed tables.

 

• Advanced SQL hierarchal data processing capabilities available from the CONNECT BY PRIOR and related language structures.

 

• Enhanced SQL and transactional capabilities, including asynchronous commits, DML error trapping and use of regular expressions.

 

• How to use the result cache to achieve dramatic performance improvement for frequently executed SQL queries and PL/SQL functions.

 

• Enhancements to the PL/SQL programming language and coding capabilities.

 

• New and advanced SQL language application development capabilities.

After some weeks or months of PL/SQL programming experience, it is strongly recommended that the following Sideris course be taken next:

• ORACLE DATABASE 11G R2: ADVANCED PL/SQL PROGRAMMING & TUNING