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 : India : $1,500 , Dubai : $2,100

March
08-10 (Dubai)
July
12-14 (Dubai)

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
)