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
Classroom Training* Duration : 3 Days Fee : London: £5,000, Dubai : $2,060 , India : $1,470	January 20-22 (Chennai) 20-22 (Goa) February 03-05 (Delhi) 03-05 (Goa) 03-05 (london) 09-11 (Dubai) 09-11 (Goa) 10-12 (Bangalore) 10-12 (Goa) 10-12 (london) March 02-04 (Delhi) 02-04 (Goa) 02-04 (London) 08-10 (Dubai) 08-10 (Goa) 09-11 (Bangalore) 09-11 (Goa) 09-11 (London) 16-18 (Chennai) 16-18 (Goa) April 13-15 (Bangalore) 13-15 (Goa)

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