Oracle Advanced SQL via EXPLAIN PLAN

Course Code: ORAASE
Currency: 10g & 11g
Duration: 4 days
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.
View full outline in PDF formatDetailed Outline Bookmark and Share

print  |  top of page