Chứng chỉ MOS Excel 2019 - Exam MO-200 Microsoft Excel
TS. Dang Xuan Tho
5.0 (500)·6h 10m · 91 lectures
$3.00$12–$199up to −98%
Loading course
Oracle SQL Performance Tuning Masterclass (2026)
Become an Expert on Oracle SQL Tuning and Solve All The Performance Problems of Your SQL Queries and the Database!
4.79,862 reviews57,481 learners
- All Levels
- 20h 33m video
- 232 lectures
- English
- Captions
- Updated 2026
Taught by Database Masters
- 20h 33m of on-demand video
- 232 lectures across 14 sections
- One-off payment — no subscription
- Lifetime access on web and mobile
- Closed captions (English)
Curriculum
14 sections232 lectures20h 33m total
- SQL & Performance Tuning Course Overview4:52
- UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)5:01
- Welcome Gift! + Course Document0:36
- What is SQL Tuning and Why to Do That?5:55
- What to Know Before Starting the Course?6:20
- 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
- Oracle Database Architecture Overview (Part 1)9:17
- Oracle Database Architecture Overview (Part 2)6:04
- Database Data Blocks in Detail7:57
- What is PGA?5:32
- What is Shared Pool?6:31
- What is Buffer Cache?5:24
- What is Redo Log Buffer?4:18
- What is Undo?3:49
- How a DML is processed and committed4:28
- Automatic Memory Management2:06
- Oracle Database Storage Architecture3:57
- Logical and Physical Database Structure6:13
- When to Tune?7:40
- What is a Bad SQL?5:08
- Effective Schema Design8:42
- Table Partitioning7:15
- How an SQL Statement is Processed?9:32
- Why do we need the Optimizer?5:41
- Optimizer Overview3:25
- Query Transformer8:44
- Selectivity & Cardinality8:02
- What is "cost" in detail?4:51
- Plan Generator3:56
- Row Source Generator3:38
- SQL Tuning Principles and Strategies8:10
- Query Analysis Strategy12:58
- SQL Tuning Basics Assessment Test0:00
- Execution Plan and Explain Plan in Details7:24
- Generating Statistics (Part 1)6:16
- Generating Statistics (Part 2)7:15
- Generating Statistics (Part 3)8:50
- Generating Statistics (Code Samples)0:20
- Generating Execution Plan12:06
- Generating Execution Plan (Code Samples)0:09
- Autotrace12:38
- 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
- Reading the Execution Plans (Part 2)10:29
- Reading the Execution Plans (Code Samples)0:07
- Analyzing the Execution Plans8:18
- Analyzing the Execution Plans (Code Samples)0:14
- Execution Plans & Statistics0:00
- What are Indexes and How They work in details?10:51
- Types of Table and Index Access Paths11:59
- Table Access Full8:35
- Table Access Full (Code Samples)0:11
- Table Access by ROWID6:18
- Table Access by ROWID (Code Samples)0:07
- Index Unique Scan4:48
- Index Range Scan10:40
- Index Range Scan (Code Samples)0:30
- Index Full Scan9:34
- Index Full Scan (Code Samples)1:00
- Index Fast Full Scan6:37
- Index Fast Full Scan (Code Samples)0:29
- Index Skip Scan14:14
- Index Skip Scan (Code Samples)0:25
- Index Join Scan5:37
- Index Join Scan (Code Samples)0:12
About this course
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…
Before you start
- SQL Knowledge
- Basic PL/SQL Knowledge
Who it’s for
- SQL Developers
- Data Analysts
- Data Scientists
- PL/SQL Developers
- Oracle DBAs
- Oracle BI Developers
Related
More in Office Productivity
Ôn thi Chứng chỉ MOS Word 2019 - Exam MO-100 Microsoft Word
TS. Dang Xuan Tho
5.0 (467)·5h 36m · 79 lectures$3.00$12–$199up to −98%The AI-Powered Business Writing & Communication Guide
Emmanuel Essien
5.0 (178)·1h 32m · 12 lectures$3.00$12–$199up to −98%Productivity Masterclass: Master GenAI Workflows
Emmanuel Essien
5.0 (157)·2h 51m · 18 lectures$3.00$12–$199up to −98%
$3.00$12–$199