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.

Location

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.

Goals
  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.
Outline
  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
    3. RESULT_CACHE_MAX_SIZE
    4. RESULT_CACHE_MODE
    5. RESULT_CACHE_MAX_RESULT
    6. RESULT_CACHE_REMOTE_EXPIRATION
    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
    5. DBMS_RESULT_CACHE()
    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

This was one of the best courses I have every taken. The fact that it was delivered online just puts it "Totally Over The TOP!" AWESOME!
Michael Crawley
Jenai
Very knowledgeable instructor. Easy to work with and ask questions.
Buddy Giles
U.S. Postal Service
Object-Oriented Programming in C# is a great starting point for anyone who needs/wants to enter the .NET world. It covers both the paradigm and vocabulary of object-oriented programming and the language itself. As an old-time mainframe programmer, this was a passage way to the new world!
Elizabeth McRae
Community One Bank
Great class to truly get a great foundation and good feel for Java programming.
Brent Bullock
Advantest America Inc

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

63,829

Students who have taken Instructor-led Training

11,920

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.30

Students rated our trainers 9.30 out of 10 based on 29,938 reviews

Contact Us or call 1-877-932-8228