Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 11g > Oracle Database 11g R2 - New and Advanced Features For Developers Training

Oracle Database 11g R2 - New and Advanced Features For Developers Training

Course#: WA1977

This Oracle 11g courseware training guide book will present some of the most advanced features available to database developers.

Objectives

Many of the new features are either newly available with the Oracle 11g release or have been substantially improved with that release. Among the specific subjects presented in this course are:

  • Creating and using directory objects within the database.
  • A comprehensive look at all index types available when building an application schema, including B-tree internals, function-based, compressed, reverse key, invisible, linguistic, bitmap and bitmap join indexes.
  • A comprehensive look 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.
  • Advanced SQL hierarchal data processing capabilities available from the CONNECT BY PRIOR and related language structures.
  • Enhanced SQL and transactional capabilities, including asynchronous commits, DML error trapping and use of regular expressions.
  • How to use the result cache to achieve dramatic performance improvement for frequently executed SQL queries and PL/SQL functions.
  • Enhancements to the PL/SQL programming language and coding capabilities.
  • New and advanced SQL language application development capabilities.

Audience

The target audience for this course is senior application developers. Using these features one can rely upon less-frequently used database options to extend the capabilities and flexibility of business applications.

Prerequisites

At least 6 months of Oracle Database developer experience.

Duration

3 Days

Outline of WA1977 Oracle Database 11g R2 - New and Advanced Features For Developers Training

1. MOVING DATA: EXPORT & IMPORT

  • MANAGE DIRECTORY OBJECTS
  • ABOUT THE DATA PUMP ARCHITECTURE
  • DATA PUMP EXPORT
  • DATA PUMP IMPORT

2. SECURITY ENHANCEMENTS

  • TRANSPARENT DATA ENCRYPTION
  • What Is A Database Wallet?
  • TDE Encryption Algorithms
  • COLUMN ENCRYPTION

3. ORACLE SECUREFILES

  • LOB CONCEPTS & TERMINOLOGY
  • BASICFILES LOB
  • Table DDL With LOBs
  • Controlling LOB Physical Storage
  • Initialize Internal LOBs
  • Initialize External LOBs
  • LOB Columns & SQL
  • SECUREFILES LOBS
  • MIGRATING BASICFILES TO SECUREFILES

4. INDEXES WITHIN THE APPLICATION SCHEMA

  • B-TREE INDEXES
  • Indexes & Performance
  • Rebuild & Coalesce Indexes
  • Creating Very Large Indexes
  • Data Dictionary Storage
  • FUNCTION-BASED INDEXES
  • COMPRESSED INDEXES

5. REVERSE-KEY INDEXES

  • BITMAP INDEXES
  • BITMAP JOIN INDEXES
  • LINGUISTIC INDEXES
  • INVISIBLE INDEXES

6. ADVANCED TABLES: CLUSTERS & IOTS

  • ABOUT INDEX CLUSTERS
  • ABOUT HASH CLUSTERS
  • ABOUT INDEX-ORGANIZED TABLES
  • Defining Index-Organized Tables

7. ADVANCED TABLES: EXTERNAL TABLES

  • ABOUT EXTERNAL TABLES
  • Creating The Table
  • ORACLE_LOADER ACCESS PARAMETERS
  • The General Access Parameters
  • Access Parameters Which Define Fields
  • Performance Considerations
  • ORACLE_DATAPUMP ACCESS DRIVER
  • MANAGING EXTERNAL TABLE PROPERTIES

8. ADVANCED TABLES: SPECIALIZED TABLES

  • TEMPORARY TABLES
  • COMPRESSED TABLES
  • READ-ONLY TABLES
  • COLUMN DEFAULT VALUES
  • VIRTUAL COLUMNS
  • UNUSED COLUMNS

9. PROCESSING HIERARCHIES

10. WHY WE NEED HIERARCHIES

11. PROCESSING 1:N HIERARCHIES

  • Oracle-Specific Form
  • ANSI/ISO Standard SQL Form
  • PROCESSING M:N HIERARCHIES
  • Bill-of-materials (Explosion & Implosion)
  • More Explosion Examples
  • More Implosion Examples
  • ADVANCED HIERARCHY PROCESSING

12. USING THE DATABASE RESULT CACHE

  • ABOUT THE RESULT CACHE
  • CONFIGURING THE RESULT CACHE
  • RESULT_CACHE_MAX_SIZE
  • RESULT_CACHE_MODE
  • RESULT_CACHE_MAX_RESULT
  • RESULT_CACHE_REMOTE_EXPIRATION
  • USING THE RESULT CACHE
  • MANAGING & MONITORING RESULT CACHE
  • Managing The Cache With DBMS_RESULT_CACHE()
  • Monitoring The Cache With The System Views

13. SQL NEW & ADVANCED FEATURES

  • ASYNCHRONOUS COMMIT OPTIONS
  • HANDLING DML ERRORS
  • INFLUENCING LOCKING BEHAVIOR
  • REGULAR EXPRESSIONS

14. PL/SQL PROGRAMMING ENHANCEMENTS

  • PROGRAM LOGIC ENHANCEMENTS
  • DATABASE-RESIDENT TRIGGERS
  • USING COMPOUND TRIGGERS

15. EDITION-BASED REDEFINITION

16. WHY ONLINE REDEFINITION?

  • EDITION-BASED ARCHITECTURE
  • IMPLEMENTING EDITIONS
  • USING EDITIONS

17. REDEFINITION WITH CROSS-EDITION TRIGGERS

  • REDEFINITION THEORETICAL CHALLENGES
  • FORWARD CROSS-EDITION TRIGGERS
  • REVERSE CROSS-EDITION TRIGGERS
  • POST-UPGRADE TASKS
  • Prepare To Transform Legacy Data
  • Transform Legacy Data
  • Retire The Old Application
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.