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

Course Schedule

  • 24-27 August
  • 28 September-1 October
  • 26-29 October
  • 30 November-3 December

Price: £1,395+VAT
Venue: London Gatwick

Book Course

Course Outlines

Detailed course outlines are available in PDF format. Download Adobe's Acrobat Reader free from: www.adobe.com
Get Acrobat Reader

Training Topics

GENERAL

print  |  top of page