Course Modules


  1. Introduction to the Course
  2. SQL Performance Fundamentals
  3. Query Optimizer Fundamentals
  4. Query Execution Plans
  5. Access Paths
  6. Join Methods
  7. Optimizer Statistics
  8. Optimizer Controls
  9. Improving Performance through Cursor Sharing
  10. Monitoring SQLs
  11. Tracing SQLs
  12. SQL Tuning Sets
  13. SQL Tuning Advisor
  14. SQL Access Advisor
  15. SQL Profiles
  16. SQL Plan Management
  17. Migrating Stored Outlines to SQL Plan Baselines


Course Videos (Members only Area)

(click on PREVIEW button to play videos for sample/demo view)

  First Section
Available in days
days after you enroll
  Introduction and SQL Performance Fundamentals
Available in days
days after you enroll
  Optimizer Fundamentals
Available in days
days after you enroll
  Execution Plans
Available in days
days after you enroll
  Access Paths
Available in days
days after you enroll
  Join Methods
Available in days
days after you enroll
  Optimizer Statistics
Available in days
days after you enroll
  Optimizer Controls
Available in days
days after you enroll
  SQL Monitoring
Available in days
days after you enroll
  SQL Tracing
Available in days
days after you enroll
  SQL Tuning Sets (STS)
Available in days
days after you enroll
  SQL Tuning Advisor
Available in days
days after you enroll
  SQL Access Advisor
Available in days
days after you enroll
  SQL Profiles
Available in days
days after you enroll
  SQL Plan Management
Available in days
days after you enroll
  Migrating Stored Outlines to SQL Plan Baselines
Available in days
days after you enroll

Enroll to get Full Access