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

5 Days

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: