Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle SQL Performance Tuning Masterclass (2026)

Name: Oracle SQL Performance Tuning Masterclass (2026)
Rating: 4.7 (9848 reviews)

Become an Expert on Oracle SQL Tuning and Solve All The Performance Problems of Your SQL Queries and the Database!

Bestseller

Highest Rated

Created byDatabase Masters | 300,000+ Successful Students Worldwide, Code Star Academy

Last updated 1/2026

English

Arabic [Auto],Bulgarian [Auto],

What you'll learn

Learn How to Solve Critical Performance Problems with Step by Step Approach!
Learn Advanced Indexing Techniques for Ultimate Database Performance!
Learn How to Use Various Performance Tuning Tools for In-Depth Assistance!
Maximize the Query Performance by Using Advanced Tuning Tecniques!
Learn Oracle Database Architecture by "Tuning" aspects.
Identify and Optimize the Performance of poorly performing (bad) SQLs.
Understand SQL Tuning Terminologies
Learn How to Create "Better" Queries
Learn How to Prioritize your SQL Tuning Efforts.
Learn the Details of How an SQL Code is Interpreted
Learn Useful Hints to improve Performance of your Queries
Learn & Improve How to Use Oracle Optimizer and Execution Plans Well
Various Tips and Tricks to make the Oracle SQL queries run faster.
Oracle Performance Tuning on both Oracle11g and Oracle12c Environment.
Learn Efficient Schema Design
Lifetime Support from the Authors.
Weekly Quizzes & Assesment Tests
Working materials and always up to date!

Course content

14 sections • 232 lectures • 20h 35m total length

SQL & Performance Tuning Course Overview4:52
This Overview lecture explains what will this course cover
UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)5:01
This lecture is about how to use the Udemy platform. And also includes some useful tips to get most of out the course.
Welcome Gift! + Course Document0:36
This lecture includes the working document of our SQL and Performance Tuning Course with a warm welcome message.

Do You Have a Running Database in Your PC?0:31
Why to know the Oracle Database Architecture and how much to know?2:31
Learning the architecture is really important for performance tuning. This lecture explains why to know it and how much to know among the whole architecture
Oracle Database Architecture Overview (Part 1)9:17
First part of the architecture overview lecture
Oracle Database Architecture Overview (Part 2)6:04
Second part of the architecture overview lecture
Database Data Blocks in Detail7:57
Data in database are stored in logical data blocks. This lecture explains the Oracle database data blocks in details.
What is PGA?5:32
One of the important part of the database architecture is PGA. You need to learn PGA to perform better tuning techniques. This lecture explains PGAs in details.
What is Shared Pool?6:31
Shared pool is very critical for parsing performance. This lecture explains shared pool and its sub-memory areas with details.
What is Buffer Cache?5:24
All the data is processed in the buffer cache. If you know buffer cache, you can perform better tuning techniques. This lecture includes the buffer cache.
What is Redo Log Buffer?4:18
Sometimes redo logs decreases the performance. This lecture explains the redo log buffer in the PGA.
What is Undo?3:49
As the name implies, undo is for undo. So you will learn how a rollback is done with undo segments
How a DML is processed and committed4:28
Automatic Memory Management2:06
Oracle Database Storage Architecture3:57
Logical and Physical Database Structure6:13
Quiz - Database Architecture

When to Tune?7:40
What is a Bad SQL?5:08
Effective Schema Design8:42
Learn to design an efficient database schema by choosing appropriate data types, enforcing primary and foreign keys, applying normalization, and using indexes and table types to boost performance.
Table Partitioning7:15
Divide a large table into smaller partitions, enabling queries to read only relevant partitions for range searches, dramatically improving performance and enabling partitioned indexes.
How an SQL Statement is Processed?9:32
Why do we need the Optimizer?5:41
Learn why the Oracle optimizer is essential for fast query execution; it analyzes schema, indexes, and statistics to choose the best execution plan and relevant access paths for efficient performance.
Optimizer Overview3:25
Explore the Oracle optimizer overview, including the query transformer, estimator, plan generator, and row source generator, and learn how cost estimates guide execution plans.
Query Transformer8:44
Selectivity & Cardinality8:02
Learn how selectivity and cardinality shape the optimizer's cost estimates and plan choices. See how distinct values and multiple columns influence estimation and when tuning guides better execution plans.
What is "cost" in detail?4:51
Plan Generator3:56
In this SQL Performance and SQL Tuning Tutorial, students will learn SQL Plan Generator.
Row Source Generator3:38
SQL Tuning Principles and Strategies8:10
Query Analysis Strategy12:58
Utilize the query analysis strategy to diagnose performance issues by checking statistics, histograms, parameters, and query structure, then analyze execution plans for access paths and joins.
SQL Tuning Basics Assessment Test

