If you have already taken the first course in the Oracle8 Performance Tuning Certification Series,
Performance Tuning Basics, or the second course, Tuning the Oracle Instance, much of the information in this module will not be new to you.
Because each course is unique, however, make sure that you read the course-specific information about what you should expect in this course.

1. This course is the third in the five-part Oracle8 Performance Tuning Certification Series
2. This course takes an in-depth look into the concepts and skills you need to tune Oracle with SQL.
3. I will teach you an understanding of the broader issues of tuning with SQL
4. We willl delve into tuning with the Optimizers, the Explain Plan Utility, Hints, and other tuning techniques.

After completing this course, you will be able to tune all Oracle SQL and take the actions required to ensure optimal SQL performance.

After completing the course, you will be able to:

1. Define the major features of Oracle SQL
2. Tune using ANSI extensions
3. Tune using the Explain Plan Utility
4. Understand SQL Optimizer modes
5. Tune using the rule-based optimizer
6. Tune using the cost-based optimizer
7. Tune using SQL hints

Upon completion of this course, you will have the skills required to quickly identify and correct non-optimal SQL.
You will also develop the knowledge necessary to prepare you to pass
Exam 4 in the Database Administrator Track of the Oracle Certified Professional (OCP) exam series.
If you want to read more about the Oracle Certified Professional (OCP) program and learn the best strategies for passing the OCP exams.
If you have already taken the first course in this series, then you may already be somewhat familiar with this material. In either case, this PDF file provides you with a helpful resource for preparing to pass an OCP.

The five courses in the series allow you to delve in detail into the various concepts that comprise Oracle performance tuning.

1. Performance Tuning Basics
2. Tuning the Oracle Instance
3. Tuning Oracle SQL
4. Tuning the External Oracle Environment
5. Advanced Oracle Tuning Concepts

In this course, you will learn and practice SQL tuning with the following widgets:

1. SlideShow
2. MouseOver,

Tuning Oracle SQL is the third of five courses in the Oracle8 Performance Tuning Certification Series
Certification Series.