Oracle Database 11g R2 - New and Advanced Features for Developers

This Oracle Database 11g R2: New & Advanced Features for Developers training class presents some of the most advanced features available to database developers, which can be used to extend the capabilities and flexibility of business applications. The target audience for this course is senior application developers.


Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

  1. Create directory objects within the database.
  2. Explore all index types available when building an application schema, including B-tree internals, function-based, compressed, reverse key, invisible, linguistic,
  3. bitmap and bitmap join indexes.
  4. Explore 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
  5. Access advanced SQL hierarchical data processing capabilities available from the CONNECT BY PRIOR and related language structures.
  6. Explore enhanced SQL and transactional capabilities, including asynchronous commits, DML error
  7. trapping and use of regular expressions.
  8. Learn how to use the result cache to achieve dramatic performance improvement for frequently
  9. executed SQL queries and PL/SQL functions.
  10. Learn about enhancements to the PL/SQL programming language and coding capabilities.
  11. Learn about new and advanced SQL language application development capabilities.
  1. Moving Data: Export and Import
    1. Manage Directory Objects
    2. About the Data Pump Architecture
    3. Data Pump Export
    4. Data Pump Import
  2. Security Enhancements
    1. Transparent Data Encryption
    2. What Is a Database Wallet?
    3. TDE Encryption Algorithms
    4. Column Encryption
  3. Oracle Securefiles
    1. LOB Concepts and Terminology
    2. Basic Files LOB
    3. Table DDL With LOBs
    4. Controlling LOB Physical Storage
    5. Initialize Internal LOBs
    6. Initialize External LOBs
    7. LOB Columns and SQL
    8. Secure Files LOBS
    9. Migrating Basic Files to Secure Files
  4. Indexes within the Application Schema
    1. B-tree Indexes
    2. Indexes and Performance
    3. Rebuild and Coalesce Indexes
    4. Creating Very Large Indexes
    5. Data Dictionary Storage
    6. Function-based Indexes
    7. Compressed Indexes
    8. Reverse-key Indexes
    9. Bitmap Indexes
    10. Bitmap Join Indexes
    11. Linguistic Indexes
    12. Invisible Indexes
  5. Advanced Tables: Clusters and IOTS
    1. About Index Clusters
    2. About Hash Clusters
    3. About Index-organized Tables
    4. Defining Index-organized Tables
  6. Advanced Tables: External Tables
    1. About External Tables
    2. Creating the Table
    3. ORACLE_LOADER Access Parameters
    4. The General Access Parameters
    5. Access Parameters Which Define Fields
    6. Performance Considerations
    7. ORACLE_DATAPUMP Access Driver
    8. Managing External Table Properties
  7. Advanced Tables: Specialized Tables
    1. Temporary Tables
    2. Compressed Tables
    3. Read-only Tables
    4. Column Default Values
    5. Virtual Columns
    6. Unused Columns
  8. Processing Hierarchies
    1. Why We Need Hierarchies
    2. Processing 1:N Hierarchies
    3. Oracle-specific Form
    4. ANSI/ISO Standard SQL Form
    5. Processing M:N Hierarchies
    6. Bill-of-materials (Explosion and Implosion)
    7. More Explosion Examples
    8. More Implosion Examples
    9. Advanced Hierarchy Processing
  9. Using the Database Result Cache
    1. About the Result Cache
    2. Configuring the Result Cache
    7. Using the Result Cache
    8. Managing and Monitoring Result Cache
    9. Managing the Cache with DBMS_RESULT_CACHE()
    10. Monitoring the Cache with the System Views
  10. SQL New and Advanced Features
    1. Asynchronous Commit Options
    2. Handling DML Errors
    3. Influencing Locking Behavior
    4. Regular Expressions
  11. PL/SQL Programming Enhancements
    1. Program Logic Enhancements
    2. Database-resident Triggers
    3. Using Compound Triggers
    4. Edition-based Redefinition
    6. Why Online Redefinition?
    7. Edition-based Architecture
    8. Implementing Editions
    9. Using Editions
  12. Redefinition with Cross-edition Triggers
    1. Redefinition Theoretical Challenges
    2. Forward Cross-edition Triggers
    3. Reverse Cross-edition Triggers
    4. Post-upgrade Tasks
    5. Prepare to Transform Legacy Data
    6. Transform Legacy Data
    7. Retire The Old Application
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Oracle class:

  • Introductory experience with SQL.
  • Experience with Oracle PL/SQL queries
Prerequisite Courses

Courses that can help you meet these prerequisites:

Training for Yourself

$2,875.00 or 5 vouchers

Upcoming Live Online Classes

Please select a class.

Training for your Team

Length: 5 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

Webucator online training using WebEx works great! There seem to actually be fewer technical difficulties and disruptions overall than in traditional class trainings. Group discussions work well and the ability to share and display other trainee screens can help the whole class. Not having to travel to a training center was also a bonus!
Paul Gettmann
This was my first online class with Webucator. I'm sure it won't be my last.
Robert Hawthorne
Firebox Training
Great course! Instructor was very supportive and easy to understand as she walked us through the program.
Kimberley Barnes
British Columbia Wine Institute
Fantastic - I would suggest to anyone struggling with PowerPoint!
Nick Alexander
Associated Global Systems

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing


Students who have taken Instructor-led Training


Organizations who trust Webucator for their Instructor-led training needs


Satisfaction guarantee and retake option


Students rated our trainers 9.29 out of 10 based on 29,912 reviews

Contact Us or call 1-877-932-8228