Oracle Database 19c: SQL Tuning Workshop

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Jan 10, 202209:0005:00ESTToronto - In Class or by Video Conference3$3,600 USDPurchase
Mar 21, 202211:0007:00EDTToronto - In Class or by Video Conference3$3,600 USDPurchase
May 24, 202209:0005:00EDTToronto - In Class or by Video Conference3$3,600 USDPurchase
Jul 5, 202209:0005:00EDTToronto - In Class or by Video Conference3$3,600 USDPurchase
Sep 27, 202209:0005:00EDTToronto - In Class or by Video Conference3$3,600 USDPurchase
Nov 28, 202211:0007:00ESTToronto - In Class or by Video Conference3$3,600 USDPurchase


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

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

 

Right Menu IconMENU