Oracle Advanced SQL Via Explain Plan

Currency: 10g & 11g Audience: SQL*Plus application developers, DBAs and system administrators. Prerequisites: Minimum of 6-months of SQL*Plus and PL/SQL developer experience or its equivalent. Summary: This course focuses on best practices and performance issues as these relate to Oracle SQL and PL/SQL. To this end, the Oracle EXPLAIN PLAN and related monitoring tools are central.
As the EXPLAIN PLAN facility assumes firm grounding in Oracle's:

• Indexing options
• Cost-Based Optimizer (CBO) statistics
• I/O types (access paths)
• Partitioning options
• PL/SQL good practices
• Etc.

these are covered in much detail. Objectives: Upon completion of this intensive hands-on course, the delegate should feel comfortable when working with the 'Core Topics' (in the detailed outline), especially SQL query optimisation.