RelationalDBDesign 





SQL Tuning  «Prev  Next»
Lesson 1
Module introduction

Welcome to Tuning Oracle SQL


Since each course is unique, make sure that you read the course-specific information about what you should expect in this course.
  1. This course takes an in-depth look into the concepts and skills you need to tune Oracle with SQL.
  2. This course will discuss the broader issues of tuning with SQL
  3. The course will 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 most Oracle SQL and take the actions required to ensure optimal SQL performance.
Course goals
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


The OCP exam series
Upon completion of this course, you will have the skills required to quickly identify and correct non-optimal SQL.
Five-part series
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. Backup Recovery Concepts
  5. Advanced Oracle Tuning Concepts

Learning Technologies
In this course, you will learn and practice SQL tuning with the following widgets:
  1. SlideShow
  2. MouseOver,
The series
Tuning Oracle SQL is the third of five courses in the Oracle Performance Tuning Certification Series
Certification Series.
The next lesson discusses the prerequisites for the course.