Ways to train
Live, instructor-led training in a standard, professional classroom environment
Live, instructor-led training conducted over the internet, with hands-on labs
An online, HTML5, self-paced learning experience available for all courses
Private training for your entire team, delivered at your location, a training center, or online
Video classroomLearn more about our training formats
High-definition video of our most popular courses, streamed to your laptop or personal device
3 Day with 08 hours per day
Mon 26 Sep 09:00 - Wed 28 Sep 17:00
HRDF SBL Claimable
Certificate of Attendance available
All of our private classes are customized to your organization's needs.
Click on the button below to send us your details and you will be contacted shortly.
Request more information
Inquiry for: Myself My Company
Our learning consultant will get back to you in 1 business day
Oracle Database 19c: SQL Tuning Workshop
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.
• Use Oracle tools to identify inefficient SQL.
• Use Automatic SQL Tuning.
• Use Real Time SQL monitoring.
• Write more efficient SQL statements.
• Monitor and trace high load SQL statements.
• Manage optimizer statistics on database objects.
• Understand the optimizer process steps and
• Interpret execution plans.
• Perform application tracing.
Benefits to You:
• Benefit from gaining a deeper understanding of Oracle.
• SQL statement tuning and how 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.
This course is specially design for Application Developers, Data Warehouse Developer, Developer,
PL/SQL Developer and Support Engineer
• Familiarity with database architecture
• Knowledge of SQL and PL/SQL
• Oracle Database: Introduction to SQL
Recommended Related Training Courses:
• Using Java - for PL/SQL and Database Developers
This Java for PL/SQL and Developers training teaches you to access Oracle Database using JDBC, UCP, Java stored procedures and SQLJ technologies. Learn to create, load, resolve and publish Java classes in the Database and more.
• Oracle Database: SQL Workshop II
This Oracle Database: SQL Workshop II helps you manage the database objects, data dictionary views and multiolumn sub queries. Learn to write more efficient queries using the functions supporting the timezone and regular expressions.
• Oracle Database: SQL Tuning for Developers
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.
• Oracle Database: Develop PL/SQL Program Units
This Oracle Database: Develop PL/SQL Program Units training helps you enhance your skills by developing stored procedures, functions, packages, and database triggers. Learn to manage PL/SQL program units and use Oracle-supplied packages.
• Oracle Database: PL/SQL Fundamentals
Oracle Database: PL/SQL Fundamentals introduces you to the PL/SQL programming language. Learn about stored procedures, functions and creating blocks of application code that can be shared by multiple forms and data management applications.
This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises.
Upon completion of this program, participants should be able to:
• 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.
• Course Introduction
• Workshop 1: Enhancing the Performance of a SQL Query Statement
• Introduction to SQL Tuning
• Quick Solution Strategy
• Workshop 2: Reviewing the Execution Steps of the SQL Statement
• Practice 2-1: Using SQL Developer
• Using Application Tracing Tools
• trcsess Utility
• Workshop 3: Learn to Tune Sort Operation Using an Index in the ORDER BY Clauses
• Practice 3-1: Tracing Applications (Part 01)
• Practice 3-1: Tracing Applications (Part 02)
• Optimizer Fundamentals
• Query Estimator: Selectivity and Cardinality
• Plan Generator
• Workshop 4: Identifying and Tuning a Poorly Written SQL Statement
• Practice 4-1: Understanding Optimizer Decisions (Optional)
• Generating and Displaying Execution Plans
• Automatic Workload Repository
• Workshop 5: Effects of Changing the Column Order in a Composite Index
• Practice 5-1: Extracting an Execution Plan by Using SQL Developer
• Practice 5-2: Extracting Execution Plans
• Interpreting Execution Plans and Enhancements
• Workshop-6: Using Information in the 10053 File to Tune a SQL Statement
• Practice 6-1: Using Dynamic Plans
• Optimizer: Table and Index Access Paths
• Indexes: Overview
• Bitmap Indexes
• Common Observations
• Workshop 7: Understanding the Optimizer’s Decision
• Practice 7-1: Using Different Access Paths (Part 01)
• Practice 7-1: Using Different Access Paths (Part 02)
• Practice 7-1: Using Different Access Paths (Part 03)
• Practice 7-1: Using Different Access Paths (Part 04)
• Optimizer: Join Operators
• Workshop 8: Tuning Strategy
• Practice 8: Using Join Paths
• Other Optimizer Operators
• Workshop 9: Using SQL Plan Baseline to Manage a Better Execution Plan
• Practice 9-1: Using the Result Cache
• Practice 9-2: Using Other Access Paths (Optional)
• Introduction to Optimizer Statistics Concepts
• Column Statistics: Histograms
• Session-Specific Statistics for Global Temporary Tables
• Practice 10-1: Index Clustering Factor
• Practice 10-2: Creating Expression Statistics
• Practice 10-3: Enabling Automatic Statistics Gathering Optional (Part 01)
• Practice 10-3: Enabling Automatic Statistics Gathering Optional (Part 02)
• Practice 10-4: Using System Statistics (Optional)
• Using Bind Variables
• Cursor Sharing Enhancements
• Practice 11-1: Using Adaptive Cursor Sharing
• Practice 11-2: Using CURSOR_SHARING (Optional)
• SQL Plan Management
• Configuring SQL Plan Management
• Possible SQL Plan Manageability Scenarios
• Practice 12-1: Using SQL Plan Management SPM (Part 01)
• Practice 12-1: Using SQL Plan Management SPM (Part 02)
Genesis Douglas Row
Mr. Genesis Douglas Row has been working in the IT industry since 1996 and has contributed more than 17 years to the industry. Along the years, he has picked up skills in sales, marketing, business management, presales and product management that has made him an all-rounded skilled and experienced IT personnel in the industry.He has a strong technical background in Oracle Database Management, Solaris System Administration and Web Publishing. He has also proven to be a very talented and passionate trainer in delivering easy-to-understand, straight-to-the-point training sessions. He utilizes effective training techniques for maximum knowledge transfer, information retention and customer satisfaction. Read More