Oracle Database 19c: SQL Tuning Workshop Virtual Classroom Live May 22, 2024

Price: $3,600

This course runs for a duration of 3 Days.

The class will run daily from 9:00 AM EST to 5:00 PM EST.

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

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description
Outline

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

Knowledge Transfer Consulting Services Inc. is a single-source solution provider offering a full range of Training Delivery and Training Management solutions from concept to delivery. Learn more

Oracle Database 19c: SQL Tuning Workshop Virtual Classroom Live May 22, 2024

Price: $3,600

Enroll today to reserve your spot!

Description

Course Overview

Find a Course

Corporate Services

Contact us