Watch Intro Video

Video

Course curriculum

  • 1

    INTRODUCTION

    • Introducing the Course
  • 2

    PREPARING PRACTICE ENVIRONMENT

    • Practice 1 - Preparing Practice Environment

    • DOWNLOAD ZIP FILES ( For Practice 1 )

    • Practice 1- Preparing Practice Environment - Part 1 of 2

    • Practice 1- Preparing Practice Environment - Part 2 of 2
  • 3

    INTRODUCTION TO SQL TUNING

    • Introduction to SQL Tuning - Part 1 of 2

    • Introduction to SQL Tuning - Part 2 of 2
  • 4

    INTRODUCING QUERY OPTIMIZER

    • Query Optimizer Fundamentals

    • Query Optimizer Fundamentals
  • 5

    EXECUTION PLANS

    • Reading Query Execution Plans

    • Displaying Query Execution Plans

    • Practice 2 - Displaying Execution Plans

    • Pracitce 2 - Displaying Execution Plans

    • Introduction to SQL Operators

    • Table and B-Tree Index SQL Operators

    • SQL Joins - Nested Loop Joins

    • SQL Joins - Hash Joins

    • SQL Joins - Sort Merge Joins

    • SQL Operators

    • Practice 3 - Exploring SQL Operators and Joins

    • Practice 3 - Exploring SQL Operators and Joins
  • 6

    OPTIMIZER HINTS

    • Influencing the Optimizer with Hints - Part 1 of 2

    • Influencing the Optimizer with Hints - Part 2 of 2

    • Practice 4 - Influencing the Optimizer with Hints

    • Practice 4 - Influencing the Optimizer with Hints - Part 1 of 2

    • Practice 4 - Influencing the Optimizer with Hints - Part 2 of 2
  • 7

    MANAGING OPTIMIZER STATISTICS

    • Optimizer Statistics Concepts

    • Practice 5 - Exploring Optimizer Statistics

    • Practice 5 - Exploring Optimizer Statistics

    • Gathering Optimizer Statistics

    • Practice 6 - Gathering Optimizer Statistics

    • Practice 6 - Gathering Optimizer Statistics

    • Setting Optimizer Statistics Preferences

    • Practice 7 - Setting Optimizer Statistics Preferences

    • Practice 7 - Setting Optimizer Statistics Preferences

    • Managing Histograms - Part 1 of 2

    • Managing Histograms - Part 2 of 2

    • Practice 8 - Managing Histograms

    • Practice 8 - Managing Histograms - Part 1 of 2

    • Practice 8 - Managing Histograms - Part 2 of 2

    • Managing Extended Statistics

    • Practice 9 - Managing Extended Statistics

    • Practice 9 - Managing Extended Statistics

    • Managing Optimizer Statistics

    • Practice 10 - Managing Optimizer Statistics

    • Practice 10 - Managing Optimizer Statistics

    • Managing Historical Optimizer Statistics

    • Practice 11 - Managing Historical Optimizer Statistics

    • Practice 11 - Managing Historical Optimizer Statistics

    • Using Optimizer Statistics Advisor

    • Practice 12 - Using Optimizer Statistics Advisor

    • Practice 12 - Using Optimizer Statistics Advisor
  • 8

    ADAPTIVE QUERY OPTIMIZATION

    • Adaptive Query Optimization

    • Adaptive Plans

    • Practice 13 - Demonstrating Adaptive Plans

    • Practice 13 - Demonstrating Adaptive Plans

    • Statistics Feedback and Dynamic Statistics

    • Practice 14 - Statistics Feedback and Dynamic Statistics

    • Practice 14 - Statistics Feedback and Dynamic Statistics

    • SQL Plan Directives

    • Practice 15 - SQL Plan Directives

    • Practice 15 - SQL Plan Directives
  • 9

    CURSOR SHARING

    • Improving Performance Through Cursor Sharing

    • Practice 16 - Improving Performance Through Cursor Sharing

    • Practice 16 - Improving Performance Through Cursor Sharing
  • 10

    MONITORING AND TRACING SQL

    • Monitoring Database Operations in Real-time using DBMS_MONITOR

    • Practice 17 - Monitoring Database Operations using DBMS_MONITOR

    • Practice 17 - Monitoring Database - Part 1 of 2

    • Practice 17 - Monitoring Database - Part 2 of 2

    • Tracing SQL Statements using DBMS_MONITOR

    • Using tkprof Utility

    • Practice 18 - Tracing SQL Statements using DBMS_MONITOR

    • Practice 18 - Tracing SQL Statements using DBMS_MONITOR

    • More SQL Tracing Methods

    • Practice 19 - More SQL Tracing Methods

    • Practice 19 - More SQL Tracing Methods
  • 11

    SQL TUNING SETS

    • Managing SQL Tuning Sets

    • Practice 20 - Managing SQL Tuning Sets

    • Practice 20 - Managing SQL Tuning Sets
  • 12

    SQL TUNING ADVISOR

    • Using SQL Tuning Advisor - Automatic Mode

    • Using SQL Tuning Advisor - Manual Mode

    • Practice 21 - Using SQL Tuning Advisor

    • Practice 21 - Using SQL Tuning Advisor

    • Managing SQL Profiles

    • Practice 22 - Managing SQL Profiles

    • DOWNLOAD ZIP FILES ( For Practice 22 )

    • Practice 22 - Managing SQL Profiles
  • 13

    SQL PLAN MANAGEMENT

    • Managing SQL Plan Baselines - Part I

    • Managing SQL Plan Baselines - Part II

    • Practice 23 - Managing SQL Plan Baselines

    • Practice 23 - Managing SQL Plan Baselines - Part I

    • Practice 23 - Managing SQL Plan Baselines - Part II

    • Using Stored Outlines and Migrating them to SQL Plan Baselines

    • Practice 24 - Migrating Stored Outlines to SQL Plan Baselines

    • Practice 24 - Migrating Stored Outlines to SQL Plan Baselines

    • Managing SQL Management Base (SMB)
  • 14

    SQL ACCESS ADVISOR

    • Using SQL Access Advisor

    • Practice 25 - Using SQL Access Advisor

    • Practice 25 - Using SQL Access Advisor
  • 15

    WORKING FOR TABLE WITH PERFORMANCE

    • Performance Considerations when Working with Tables

    • Practice 26 - Performance Tips on Using Tables

    • Practice 26 - Performance Tips on Using Tables
  • 16

    USING INDEXES ( BASIC & ADVANCED )

    • Using Indexes - Part I

    • Practice 27 - Using Indexes - Part I

    • Practice 27 - Using Indexes - Part I

    • Using Indexes - Part II

    • Practice 28 - Using Indexes - Part II

    • Practice 28 - Using Indexes - Part II

    • Using Indexes - Part III

    • Practice 29 - Using Indexes - Part III

    • Practice 29 - Using Indexes - Part III

    • Star Transformation

    • Practice 30 - Star Transformation

    • Practice 30 - Star Transformation
  • 17

    SERVER RESULT CACHE

    • Using Server Result Cache

    • Practice 31 Using Server Result Cache

    • Practice 31 Using Server Result Cache
  • 18

    MORE SQL TUNING TOOLS

    • Using SQL Performance Analyzer

    • Practice 32 - Using SQL Performance Analyzer

    • Practice 32 - Using SQL Performance Analyzer

    • Practice 33 - Using SQL Tuning Health-Check Script (SQLHC)

    • Practice 33 - Using SQL Tuning Health-Check Script (SQLHC)
  • 19

    APPENDICES

    • Course Presentation and Practice Files