Oracle Database: SQL Tuning for Developers Ed 2 Training

Live Online & Classroom Enterprise Certification Training

In this course, students learn about Oracle SQL tuning and how to apply tuning techniques to their SQL code. This course assists database developers, DBAs, and SQL developers to identify and tune inefficient SQL. It covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Students learn the different ways in which data can be accessed, and how to determine if those are the most efficient ways is a particular database. Student will learn how to ensure that the best method is used.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is SQL Tuning for Developers Ed 2 Certification Training about?

In this application development-centric course, students learn about Oracle SQL statement tuning and how to write well-tuned SQL statements appropriate for the Oracle database. Students learn to interpret execution plans and the different ways in which data can be accessed. Students are shown how to decipher, decide and then apply tuning to their SQL code. Various tuning techniques are demonstrated. For example, taking advantage of bind variables, trace files, and using the different types of indexes.

Benefit from gaining a deeper understanding of Oracle SQL statement tuning and how to write well-tuned SQL statements appropriate for the Oracle database in this application development-centric course. You will learn how to decipher, decide and then apply tuning to your SQL code. Various tuning techniques are demonstrated.

What are the objectives of SQL Tuning for Developers Ed 2 Certification Training ?

Modifying a SQL statement to perform at its best
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

Who is SQL Tuning for Developers Ed 2 Certification Training for?

Application Developers
Developer
Support Engineer
Data Warehouse Developer
PL/SQL Developer

What are the prerequisites for SQL Tuning for Developers Ed 2 Certification Training?

Suggested Prerequisite

Knowledge of SQL and PL/SQL
Familiarity with database architecture

Required Prerequisite

Oracle Database: Introduction to SQL Ed 2
Oracle Database: SQL Workshop I Ed 2

Available Training Modes

Live Online Training

24 Hours

Classroom Training

3 Days

Course Outline Expand All

Expand All

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

Introduction to SQL Tuning

SQLTXPLAIN (SQLT) Diagnostic Tool

Development Environments: Overview

SQL Tuning Session

SQL Tuning Strategies

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

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

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

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

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

Optimizer Join Operations

Join Methods

Join Types

Other Optimizer Operators

SQL operators

Result Cache operators

Other N-Array Operations

Introduction to Optimizer Statistics Concepts

Gather and Manage Optimizer Statistics: Overview

Optimizer Statistics

Types of Optimizer Statistics

Using Bind Variables

Cursor Sharing and Bind Variables

Cursor Sharing and Different Literal Values

SQL Plan Management

Maintaining SQL Performance

SQL Plan Management

Workshops

Workshop 9

Workshop 2

Workshop 4

Workshop 8

Workshop 5

Workshop 6 & 7

Workshop 1

Workshop 3

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

SQL Tuning for Developers Ed 2 Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree