Introduction of the Author - Mandar Mulay
Introduction to Oracle SQL Performance Tuning - Part 1
Introduction to Oracle SQL Performance Tuning - Part 2
Introduction to Understanding Necessity of SQL Tuning
Understanding Demography of Tables 1 - Part 1
Understanding Demography of Tables 1 - Part 2
Understanding Demography of Tables 2
All 6 clauses of Select Statement - Part 1
All 6 clauses of Select Statement - Part 2
All 6 clauses of Select Statement - Part 3
The Flow of Clauses Execution
Performance Impact of Where vs Having Clause - Part 1
Performance Impact of Where vs Having Clause - Part 2
Performance impact of Distinct Group By and Count - Part 1
Performance impact of Distinct Group By and Count - Part 2
Benefits of Exists Operator 1
Benefits of Exists Operator 2
Course Introduction - Oracle SQL Performance Tuning Overview
Course Syllabus - Oracle SQL Performance Tuning Overview
Graded Quiz: Understanding Necessity of SQL Tuning
Practice Quiz: Understanding Demography of Tables
Practice Quiz: Data Types And Char Vs Varchar Datatypes from Performance Angle
Practice Quiz: Understanding Necessity of SQL Tuning
Understanding Necessity of SQL Tuning
Introduction to Query Optimization Techniques
Compilation and Execution Part 1
Compilation and Execution Part 2
Compilation and Execution Part 3
Explain Plan - Compilation
Graded Quiz: Tracing Query Execution Techniques
Practice Quiz: Query Compilation & Execution
Practice Quiz: Tracing Query Execution Techniques
Tracing Query Execution Techniques
Introduction to Indexing Strategies
Function-Based Index part 1
Function-Based Index part 2
Graded Quiz: Query Optimization - Indexes
Practice Quiz: Introducing Indexes
Practice Quiz: Bitmap Index
Practice Quiz: Query Optimization - Indexes
Query Optimization - Indexes
Introduction to Performance Tuning Tools and Techniques
Understanding Hints Part 1
Understanding Hints Part 2
Understanding Hints Part 3
Common Table Expression Part 1
Common Table Expression Part 2
Materialized Views - Part 1
Materialized Views - Part 2
Materialized Views - Part 3
Materialized Views - Part 4
Conclusion to Oracle SQL Performance Tuning
Graded Quiz: Performance Tuning Tools and Techniques
Practice Quiz: Understanding Hints
Practice Quiz: Inline Views
Practice Quiz: Temporary Tables
Practice Quiz: Common Table Expression
Practice Quiz: Materialized Views
Query Optimization - Hints Inline Views & Temporary Tables
Query Optimization - Common Table Expressions & Materialized Views