Oracle Database 11g Release 2 SQL Performance Tuning — A 2 day course

contact usEnquire about this course

Synopsis

This Oracle 11g Release 2 SQL Performance Tuning course introduces the delegate to the main concepts of Oracle SQL performance tuning. It is designed to give delegates practical experience in analysing and tuning the performance of SQL. This course is suitable for users of Oracle Database 11g and Oracle Database 12c.

Objectives

To provide the skills needed to monitor and tune an Oracle database application.

The delegate will practise:

Suitable For

The Oracle 11g Release 2 SQL Performance Tuning course is designed for SQL programmers, application developers, designers and technical support professionals who are required to tune the performance of an Oracle application running under Oracle Database 11g or 12c.

Follow-on Courses

Prerequisites

A working knowledge of SQL is required. This can be obtained by attendance on the pre-requisite Oracle SQL course.

Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 30 January 2017, please call 0333 210 0140 or use our contact form to enquire about places and availability.

London — £845 (+VAT)


Contents

Introduction to Oracle Performance Tuning

Tools for Evaluating SQL Statements

The SQL Optimizer

Sorts

Indexes

Advanced Indexes

Join Operations

SQL Tuning Advisor Using SQL Developer

Sequences and Views

Using Hints

Miscellaneous