Oracle SQL Performance Tuning Masterclass (2025)
- Descrição
- Currículo
- FAQ
- Revisões
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!
-
1
SQL & Performance Tuning Course OverviewThis Overview lecture explains what will this course cover
-
2
UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)
This lecture is about how to use the Udemy platform. And also includes some useful tips to get most of out the course.
-
3
Welcome Gift! + Course DocumentThis lecture includes the working document of our SQL and Performance Tuning Course with a warm welcome message.
-
6
Do You Have a Running Database in Your PC?
-
7
Why to know the Oracle Database Architecture and how much to know?
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
-
8
Oracle Database Architecture Overview (Part 1)
First part of the architecture overview lecture
-
9
Oracle Database Architecture Overview (Part 2)
Second part of the architecture overview lecture
-
10
Database Data Blocks in Detail
Data in database are stored in logical data blocks. This lecture explains the Oracle database data blocks in details.
-
11
What is PGA?
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.
-
12
What is Shared Pool?
Shared pool is very critical for parsing performance. This lecture explains shared pool and its sub-memory areas with details.
-
13
What is Buffer Cache?
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.
-
14
What is Redo Log Buffer?
Sometimes redo logs decreases the performance. This lecture explains the redo log buffer in the PGA.
-
15
What is Undo?
As the name implies, undo is for undo. So you will learn how a rollback is done with undo segments
-
16
How a DML is processed and committed
-
17
Automatic Memory Management
-
18
Oracle Database Storage Architecture
-
19
Logical and Physical Database Structure
-
20
Quiz - Database ArchitectureThis quiz has questions about Oracle Database Architecture
-
21
When to Tune?
-
22
What is a Bad SQL?
-
23
Effective Schema Design
-
24
Table Partitioning
-
25
How an SQL Statement is Processed?
-
26
Why do we need the Optimizer?
-
27
Optimizer Overview
-
28
Query Transformer
-
29
Selectivity & Cardinality
-
30
What is "cost" in detail?
-
31
Plan Generator
In this SQL Performance and SQL Tuning Tutorial, students will learn SQL Plan Generator.
-
32
Row Source Generator
-
33
SQL Tuning Principles and Strategies
-
34
Query Analysis Strategy
-
35
SQL Tuning Basics Assessment Test
This assessment test will evaluate how much you learned.
-
36
Execution Plan and Explain Plan in Details
-
37
Generating Statistics (Part 1)
-
38
Generating Statistics (Part 2)
-
39
Generating Statistics (Part 3)
-
40
Generating Statistics (Code Samples)
-
41
Generating Execution Plan
-
42
Generating Execution Plan (Code Samples)
-
43
Autotrace
-
44
Autotrace (Code Samples)
-
45
V$SQL_PLAN View
-
46
V$SQL_PLAN (Code Samples)
-
47
Reading the Execution Plans (Part 1)
-
48
Reading the Execution Plans (Part 2)
-
49
Reading the Execution Plans (Code Samples)
-
50
Analyzing the Execution Plans
-
51
Analyzing the Execution Plans (Code Samples)
-
52
Execution Plans & Statistics
You will review your knowledge about generating the statistics in this practice test
-
53
What are Indexes and How They work in details?
In this lecture, you will learn the indexes with their structures and working styles
-
54
Types of Table and Index Access Paths
In this lecture, you will see an overview of the table and index access paths
-
55
Table Access Full
-
56
Table Access Full (Code Samples)
-
57
Table Access by ROWID
-
58
Table Access by ROWID (Code Samples)
-
59
Index Unique Scan
-
60
Index Range Scan
-
61
Index Range Scan (Code Samples)
-
62
Index Full Scan
-
63
Index Full Scan (Code Samples)
-
64
Index Fast Full Scan
This lecture explain the details of index fast full scan in SQL Performance Tuning
-
65
Index Fast Full Scan (Code Samples)
-
66
Index Skip Scan
This lecture includes the index skip scan access path in SQL Tuning to improve the performance
-
67
Index Skip Scan (Code Samples)
-
68
Index Join Scan
This lecture explains the index join scan access path in SQL performance tuning
-
69
Index Join Scan (Code Samples)
-
70
Table & Index Access Paths
This Quiz includes the questions about table and index access paths in SQL Performance Tuning