Execution Plan and Explain Plan in Details7:24
Generating Statistics (Part 1)6:16
Generate system and optimizer statistics to support realistic execution plans. Learn when to generate statistics, how to use dbms_stats.gather_system_stats, and read aux_stats$ while noting workload and hardware changes.
Generating Statistics (Part 2)7:15
Generate and manage optimizer and system statistics using dbms_stats, understand automatic vs manual gathering, and prefer dbms_stats over analyze for accurate plans on busy systems.
Generating Statistics (Part 3)8:50
Discover how to generate system statistics and optimizer statistics in Oracle using gather_dictionary_stats for SYS and SYSTEM, gather_schema_stats, gather_table_stats, and gather_index_stats with cascade true.
Generating Statistics (Code Samples)0:20
Generating Execution Plan12:06
Generating Execution Plan (Code Samples)0:09
Autotrace12:38
Learn how autotrace reveals the exact execution plan and statistics by tracing queries in SQL Plus and SQL Developer, with options on explain, statistics, traceonly, and closing autotrace.
Autotrace (Code Samples)0:09
V$SQL_PLAN View11:11
V$SQL_PLAN (Code Samples)0:23
Reading the Execution Plans (Part 1)13:12
Learn to read and analyze execution plans, including explain plan, v$sql_plan, and SQL Developer outputs, identify costly operations, and tune queries effectively.
Reading the Execution Plans (Part 2)10:29
Read explain plan outputs, compare graphical outputs, and highlight table access by index row ID, index unique scan, and bitmap index; note cost and optimizer level in cost-based optimization.
Reading the Execution Plans (Code Samples)0:07
Analyzing the Execution Plans8:18
Analyzing the Execution Plans (Code Samples)0:14
Execution Plans & Statistics

What are Indexes and How They work in details?10:51
In this lecture, you will learn the indexes with their structures and working styles
Types of Table and Index Access Paths11:59
In this lecture, you will see an overview of the table and index access paths
Table Access Full8:35
Table Access Full (Code Samples)0:11
Table Access by ROWID6:18
Explore table access by rowid, using direct rowid in the where clause and index rowids, compare performance, and understand risks when rowids may change.
Table Access by ROWID (Code Samples)0:07
Index Unique Scan4:48
Index Range Scan10:40
Learn how index range scans work on b-tree and bitmap indexes, including bounded/unbounded ranges, leftmost predicates, function-based indexes, and how order by affects sorting.
Index Range Scan (Code Samples)0:30
Index Full Scan9:34
Index Full Scan (Code Samples)1:00
Index Fast Full Scan6:37
This lecture explain the details of index fast full scan in SQL Performance Tuning
Index Fast Full Scan (Code Samples)0:29
Index Skip Scan14:14
This lecture includes the index skip scan access path in SQL Tuning to improve the performance
Index Skip Scan (Code Samples)0:25
Index Join Scan5:37
This lecture explains the index join scan access path in SQL performance tuning
Index Join Scan (Code Samples)0:12
Table & Index Access Paths

What are Hints and Why to Use Them?4:04
Explore optimizer hints in Oracle SQL to influence access paths and join methods. Learn hint types for single or multi-table scopes, query blocks, and parallel execution.
How to use Hints16:04
In this lecture you will see how to use the optimizer hints for SQL Performance Tuning by many examples
How to use Hints (Code Samples)1:21
List of Some Useful Hints0:09
Using Hints

Join Methods Overview5:10
In this lecture, you will see an overview of the join methods in SQL Performance Tuning.
Nested Loop Joins12:09
This lecture includes the nested loop joins in details in Oracle SQL Performance Tuning
Nested Loop Join (Code Samples)0:31
Sort Merge Joins10:19
This lecture explains the sort merge join of the join methods in SQL Tuning Aspect
Sort Merge Join (Code Samples)0:24
This lecture includes the code samples used in sort merge join lecture, in SQL Performance Tuning Course.
Hash Joins11:08
This lecture explains the hash joins for SQL Performance Tuning
CODE: Hash Joins0:09
This lecture includes the code samples that we used in the hash joins lecture for SQL Performance Tuning
Cartesian Joins6:28
This lecture explains the cartesian joins for SQL Tuning Aspect
CODE: Cartesian Joins0:03
This lecture includes the codes used in the Cartesian Joins lecture.
Join Types Overview3:00
This lecture includes an overview of the join types in SQL Tuning Aspects
Equijoins & Nonequijoins3:36
This lecture explains the equijoin and nonequijoin join types in SQL Tuning
CODE: Equijoins & Nonequijoins0:06
The examples used in the equijoins and nonequijoins lecture of SQL Tuning
Outer Joins11:16
In this lecture, you will see the performance aspects of the outer joins
CODE: Outer Joins0:31
Semijoins6:00
CODE: Semijoins0:10
Antijoins3:26
This lecture explains the antijoins for performance tuning aspect
CODE: Antijoins0:19
Join Operations

