P3711 – Oracle Database 12c: SQL Tuning for Developers

• Duration: 10 weeks

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: Oracle Cloud Overview