This Oracle SQL - Performance Tuning course is developed 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.
Modify an Oracle 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
Data Warehouse Developer
Familiarity with database architecture
Knowledge of Oracle SQL and PL/SQL
Oracle Database: Introduction to SQL Ed 1.1
Introduction to Oracle 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 Oracle SQL statement
Scripts Used in This Lesson
Data Type Mismatch
Tune the ORDER BY Clause
SQL Statement Representation
SQL Statement Processing
Why Do You Need an Optimizer?
Components of the Optimizer
Adaptive Query Optimization
Optimizer Features and Oracle Database Releases
Generating and Displaying Execution Plans
The EXPLAIN PLAN Command
Automatic Workload Repository
Interpreting Execution Plans and Enhancements
Interpreting a Serial Execution Plan
Optimizer: Table and Index Access Paths
Row Source Operations
Main Structures and Access Paths
Full Table Scan
Optimizer Join Operations
Other Optimizer Operators
Other N-Array Operations
Result Cache operators
Introduction to Optimizer Statistics Concepts
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
Oracle SQL Plan Management
We created a personalized delivery strategy by offering blended learning
Find a bunch of people who are on the same page with you.
Engaging platform with gamification for collaboration and friendly competition.
Interactive online trainings and live webinars available.
A special learning environment can boost learning efficiency.
Available anywhere and anytime, on your phone, computer or tablet.
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.
Yes. We offer training consultancy and we establish the most appropriate courses according to the specific needs and business objectives of your company.