Course Code: 19196

Oracle Database 19c: SQL Tuning Workshop

Class Dates:
10/14/2024
11/20/2024
9/18/2024
Length:
3 Days
Cost:
$3495.00
Class Time:
Technology:
Database
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training

Overview

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

Prerequisites

Course Disclaimer

*Course Cost listed does not include the cost of courseware. Course is subject to a minimum enrollment to run the course. Course may run virtually as a virtual live instructor led class if the minimum enrollment is not met. For more information, please contact: 207-775-0244 or email: learn@vtec.org.

Remote Classroom Training
Our Remote Classroom Training is a live class with students observing the instructor and listening through your computer speakers. You will see the instructor's computer, slides, notes, etc., just like in the classroom. You will be following along, doing work, labs, and individual assignments.

Course Details

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