Learn Oracle SQL Tuning!
We’d like to introduce you to our SQL Tuning courses. The free video lessons below are excerpts from our “Core SQL Tuning Skills for Beginners” class.
Writing SQL that performs well means understanding what Oracle is doing to the SQL: how it is executing the code, and why it is executing it that way. Then make changes needed to let Oracle run the code in a more efficient manner.
In the complete course you will learn how to capture and read the execution plans, and how to detect and fix the common problems that prevent code from running well. The course is taught by Oracle Certified Master DBA John Watson and Expert Dave Anderson. You can attend live online training or schedule the course at your organization.
Click this link to see a description of the complete course: https://skillbuilders.com/oracle-sql-tuning-training-for-beginners
Course Features
- Lectures 10
- Quiz 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 72
- Assessments Yes
-
Tutorial Lessons
- Agenda
- The Purpose of SQL Tuning / When and Why to Tune SQL
- How SQL Executes – SQL Execution Cycle
- How SQL Executes – Parse
- How SQL Executes – Bind
- How SQL Executes – Execute and Fetch
- The Cost Based Optimizer
- A Tuning Methodology
- How to Read an Execution Plan, Part 1
- How to Read an Execution Plan, Part 2
