Oracle9i New & Advanced Features for Developers

This 5-day course is designed for senior application developers who will be moving to the Oracle9i database platform. This course introduces the new and advanced features of the database introduced in its 9i release.

Target audience

This course has been developed for Oracle application developers who have experience with Oracle8i and wish to exploit the advanced features introduced in Oracle9i. Students are recommended to have attended the following course or have the equivalent knowledge and experience:

• Introduction To Oracle9i SQL
• Introduction To Oracle9i Advanced SQL
• Introduction To Oracle9i PL/SQL Language

Course content

Using ISQL*PLUS Using ISQL*PLUS • Configuring ISQL*PLUS

Advanced SQL language constructs Case statement within PL/SQL • Case expression within SQL • COALESCE() function

Retrieving DDL with DBMS_METADATA() Why retrieve object definitions? • Retrieving default metadata • Retrieving customized metadata

Advanced DBMS_METADATA() processing

Processing dependent objects with DBMS_METADATA() Retrieving primary and dependent object DDL

Redefining tables with DBMS_REDEFINITION() Using the DBMS_REDEFINITION() package

Data waterhousing features (external tables) About external tables • Creating and accessing external tables • Performance considerations • Viewing and altering properties of external tables

Data warehousing features (table functions) Implementing a pipelined table function

Data warehousing features (analytic functions) Understanding analytic functions • Using ranking and banding functions • Using windowing functions • Using flagging and leading functions • Using reporting aggregates

Complex SQL operations Using multi-table insert methods • Using the merge statement • Using ANSI standard joins • Using named subqueries

SQL statement tuning About enhanced SQL statement tuning • FIRST_ROWS • Oracle9i SQL tuning hints • Cursor peeking and cursor sharing • Monitoring index usage

Editing private outlines About editing private outlines • Preparing for private outlines • Creating private outlines • Editing private outlines • Utilizing private outlines

Collecting system statistics Managing system statistics

Flashback query Implementing flashback query • About the DBMS_FLASHBACK() package • Using the DBMS_FLASHBACK() package

Workspace manager Workspace operations • Handling conflict resolution • Utilizing savepoints • Session information and DDL operations • A complete Workspace Manager scenario

Invoking external features

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today