Oracle Database: SQL Tuning for Developers//

Overview

The Oracle Database: SQL Tuning for Developers Ed 2 training and certification course will give you a detailed overview of Oracle SQL statement tuning and writing well-tuned SQL statements appropriate for the Oracle database. During the training, you will learn to interpret execution plans, different ways in which data can be accessed, applying to tune to their SQL code.

Who should do Oracle Database: SQL Tuning for Developers Ed 2 Training?

Application Developers
Developer
Support Engineer
Data Warehouse Developer
PL/SQL Developer

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,900 (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,500	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

Oracle Database: Introduction to SQL Ed 2
Oracle Database: SQL Workshop I Ed 2

Following are suggested but not mandatory

Oracle Database: Introduction to SQL Ed 2
Oracle Database: SQL Workshop I Ed 2

On completion of this training, you will know:

Modifying a SQL statement
Identifying poorly performing SQL
Tracing an application through its different levels of the application architecture
Understanding how the Query Optimizer makes decisions about how to access data
Defining how optimizer statistics affect the performance of SQL
Listing the possible methods of accessing data, including different join methods