Warning: Illegal string offset '@type' in /home/braincon/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-opengraph.php on line 46

Warning: Illegal string offset '@type' in /home/braincon/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-frontend.php on line 72

Warning: Illegal string offset '@type' in /home/braincon/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-jsonld.php on line 323

Warning: Illegal string offset '@type' in /home/braincon/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-frontend.php on line 106

Warning: Illegal string offset '@id' in /home/braincon/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-frontend.php on line 168

Warning: Illegal string offset '@type' in /home/braincon/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-frontend.php on line 170

Warning: Illegal string offset 'isPartOf' in /home/braincon/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-jsonld.php on line 491

Warning: Illegal string offset 'publisher' in /home/braincon/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-jsonld.php on line 507

Warning: Illegal string offset 'image' in /home/braincon/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-jsonld.php on line 474

Warning: Illegal string offset 'inLanguage' in /home/braincon/public_html/wp-content/plugins/seo-by-rank-math/includes/modules/schema/class-jsonld.php on line 462
Book a call

Oracle SQL - Performance Tuning

Category:

Description

This course is developed by Brain Concert in order for you to learn and practice 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.

Objectives

Modify a SQL statement to perform at its best
Identify poorly performing SQL
Trace an application through its different levels of the application architecture
Understand how the Query Optimizer makes decisions about how to access data
Define how optimizer statistics affect the performance of SQL
List the possible methods of accessing data, including different join methods

Audience

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

Duration

3 days

Requirements

Familiarity with database architecture
Knowledge of SQL and PL/SQL
Oracle Database: Introduction to SQL Ed 1.1

Curriculum

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

Resources

40 Best Database Performance Tuning Books of All Time

SQL Tuning Overview

Classes

City
Date
Duration
Language
Format
Price Early bird
Price Regular
GTR

We provide

Online or On-site delivery

We created a personalised delivery strategy by offering blending learning

Communities of practice

Find a bunch of people who are on the same page with you

Engaged Learning

Engaging platform with gamification for collaboration and friendly competition

Interactive training

We created a personalised delivery strategy by offering blending learning

Learning efficiency

A special learning environment can boost learning efficiency

Learning everywhere

Available anywhere and anytime on your phone, computer or tablet

FAQ

Can you organise virtual training sessions or only face to face trainings?

Yes, you can choose an online or an offline training session. We use Knolyx, an e-learning platform, to make the process of online training and mobile learning delivery as efficient as a face-to-face training session. You can check here a complete list of features set.

Should we deliver online or offline classes?

That's up to you. We offer you an efficient learning environment and you can use it according to your needs: either online or offline. Nobody knows better than you and your team what you need, so we do not imposed some predefined criteria, we adapt to yours.

Can you customize courses to suit our particular requirements?

Yes. We offer training consultancy and we establish the most appropriate courses according to the specific needs and business objectives of your company.
Subscribe to knowledge
© BrainConcert 2021 All rights reserved
cloudcloud-syncinboxuserspower-switchlayers