Oracle Database 12c SQL Tuning Developers Training Course

Overview

This comprehensive course intents to help participants in interpreting the execution plans and the ways to access the data by exploring the SQL statement tuning in Oracle. Various advanced topics including Execution plan internals, join methods, tuning them further based on the data volume would be the feature course highlights. Using different paths to optimize efficiently would be the additional focus area during the course.

Download Course Contents

Schedule & Prices

Course Details	Schedule
Live Online Training (Instructor-Led) Duration : 3 Days (6 Day for 4 Hours/Day) Fee : USD 1,000 (1-on-1)†	April 8 Hours/Day 4 Hours/Day 13-15 20-22 13-18 20-25 May 8 Hours/Day 4 Hours/Day 18-20 18-23 July 8 Hours/Day 4 Hours/Day 06-08 06-11
Classroom Training* Duration : 3 Days Fee : Sydney : USD 2,200 London : USD 2,200 Dubai : USD 2,100 India : USD 1,400	May 18-23 (Chennai) (Venue) July 06-11 (Delhi) (Venue) 06-08 (London) (Venue) July 12-14 (Dubai) 13-15 (Bangalore) 13-15 (London) 20-22 (Chennai) August 03-05 (Delhi) 03-05 (London) 09-11 (Dubai) 10-12 (London) September 07-09 (Delhi) 07-09 (london) 13-15 (Dubai) 14-16 (Bangalore) 14-16 (london) October 05-07 (Delhi) 05-07 (London)

Enquire Now

Input symbols

Course Prerequisites

Good knowledge of Oracle Database

Upon Completion of this Course, you will accomplish following:-

Identify the execution plans and understand various data access techniques
Knowledge to decipher and decide before tuning the SQL code
Apply different techniques of tuning
Work with trace files, bind variables and various index types
Understand various access techniques for efficient optimization