Oracle SQL Performance Tuning
- Offered byCoursera
- Public/Government Institute
Oracle SQL Performance Tuning at Coursera Overview
Duration | 7 hours |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
Oracle SQL Performance Tuning at Coursera Highlights
- Earn a certificate of completion
- Add to your LinkedIn profile
- 17 quizzes
Oracle SQL Performance Tuning at Coursera Course details
- What you'll learn
- Compose and optimize indexes for query performance
- Evaluate the utilization of indexes within your queries
- This course is designed to provide you with skills needed to improve query performance in Oracle databases
- In real-world scenarios, slow report generation and query execution often result from the sheer volume of data
- To address this issue, this course covers topics such as Query Compilation and Execution, Indexing, Materialized Views, Common Table Expressions etc
- Upon completion, you will master SQL-level performance tuning and eliminating query bottlenecks. Our unique approach showcases query execution before and after applying tuning techniques, ensuring a comprehensive grasp of optimization methods
Oracle SQL Performance Tuning at Coursera Curriculum
Understanding Necessity of SQL Tuning
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
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
Graded Quiz: Understanding Necessity of SQL Tuning
Understanding Necessity of SQL Tuning
Query Optimization Techniques
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
Practice Quiz: Query Compilation & Execution
Practice Quiz: Tracing Query Execution Techniques
Graded Quiz: Tracing Query Execution Techniques
Tracing Query Execution Techniques
Indexing Strategies
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
Practice Quiz: Introducing Indexes
Practice Quiz: Bitmap Index
Practice Quiz: Query Optimization - Indexes
Graded Quiz: Query Optimization - Indexes
Query Optimization - Indexes
Performance Tuning Tools and Techniques
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
Practice Quiz: Understanding Hints
Practice Quiz: Inline Views
Practice Quiz: Temporary Tables
Practice Quiz: Common Table Expression
Practice Quiz: Materialized Views
Graded Quiz: Performance Tuning Tools and Techniques
Query Optimization - Hints, Inline Views & Temporary Tables
Query Optimization - Common Table Expressions & Materialized Views
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?