Course Length - 4 Days
Objectives
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. 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. Important Curriculum Note
One of the most substantial changes of interest to developers within the Oracle10g release is the matter of SQL tuning. The fundamental means by which this task is approached and accomplished has almost completely changed with the Oracle10g release. This is addressed separately in the one-week Dashcourses International course entitled Oracle 10G Database: SQL Tuning.
That course may be taken either before or after this course, but it should be considered as a mandatory complement to this course. Target 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. Course Prerequisites
The following Dashcourses International 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. |
