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
Schedule & Prices
Course Details Schedule
Classroom Training*
Duration : 3 Days
Fee :  London: £5,500, Dubai : $2,060 , India : $1,470


December
08-10 (Dubai)
26-28 (Bangalore)
26-28 (Chennai)
26-28 (Delhi)
January
02-04 (London)
06-08 (Delhi)
06-08 (London)
12-14 (Dubai)
13-15 (Bangalore)
13-15 (London)
20-22 (Chennai)
February
10-12 (Bangalore)
March
02-04 (Delhi)
02-04 (London)
Instructor-Led Online Training
Duration : 3 Days
Fee :  $1,400


December
08-10
26-28
January
02-04
06-08
12-14
13-15
20-22
February
10-12
March
02-04
Fly-Me-a-Trainer
Duration : 3 Days
Fee : On Request
Client's Location
As per mutual convenience

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