SQL & Perfomance Tuning Course Introduction
- SQL & Performance Tuning Course Overview
- UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)
- Welcome! +Course Document
What is SQL (Performance) Tuning and Why We Need?
- What is SQL Tuning and Why to Do That?
- What to Know Before Starting the Course?
Oracle Database Architecture
- Do You Have a Running Database in Your PC?
- Why to know the Oracle Database Architecture and how much to know?
- Oracle Database Architecture Overview (Part 1)
- Oracle Database Architecture Overview (Part 2)
- Database Data Blocks in Detail
- What is PGA?
- What is Shared Pool?
- What is Buffer Cache?
- What is Redo Log Buffer?
- What is Undo?
- How a DML is processed and committed
- Automatic Memory Management
- Oracle Database Storage Architecture
- Logical and Physical Database Structure
- Quiz - Database Architecture
SQL Tuning Basics
- When to Tune?
- What is a Bad SQL?
- Effective Schema Design
- Table Partitioning
- How an SQL Statement is Processed?
- Why do we need the Optimizer?
- Optimizer Overview
- Query Transformer
- Selectivity & Cardinality
- What is "cost" in detail?
- Plan Generator
- Row Source Generator
- SQL Tuning Principles and Strategies
- Query Analysis Strategy
- SQL Tuning Basics Assessment Test
Execution Plans & Statistics
- Execution Plan and Explain Plan in Details
- Generating Statistics (Part 1)
- Generating Statistics (Part 2)
- Generating Statistics (Part 3)
- Generating Statistics (Code Samples)
- Generating Execution Plan
- Generating Execution Plan (Code Samples)
- Autotrace
- Autotrace (Code Samples)
- V$SQL_PLAN View
- V$SQL_PLAN (Code Samples)
- Reading the Execution Plans (Part 1)
- Reading the Execution Plans (Part 2)
- Reading the Execution Plans (Code Samples)
- Analyzing the Execution Plans
- Analyzing the Execution Plans (Code Samples)
- Execution Plans & Statistics
Table & Index Access Paths
- What are Indexes and How They work in details?
- Types of Table and Index Access Paths
- Table Access Full
- Table Access Full (Code Samples)
- Table Access by ROWID
- Table Access by ROWID (Code Samples)
- Index Unique Scan
- Index Range Scan
- Index Range Scan (Code Samples)
- Index Full Scan
- Index Full Scan (Code Samples)
- Index Fast Full Scan
- Index Fast Full Scan (Code Samples)
- Index Skip Scan
- Index Skip Scan (Code Samples)
- Index Join Scan
- Index Join Scan (Code Samples)
- Table & Index Access Paths
Optimizer Hints
- What are Hints and Why to Use Them?
- How to use Hints
- How to use Hints (Code Samples)
- List of Some Useful Hints
- Using Hints
Join Operations
- Join Methods Overview
- Nested Loop Joins
- Nested Loop Join (Code Samples)
- Sort Merge Joins
- Sort Merge Join (Code Samples)
- Hash Joins
- CODE: Hash Joins
- Cartesian Joins
- CODE: Cartesian Joins
- Join Types Overview
- Equijoins & Nonequijoins
- CODE: Equijoins & Nonequijoins
- Outer Joins
- CODE: Outer Joins
- Semijoins
- CODE: Semijoins
- Antijoins
