Oracle SQL Tuning for Beginners Free Tutorial
Duration: 50 hours

Teacher

John Watson

Curriculum

Free Oracle DBA Tutorials, Free Oracle Developer Tutorials

Review

No reviews yet.

Free

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: http://www.skillbuilders.com/oracle-sql-tuning-training-for-beginners

No Events Scheduled at this time. Call (888) 803-5607 or email us to schedule this class.

Tutorial Lessons 0/10
- Lecture1.1
  
  Agenda
  Preview
  
  1m
- Lecture1.2
  
  The Purpose of SQL Tuning / When and Why to Tune SQL
  
  5m
- Lecture1.3
  
  How SQL Executes – SQL Execution Cycle
  
  3m
- Lecture1.4
  
  How SQL Executes – Parse
  
  3m
- Lecture1.5
  
  How SQL Executes – Bind
  
  8m
- Lecture1.6
  
  How SQL Executes – Execute and Fetch
  
  5m
- Lecture1.7
  
  The Cost Based Optimizer
  
  8m
- Lecture1.8
  
  A Tuning Methodology
  
  4m
- Lecture1.9
  
  How to Read an Execution Plan, Part 1
  
  4m
- Lecture1.10
  
  How to Read an Execution Plan, Part 2
  
  11m