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.

  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

Training for Yourself

$2,875.00 or 5 vouchers

Upcoming Live Online Classes

  • See More Classes

Please select a class.
  • Live Online Training
  • For Individuals
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

What people say about our training

I liked that the class was extremely hands-on and helped to cement the ideas with the exercises following each area. It was great to get the knowledge I needed without having to take time off of work or be out of the office.
Megan Robertson
Indiana Republican Party
Excellent class for the "sometime" user of Excel, I learned how to be more efficient and make my spreadsheets look like a professional.
Laura Baker
CRB Auto Finance
I always enjoy taking technical training courses with Webucator. I've always been very satisfied with the results. The instructors have solid knowledge of what they're teaching and they have high degree of professionalism that they always show to their students.
Rey de los Reyes
Social Security Administration
The course material was presented at a good pace and the labs helped me see how the concepts that were presented actually work in practice.
Dan Dougherty
Andesa Services

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,183 reviews

Contact Us or call 1-877-932-8228