Result Cache Operator11:23
In this lecture, you will see how to use the result cache on your queries and how to understand it from the execution plans
CODE: Result Cache Operator0:18
View Operator7:29
Explore how the view operator shapes execution plans by merging inner queries or treating them as inline views, and how hints like no_merge and pushed predicates improve or hinder performance.
CODE: View Operator0:37
Clusters14:31
In this lecture, you will see the clusters in database performance aspects
CODE: Clusters0:31
Sort Operators7:07
In this lecture, you will learn how and why the database sorts the rows and how it shows that in the execution plans
CODE: Sort Operators0:10
INLIST Operator4:25
In this lecture you will see what does INLIST operator do in the execution plans for on sql tuning perspective
CODE: INLIST Operator0:17
Count Stopkey Operator3:34
In this lecture you will see what does count stopkey do in the execution plans for on sql tuning perspective
CODE: Count Stopkey Operator0:06
First Row Operator5:15
This lecture explains the first row operator in the explain plans with the MIN and MAX functions.
CODE: First Row Operator0:08
Filter Operator1:41
This lecture explains the filter predicate on the explain plans
CODE: Filter Operator0:02
Concatenation Operator3:06
This lecture explains the concatenation operator in the explain plans and the concatenation hint in the query
CODE: Concatenation Operator0:04
UNION Operators2:54
This lecture explains the union and union all operators in the execution plans for tuning
CODE: Union Operators0:07
Intersect Operator5:20
In this lecture you will learn the intersect operator and how to tune it
CODE: Intersect Operator0:18
Minus Operator1:49
This lecture explains the minus operator in the explain plans and how to tune it in basic
CODE: Minus Operator0:11
Other Optimizer Operators

How to find a performance problem and its tuning solution?15:05
In this lecture, you will learn how to find a performance problem and how to determine a solution for that problem
Ways of Getting the Execution Plan and the Statistics16:27
Using the Real-Time SQL Monitoring Tool Part 110:35
In this lecture, you will learn how to use the real-time sql monitoring tool via the SQL Developer and the Enterprise Manager
Using the Real-Time SQL Monitoring Tool Part 213:55
In this lecture, you will learn how to use the real-time sql monitoring tool via the SQL Developer and the Enterprise Manager
Using the Real-Time SQL Monitoring Tool Part 312:00
In this lecture, you will learn how to use the real-time sql monitoring tool via the SQL Developer and the Enterprise Manager
CODE: Using the Real-Time SQL Monitoring Tool0:17
Using the Trace Files & TKPROF Utility - Part 115:56
In this lecture, you will see how to generate the trace files with different methods and how to produce TKRPOF outputs from the trace files. And you will learn how to analyze the TKPROF outputs in details.
Using the Trace Files & TKPROF Utility - Part 220:21
In this lecture, you will see how to generate the trace files with different methods and how to produce TKRPOF outputs from the trace files. And you will learn how to analyze the TKPROF outputs in details.
Using the Trace Files & TKPROF Utility - Part 310:22
In this lecture, you will see how to generate the trace files with different methods and how to produce TKRPOF outputs from the trace files. And you will learn how to analyze the TKPROF outputs in details.
CODE: Using the Trace Files & TKPROF Utility0:15
Get What You Need Only7:13
In this lecture, you will see the select considerations for SQL Tuning aspect
CODE: Get What You Need Only0:04
Index Usage16:24
This lecture explains how to make the optimizer use your indexes and increase the performance
CODE: Index Usage0:37
Using Concatenation Operator3:35
This lecture explains the performance effects of the concatenations
CODE: Using Concatenation Operator0:05
Using Arithmetic Operators3:15
This lecture explains the performance problems of using the arithmetic operators
CODE: Using Arithmetic Operators0:06
Using Like Conditions6:43
This lecture explains what you should do with like conditions to have a better performance
CODE: Using Like Conditions0:13
Using Functions on the Indexed Columns4:52
This lecture explains why to avoid using functions on the indexed columns for SQL Tuning aspect.
CODE: Using Functions on the Indexed Columns0:11
Handling NULL-Based Performance Problems8:08
This lecture explains how to solve the performance problems of NULL value searches
CODE: Handling NULL-Based Performance Problems0:26
Using EXISTS instead of IN Clause5:02
This lecture explains the performance effects of using Exists instead of IN clause
Using TRUNCATE instead of DELETE command4:37
This lecture explains the performance comparisons of the TRUNCATE and DELETE commands, and some important things you should know for the TRUNCATE operations.
CODE: Using TRUNCATE instead of DELETE command0:06
Data Type Mismatch5:35
This lecture explains the performance effects of data type mismatches by sql tuning aspect.
CODE: Data Type Mismatch0:13
Tuning Ordered Queries7:09
This lecture explains how to tune the order by queries for performance
CODE: Tuning Ordered Queries0:14
This lecture explains how to tune the order by queries for performance
Retrieving the MIN & MAX Values10:52
In this lecture, students are going to learn how to improve the performance of the MIN & MAX queries by sql tuning aspect.
CODE: Retrieving the MIN & MAX Values0:15
In this lecture, students are going to learn how to improve the performance of the MIN & MAX queries by sql tuning aspect.
UNION and UNION ALL Operators (Which one is faster?)3:17
UNION and UNION ALL Operators (Which one is faster?)0:07
Avoid Using the HAVING Clause!5:22
This lecture explains the drawbacks of using the having clause in our SQL queries for performance aspect, and how to tune such queries.
CODE: Avoid Using the HAVING Clause!0:11
Be Careful on Views!10:22
CODE: Be Careful on Views!0:38
Create Materialized Views7:26
CODE: Create Materialized Views0:28
Avoid Commit Too Much or Too Less!4:36
Partition Pruning6:10
CODE: Partition Pruning0:07
Using BULK COLLECT10:01
Learn how bulk collect reduces context switches between PL/SQL and SQL engines, improving performance by fetching multiple rows at once, with implicit and explicit cursors and a limit.
CODE: Using BULK COLLECT1:06
Tuning the Join Order6:49
Explore how join order influences query cost in Oracle SQL, showing how driving and inner tables, index usage, and the ordered hint shape execution plans and performance.
CODE: Tuning the Join Order0:19
Multitable DML Operations7:19
CODE: Multitable DML Operations0:51
Using Temporary Tables7:18
CODE: Using Temporary Tables0:35
Combining SQL Statements4:55
CODE: Combining SQL Statements0:19
Using "WITH" Clause8:12
CODE: Using WITH Clause0:59
This lecture has the code that we used in the related lecture
Using Analytical Functions4:49
CODE: Using Analytical Functions0:15
SQL Tuning Techniques

