Course Highlights
  • Compose and optimize indexes for query performance
  • Evaluate the utilization of indexes within your queries
Curriculum

27 Topics
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
Char Vs Varchar - Part 1
Char Vs Varchar - Part 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
Data Types in Oracle
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

15 Topics
Introduction to Query Optimization Techniques
Compilation and Execution Part 1
Compilation and Execution Part 2
Compilation and Execution Part 3
Bind Variables 1
Bind Variables 2
Explain Plan part 1
Explain Plan part 2
AutoTrace Part 1
AutoTrace Part 2
Explain Plan - Compilation
Graded Quiz: Tracing Query Execution Techniques
Practice Quiz: Query Compilation & Execution
Practice Quiz: Tracing Query Execution Techniques
Tracing Query Execution Techniques

18 Topics
Introduction to Indexing Strategies
Introducing Indexes 1
Introducing Indexes 2
Introducing Indexes 3
Bitmap Index Part 1
Bitmap Index Part 2
B-Tree Index Part 1
B-Tree Index Part 2
Composite Index 1
Composite Index 2
Function-Based Index part 1
Function-Based Index part 2
Bitmap Index
Graded Quiz: Query Optimization - Indexes
Practice Quiz: Introducing Indexes
Practice Quiz: Bitmap Index
Practice Quiz: Query Optimization - Indexes
Query Optimization - Indexes

25 Topics
Introduction to Performance Tuning Tools and Techniques
Understanding Hints Part 1
Understanding Hints Part 2
Understanding Hints Part 3
Inline Views Part 1
Inline Views Part 2
Temporary Tables 1
Temporary Tables 2
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
Understanding Hints
Common Table Expression
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

  Write a Review

Oracle SQL Performance Tuning

Go to Free Course