Formation Oracle Database 12c: SQL Tuning for Developers

Module 1: Course Overview

Understand the course objectives, agenda, and appendices.

Learn about the target audience and prerequisites.

Familiarize with the sample schemas and class account information.

Explore the SQL environments available in the course.

Access workshops, demo scripts, and code example scripts.

Module 2: Introduction to SQL Tuning

Gain insights into SQL tuning strategies.

Understand the basics of development environments.

Explore the SQLTXPLAIN (SQLT) diagnostic tool.

Learn to use application tracing tools effectively.

Understand SQL statement representation and processing.

Explore the components of the optimizer.

Learn about query transformation and cost-based optimization.

Discover adaptive query optimization and its features.

Module 4: Generating and Displaying Execution Plans

Learn to generate and interpret execution plans.

Understand the EXPLAIN PLAN command and plan table.

Explore tools like AUTOTRACE and V$SQL_PLAN view.

Discover features of the Automatic Workload Repository and SQL monitoring.

Module 5: Interpreting Execution Plans and Enhancements

Interpret serial execution plans effectively.

Explore adaptive optimizations and optimizer features.

Understand different access paths like full table scan and indexes.

Learn about optimizer join operations and other operator types.

Module 6: Introduction to Optimizer Statistics Concepts

Gain insights into optimizer statistics types and management.

Learn to gather and manage optimizer statistics effectively.

Explore the use of bind variables and cursor sharing.

Module 7: SQL Plan Management

Understand the concept of SQL plan management.

Learn strategies for maintaining SQL performance effectively.

Module 8: Workshops

Engage in hands-on workshops to apply SQL tuning techniques.

Practice SQL plan management and optimization strategies.

Module 9: Oracle Cloud Overview

Introduction to Oracle Cloud and its services.

Explore different cloud deployment models.

Understand the transition from on-premises to Exadata Express.

Discover the features and benefits of Exadata Express Cloud Service.

Module 10: Getting Started with Exadata Express

Learn to navigate the Exadata Express service console.

Understand web access through the service console for users and developers.