Requirements

SQL Knowledge
Basic PL/SQL Knowledge

Description

Welcome the most comprehensive SQL Tuning course on the planet that makes you an expert on SQL & Performance Tuning!

Important Notice: This SQL & Performance Tuning course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge on Oracle SQL Tuning.

The most common problem of working with SQL is performance problems. Most of the developers don't know how to write well-performing queries. So in time, this problem grows and becomes a problem for both the developer and the company.

This course will teach you how to tune your SQL statements and database step by step for a perfect performance! You will learn how to write fast, reliable, and secure queries. Besides, you will learn the database architecture and will be able to optimize the database workloads.

Once you complete this course, you will recognize the database terms better and will use the most appropriate one for the performance.

Once you complete this course, you will be able to:

Find the Poorly Performing SQL Queries
Learn Advanced Query Tuning Techniques
Understand the Database Architecture to perform Better Tuning Techniques
Learn Advanced Indexing Techniques to Maximize Database Performance
Learn how to use various Performance Tuning Tools
Compare BAD vs GOOD Queries with Hands-on Examples.
Learn How to Gather Statistics for bad SQLs
Interpret the Execution Plans with different methods
Choose an Appropriate SQL Tuning approach
Guide the Oracle Optimizer for a better execution
Use various tuning techniques like using bind variables, different types of indexes, and much more.
Improve the performance of the queries & database
Gain Complete Knowledge in Oracle SQL and Performance Tuning!

Briefly, the knowledge of SQL Tuning is a "must" for IT Professionals and this course is the magic pill for that you're seeking for Becoming a Performance Expert!

If you want to step ahead in your career, "SQL & Performance Tuning" should be your next step.

See you in the first lecture!

Who this course is for:

SQL Developers
Data Analysts
Data Scientists
PL/SQL Developers
Oracle DBAs
Oracle BI Developers

Oracle SQL Performance Tuning Masterclass (2026)

What you'll learn

Explore related topics

Course content

SQL & Perfomance Tuning Course Introduction3 lectures • 10min

What is SQL (Performance) Tuning and Why We Need?2 lectures • 12min

Oracle Database Architecture14 lectures • 1hr 9min

SQL Tuning Basics14 lectures • 1hr 38min

Execution Plans & Statistics16 lectures • 1hr 39min

Table & Index Access Paths17 lectures • 1hr 32min

Optimizer Hints4 lectures • 22min

Join Operations18 lectures • 1hr 15min

Other Optimizer Operators24 lectures • 1hr 11min

SQL Tuning Techniques58 lectures • 4hr 54min

Requirements

Description

Who this course is for: