SkillBuilders Welcome  |  Log in
All Oracle Classes

Oracle SQL Tuning Training with Oracle Press Exam Guide Author John Watson
3 Day Onsite or 21 Hour Online Hands-On Classes

*** ALL NEW FOR 12c ***

Tuning SQL is a science, not an art. In this class you will learn how to discover what the Oracle Cost Based Optimizer is doing with your SQL, and why it is doing it that way. Then learn how to make the CBO do it better. The techniques presented let you reverse engineer the CBO's decisions, experiment with alternatives, and then push the CBO towards better decisions.

This is an intense course;  students should expect to be thoroughly engaged during class.  Students attending the online course should expect some homework.  Students who are fairly new to Oracle Database and SQL should consider our 1-Day SQL Tuning: Core Skills for Beginners class. 

"So far, it's the best formal training I have had as a DBA. Thank you, Rachel F. OCP, OCE DBA"

Thank you,
Rachel Fritts OCP, OCE

"John [Watson] is super knowledgable about the subject, and is able to explain the topics very clearly. Great instructor as always."

"John was an excellent teacher and I thought the content of the course was very good, but John's examples and what he showed at the command line was what made it really sink in."

John Watson
Average Student Rating:

Students must have the ability to write SQL statements, some familiarity with database and instance architecture.  For example, you should know what the buffer cache and the library cache are.  You should also know the basic difference between a database and an instance. You must also know the basics of the Oracle Data Dictionary.  For example, you should know what DBA_INDEXES (or USER_INDEXES) is and the basics of what it contains.

SkillBuilders Sample Video