651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

Oracle Database 19c: SQL Tuning Workshop Virtual Classroom Live May 05, 2025

Price: $3,600

This course runs for a duration of 3 Days.

The class will run daily from 9 AM ET to 5 PM Et.

Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

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.

Skills Gained

  • 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.

Course Overview

  • 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

Other Available Dates for this Course

Virtual Classroom Live
January 20, 2025

$3,600.00
3 Days    9 AM ET - 5 PM Et
view class details and enroll
Virtual Classroom Live
March 17, 2025

$3,600.00
3 Days    9 AM ET - 5 PM Et
view class details and enroll
Virtual Classroom Live
July 14, 2025

$3,600.00
3 Days    9 AM ET - 5 PM Et
view class details and enroll