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.

Course Topics
  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 your Team

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

What people say about our training

I was a SharePoint novice, but this class really opened my eyes to the possibilities of Designer.
Jane Roegner
Federal Emergency Management Agency (FEMA)
Great instructor!
Yung (Tony) Feng
Social Security Administration
Great teacher. She really made sure you understood what she was showing you and made it fun.
Andrea Orellana
REIG Asset Management
The instructor was very thorough and knowledgeable. Very patient and very good at making us understand everything. Would definitely take additional classes.
Dorothy Ferrell
KIA Insurance Associates

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.30 out of 10 based on 30,402 reviews

Contact Us or call 1-877-932-8228