| Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
|---|---|---|---|---|---|---|---|
| May 23, 2023 | 11:00 | 07:00 | EDT | Toronto - In Class or by Video Conference | 3 | $3,600 USD | Purchase |
| Jul 17, 2023 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 3 | $3,600 USD | Purchase |
| Sep 18, 2023 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 3 | $3,600 USD | Purchase |
| Nov 20, 2023 | 11:00 | 07:00 | EST | Toronto - In Class or by Video Conference | 3 | $3,600 USD | Purchase |
Oracle Database 19c: SQL Tuning Workshop
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.
Duration: 3 Days
Audience
- Database Administrators
Learning Objectives
- Interpret execution plans and the different ways in which data can be accessed
- Decipher, decide and then apply tuning to SQL code
- Use various tuning techniques
- Take advantage of bind variables, trace files and use the different types of indexes
- Use different access paths for better optimization
Topics
- 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
- Other Optimizer Operators
- Introduction to Optimizer Statistics Concepts
- Using Binding Variables
- SQL Plan Management
