This 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.
Oracle Training Prerequisites
- The course Introduction to Oracle9i SQL
- The course Introduction to Oracle9i PL/SQL Language
- The course Introduction to Oracle9i Advanced SQL
Oracle Training Audience
This 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.
Oracle Training Course duration
5 Days
Oracle Training 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
