Oracle Database: SQL Tuning for Developers

Oracle Database: SQL Tuning for Developers Certification Training Course 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

Oracle Database: SQL Tuning for Developers (24 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2500
02 - 04 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 08 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 2850
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Introduction
  • Workshops, Demo Scripts, and Code Example Scripts
  • SQL Environments Available in the Course
  • Course Objectives, Course Agenda and Appendixes Used in this Course
  • Sample Schemas Used in the Course
  • Class Account Information
  • Appendices in the Course
  • Audience and Prerequisites
Module 2: Introduction to SQL Tuning
  • SQLTXPLAIN (SQLT) Diagnostic Tool
  • Development Environments: Overview
  • SQL Tuning Session
  • SQL Tuning Strategies
Module 3: Using Application Tracing Tools
  • Using the SQL Trace Facility: Overview
  • The trcsess Utility
  • Formatting SQL Trace Files: Overview
  • Available Tracing Tools: Overview
  • Steps Needed Before Tracing
Module 4: Understanding Basic Tuning Techniques
  • Developing Efficient SQL statement
  • Index Usage
  • Data Type Mismatch
  • Table Design
  • Scripts Used in This Lesson
  • Transformed Index
  • Tune the ORDER BY Clause
  • NULL usage
Module 5: Optimizer Fundamentals
  • Why Do You Need an Optimizer?
  • Query Transformer
  • SQL Statement Processing
  • Optimizer Features and Oracle Database Releases
  • Cost-Based Optimizer
  • SQL Statement Representation
  • Components of the Optimizer
  • Adaptive Query Optimization
Module 6: Generating and Displaying Execution Plans
  • DBML_SQL_MONITOR
  • V$SQL_PLAN View
  • AUTOTRACE
  • The EXPLAIN PLAN Command
  • Plan Table
  • Execution Plan?
  • SQL Monitoring
  • Automatic Workload Repository
Module 7: Interpreting Execution Plans and Enhancements
  • Optimizer: Table and Index Access Paths
  • Full Table Scan
  • Common Observations
  • Row Source Operations
  • Indexes
  • Adaptive Optimizations
  • Main Structures and Access Paths
  • Interpreting a Serial Execution Plan
Module 9: Other Optimizer Operators
  • SQL operators
  • Result Cache operators
  • Other N-Array Operations
Module 10: Introduction to Optimizer Statistics Concepts
  • Gather and Manage Optimizer Statistics: Overview
  • Optimizer Statistics
  • Types of Optimizer Statistics
Module 11: Using Bind Variabl
  • Cursor Sharing and Bind Variables
  • Cursor Sharing and Different Literal Values
Module 12: SQL Plan Management
  • Maintaining SQL Performance
  • SQL Plan Management
Download Course Contents

Request More Information

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