TRENDS is authorized to promote and deliver Oracle courses in partnership with TechEdge Solutions. EZY Corporation logo and Oracle logo are registered trademarks of EZY Corporation and Oracle respectively. All rights reserved.

Oracle Database 19c: SQL Tuning Workshop

Schedule

Start End Duration Location Details

Course Details

Oracle Database 19c: SQL Tuning Workshop

Duration: 3 Days

Course Code: OD19SQLTW

Course Description:

This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database.

Course Objective:

•    Identify issues in SQL statements
•    Edit an SQL statement to best execute it
•    Track an application
•    Understand how the Query Optimizer makes decisions about how to access data
•    Interpret execution plans
•    Use effective optimization hints
•    Generate a load test

Course Outline:

•    Course Introduction
•    Introduction to SQL Tuning
•    Using Application Tracing Tools
•    Optimizer Fundamentals
•    Generating and Displaying Execution Plans
•    Interpreting Execution Plans and Enhancements
•    Optimizer: Table and Index Access Paths
•    Optimizer: Join Operators
•    Optimizer: Join Operators
•    Introduction to Optimizer Statistics Concepts
•    Using Bind Variables
•    SQL Plan Management
•    Workshops