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 10g > Oracle Database 10g: New & Advanced Features For Developers Training

Oracle Database 10g: New & Advanced Features For Developers Training

Course#: WA1384

The purpose of this course is to present some of the most advanced features available to database developers. Many of these features are either newly available with the Oracle10g release or have been substantially improved with that release.

Objectives

Among the specific subjects presented in this course are:

  • A review of the grid-computing and manageability architecture available from the Oracle 10g release of the database and the application server.
  • Database flashback technology, including flashback queries, flashback table, flashback versions query and flashback transaction query capabilities.
  • Creating and using directory objects within the database.
  • The Data Pump Export and Import utilities.
  • A comprehensive look at all index types available when building an application schema, including B-tree internals, function-based, compressed, reverse key, 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 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.
  • Enhanced PL/SQL programming capabilities and compiler directives.
  • A brief glimpse into the Enterprise Manager database interface which may be of occasional use to senior developers.

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

  The following courses are mandatory prerequisites:

  • ORACLE DATABASE 10G: INTRODUCTION TO SQL – COMPLETE LIBRARY
  • ORACLE DATABASE 10G: PROGRAM WITH PL/SQL – COMPLETE LIBRARY

Also, as indicated above the course ORACLE DATABASE 10G: SQL TUNING should ideally be taken prior to this course but it is an acceptable alternative to complete that course after finishing this one.

Finally, while not mandatory, the courses ORACLE DATABASE 10G: ARCHITECTURE FOR DEVELOPERS and ORACLE DATABASE 10G: ADVANCED PL/SQL PROGRAMMING & TUNING are suggested and very helpful prerequisites.

Duration

4 days.

Outline of WA1384 Oracle Database 10g: New & Advanced Features For Developers Training

1. ORACLE FLASHBACK TECHNOLOGY 

  • ABOUT FLASHBACK TECHNOLOGY
  • FLASHBACK QUERY
  • FLASHBACK TABLE
  • FLASHBACK DROP
  • FLASHBACK VERSIONS QUERY
  • FLASHBACK TRANSACTION QUERY
  • Querying FLASHBACK_TRANSACTION_QUERY
  • GUARANTEE UNDO RETENTION

2. MANAGING DATA: EXPORTING & IMPORTING DATA

  • CREATE DIRECTORY OBJECTS
  • ABOUT THE DATA PUMP ARCHITECTURE
  • DATA PUMP EXPORT
  • DATA PUMP IMPORT
  • DATA PUMP DATA DICTIONARY VIEWS
  • USING THE EM INTERFACE

3. INDEXES WITHIN THE APPLICATION SCHEMA

  • B-TREE INDEXES
  • FUNCTION-BASED INDEXES
  • COMPRESSED INDEXES
  • REVERSE-KEY INDEXES
  • BITMAP INDEXES
  • BITMAP JOIN INDEXES
  • LINGUISTIC INDEXES
  • ACCESSING INDEX OBJECTS USING THE EM INTERFACE

4. ADVANCED TABLES: CLUSTERS & IOTS

  • ABOUT INDEX CLUSTERS
  • ABOUT HASH CLUSTERS
  • ABOUT INDEX-ORGANIZED TABLES

5. ADVANCED TABLES: EXTERNAL TABLES

  • ABOUT EXTERNAL TABLES
  • ORACLE_LOADER ACCESS PARAMETERS
  • RECORDS Parameter
  • BADFILE Parameter
  • LOGFILE Parameter
  • DISCARDFILE Parameter
  • LOAD WHEN Parameter
  • SKIP Parameter
  • The LOCATION Clause
  • REJECT LIMIT Clause
  • FIELDS TERMINATED BY Parameter
  • MISSING FIELD VALUES Parameter
  • ORACLE_DATAPUMP ACCESS DRIVER
  • VIEWING & ALTERING PROPERTIES OF EXTERNAL TABLES
  • USER_EXTERNAL_TABLES
  • USER_EXTERNAL_LOCATIONS
  • Using ALTER TABLE

6. ADVANCED TABLES: TEMPORARY & COMPRESSED TABLES

7. PROCESSING HIERARCHIES

  • WHY WE NEED HIERARCHIES
  • PROCESSING 1:N HIERARCHIES
  • PROCESSING M:N HIERARCHIES
  • BOM Data Model
  • ADVANCED HIERARCHY PROCESSING
  • CONNECT_BY_ROOT()
  • CONNECT_BY_ISLEAF

8. SQL NEW & ADVANCED FEATURES

  • ASYNCHRONOUS COMMIT OPTIONS
  • HANDLING DML ERRORS
  • REGULAR EXPRESSIONS
  • COLUMN ENCRYPTION
  • MISCELLANEOUS ENHANCEMENTS

9. PL/SQL NEW & ADVANCED FEATURES

  • HANDLING STRING LITERALS
  • DATABASE TRIGGER ENHANCEMENTS
  • COMPRESSION WITH UTL_COMPRESS()
  • LZ_COMPRESS()
  • LZ_UNCOMPRESS()
  • COLLECTION ENHANCEMENTS
  • MISCELLANEOUS ENHANCEMENTS

10. INFLUENCING ORACLE10G PL/SQL COMPILATION

  • PLSQL_WARNINGS
  • PLSQL_OPTIMIZE_LEVEL
  • PL/SQL NATIVE EXECUTION
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.