Login

Oracle SQL Tuning

Self Paced Learning
  • 1 Year 24/7 access
  • Learn at your own pace
  • Your Course, Your Time, Your Comfort
  • Doubts clarifications via call/mail/WhatsApp
  • Recommended for busy/working professionals

Buy now (₹15,000, $215)

Course Curriculum

  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 Instructor

Muralidhar Punyala (Murali), is the course instructor for this course and also the founder of Uclid IT School.

Murali is a certified IT Professional with 27 years of Global IT experience on Oracle Database and Cloud Technologies. Murali's core skills include - Oracle DBA, Oracle RAC, Performance Tuning, Oracle Exadata, Oracle Cloud and AWS Cloud. Throughout his career Murali worked with various global IT companies in India, USA, UK, Singapore and Hong Kong. Murali also worked with Oracle India as a Practice Manager.

Course Videos

Buy now (₹15000, $215)

We will mail you access details upon payment

Course Materials

Slides
Lab Guide

SQL Performance Fundamentals

SQL Performance Fundamentals
Preview

Optimizer Fundamentals

SQL Processing
Preview
Optimizer Concepts
Preview

Execution Plans

About Execution Plans
Reading Execution Plans
Generating Execution Plans using SQL*Plus AUTOTRACE
Generating Execution Plans using EXPLAIN PLAN

Access Paths

Concepts
Lab Practices

Join Methods

Concepts
Lab Practices

Optimizer Statistics

About Optimizer Statistics
When and How Database gathers Optimizer Statistics?
Configuring Options for Optimizer Statistics gathering
Gathering Optimizer Statistics
Lab Practices: Gathering Optimizer Statistics
Histograms
Lab Practices: Histograms
Extended Statistics: Column Group Statistics
Extended Statistics: Expression Statistics
Lab Practices: Extended Statistics
Controlling the use of Optimizer Statistics
Lab Practices: Controlling the use of Optimizer Statistics

Optimizer Controls

Using Hints
Lab Practices: Using Hints
Cursor Sharing, Adaptive Cursor Sharing

SQL Monitoring

Monitoring SQLs

SQL Tracing

Tracing SQLs

SQL Tuning Set

SQL Tuning Set (STS)

SQL Tuning Advisor

Concepts
Lab Practices

SQL Access Advisor

SQL Access Advisor

SQL Profiles

SQL Profiles

SQL Plan Management (SPM)

Concepts
Lab Practices

Migrating Stored Outlines

Migrating Stored Outlines to SQL Plan Baselines
Buy now (₹15,000, $215)