|
ORA05DEV-9i-09-SG
Oracle 9i New & Advanced Features for Developers (5 day)
Description
This course is designed for senior application developers who will be moving to the Oracle 9i database platform. This course introduces the new and advanced features of the database introduced in its 9i release.
Audience
Target audience for this course is for senior Oracle developers who have experience with Oracle 8i and wish to exploit the advanced features introduced in Oracle 9i.
Prerequisites
• The Sideris course Introduction to Oracle 9i SQL
• The Sideris course Introduction to Oracle 9i PL/SQL Language
• The Sideris course Introduction to Oracle 9i Advanced SQL
Course Outline
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 & DEPENDENT OBJECT DDL
REDEFINING TABLES WITH DBMS_REDEFINITION() • USING THE DBMS_REDEFINITION() PACKAGE
DATA WAREHOUSING FEATURES (EXTERNAL TABLES) • ABOUT EXTERNAL TABLES • CREATING & ACCESSING EXTERNAL TABLES • PERFORMANCE CONSIDERATIONS • VIEWING & 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 LAGGING 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 & 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 & DDL OPERATIONS • A COMPLETE WORKSPACE MANAGER SCENARIO
INVOKING EXTERNAL FEATURES
| 
