D79995 – Oracle Database: SQL Tuning for Developers

Module 1: Introduction

Module 2: Introduction to SQL Tuning

Module 3: Using Application Tracing Tools

Module 4: Understanding Basic Tuning Techniques

Module 5: Optimizer Fundamentals

Module 6: Generating and Displaying Execution Plans

Module 7: Interpreting Execution Plans and Enhancements

Module 8: Optimizer: Table and Index Access Paths

Module 9: Optimizer Join Operations

Module 10: Other Optimizer Operators

Module 11: Introduction to Optimizer Statistics Concepts

Module 12: Using Bind Variables

Module 13: SQL Plan Management

Module 14: Workshops

Module 15: Oracle Cloud Overview