Oracle SQL Tuning Syllabus Training in Chennai

Oracle Database 12c SQL Tuning for Developers Training in Chennai SQLSTAR Global

Oracle Database 12c: SQL Tuning for Developers
WHAT YOU WILL LEARN

In the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently.
Learn To:

UseOracle tools to identify inefficient SQL statements.
UseAutomatic SQL Tuning.
Usereal Time SQL monitoring.
Writemore efficient SQL statements.
Monitorand trace high load SQL statements.
Manageoptimizer statistics on database objects.
Understand the optimizer process steps and operators.
Interpretexecution plans.
Performapplication tracing.

AUDIENCE

This course is specially design for Application Developers, Data Warehouse Developer, Developer, PL/SQL Developer and Support Engineer

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint present ations, discussions and practical exercises

COURSE OBJECTIVES

Upon completion of this program, participants should be able to :
Modifya SQL statement to perform at its best
Identifypoorly performing SQL
Tracean application through its different levels of the applicationarchitecture
Understandhow the Query Optimizer makes decisions about how to access data
Define how optimizer statistics affect the performance of SQL
Listthe possible methods of accessing data, including different joinmethods

PREREQUISITES

Familiarity with database architecture
Knowledgeof SQL and PL/SQL
Oracle Database: Introduction to SQL
RecommendedRelated Training Courses:
Using Java - for PL/SQL and Database Developers
ThisJava for PL/SQL and Developers training teaches you to accessOracle Database using JDBC, UCP, Java stored procedures and SQLJtechnologies. Learn to create, load, resolve and publish Javaclasses in the Database and more.

Modules

Module 1 - Introduction

Course Objectives, Course Agenda and Appendixes Used in this Course
Audienceand Prerequisites
SampleSchemas Used in the Course
ClassAccount Information
SQLEnvironments Available in the Course
Workshops,Demo Scripts, and Code Example Scripts
Appendicesin the Course

Module 2 - Introduction To SQL Tuning

SQLTuning Session
SQLTuning Strategies
DevelopmentEnvironments: Overview
SQLTXPLAIN(SQLT) Diagnostic Tool

Module 3 - Using Application Tracing Tools

Using the SQL Trace Facility: Overview
StepsNeeded Before Tracing
AvailableTracing Tools: Overview
Thetrcsess Utility
Formatting SQL Trace Files: Overview

Module 4 - Understanding Basic Tuning Techniques

Developing Efficient SQL statement
ScriptsUsed in This Lesson
TableDesign
IndexUsage
TransformedIndex
DataType Mismatch
NULLusage
Tune the ORDER BY Clause

Module 5 - Optimizer Fundamentals

SQLStatement Represent ation
SQLStatement Processing
WhyDo You Need an Optimizer?
Componentsof the Optimizer
QueryTransformer
Cost-BasedOptimizer
AdaptiveQuery Optimization
OptimizerFeatures and Oracle Database Releases

Module 6 - Generating And Displaying Execution Plans

Execution Plan?
The EXPLAIN PLAN Command
PlanTable
AUTOTRACE
V$SQL_PLANView
AutomaticWorkload Repository
SQLMonitoring

Module 7 - Interpreting Execution Plans And Enhancements

Interpreting a Serial Execution Plan
AdaptiveOptimizations

Module 8 - Optimizer: Table And Index Access Paths

RowSource Operations
MainStructures and Access Paths
FullTable Scan
Indexes
CommonObservations

Module 9 - Optimizer Join Operations

JoinMethods
JoinTypes

Module 10 - Other Optimizer Operators

SQLoperators
OtherN-Array Operations
ResultCache operators

Module 11 - Introduction To Optimizer Statistics Concepts

OptimizerStatistics
Types of Optimizer Statistics
Gatherand Manage Optimizer Statistics: Overview

Module 12 - Using Bind Variables

CursorSharing and Different Literal Values
CursorSharing and Bind Variables

Module 13 - SQL Plan Management

Maintaining SQL Performance
SQLPlan Management

Module 14 - Workshops

Address
ISQL GLOBAL
2nd Floor, 44, Nungambakkam High Road, Nungambakkam (Near HDFC Bank),
Chennai, Tamil Nadu 600034, India.
Phone : 044 - 2825 2013
Mobile : 94447 15658 / 98407 44654
E-mail : enquiry@isqlglobal.com
Keep Connected
WhatsApp: 9444715658

Twitter

Facebook

GooglePlus

Oracle Authorized Test Center

Attention! - Oracle® Authorized Test Center. Write Any Exam at Any Time (24 Hours/365 Days) in lowest price. (Free Exam Materials for Oracle Exams)

Oracle Database 12c SQL Tuning for Developers Training in Chennai SQLSTAR Global

Oracle Database 12c: SQL Tuning for Developers

Modules

Address

ISQL GLOBAL

Mobile : 94447 15658 / 98407 44654

E-mail : enquiry@isqlglobal.com

Keep Connected

Attention! - Oracle^® Authorized Test Center. Write Any Exam at Any Time (24 Hours/365 Days) in lowest price. (Free Exam Materials for Oracle Exams)