Oracle Database 19c: SQL Tuning Workshop Training

The Oracle Database 19c: SQL Tuning Workshop Course is an experience-based course for SQL developers and database administrators who would like to optimise SQL queries for better execution performance within Oracle Database environments. The content of the course is designed to improve query performance by providing a better understanding of the Oracle Optimiser, the ability to view execution plans, and how you can apply methods of tuning your statements and improving their execution performance.  
The course will cover areas of the Oracle Optimiser, including, but not limited to, the Optimiser's behaviour, SQL plan management, the use of hints, and the use case for parameterised queries. The course will also touch on the tracing of SQL, using diagnostic tools, and how to pay attention to performance analysis to diagnose and improve SQL performance. The variety of real-case scenarios in the curriculum will provide practical skills for learning how to detect the symptoms of performance issues and will help with applying appropriate interventions.  
 
This workshop will enhance your efforts to optimise existing applications or develop new applications, supporting your SQL to operate increasingly faster and more efficiently. 
 
The Best Training Company offers this training, supporting individuals to learn skills that will enhance Oracle SQL tuning opportunities for individuals, teams, or businesses, which will improve the performance of applications that will collectively reduce the amount of shared resources consumed each time. 


Download Content
bannerImg

Learning Options for You

  • Live Training (Duration : 24 Hours)
  • Per Participant

Fee: On Request

Course Prerequisites

To gain the most from this course, participants should have prior experience with Oracle SQL and a fundamental understanding of Oracle database architecture. Knowledge of database objects, execution environments, and basic performance principles will support successful learning. 

  • Familiarity with writing and managing SQL queries in Oracle environments 
  • Basic understanding of Oracle database components, such as tables, indexes, and joins 
  • Prior exposure to database administration or application development practices 
  • Experience using Oracle tools (e.g., SQL*Plus, SQL Developer) is recommended but not mandatory 

Learning Objectives

By the end of this course, participants will be able to identify, analyse, and tune poorly performing SQL statements using Oracle’s recommended tools and techniques. Key skills and topics include: 

  • Understand Oracle’s SQL tuning methodology and best practices 
  • Interpret and analyse SQL execution plans 
  • Use SQL Tuning Advisor and SQL Access Advisor for optimisation 
  • Identify and resolve wait events and resource contention 
  • Optimise indexing strategies to improve query performance 
  • Understand optimiser statistics and their impact on query plans 
  • Monitor and tune SQL workloads using AWR and ASH reports 
  • Implement SQL plan baselines and profiles for consistent performance 
  • Apply advanced tuning techniques for complex SQL statements 

Target Audience

The Oracle Database 19c: SQL Tuning Workshop is intended for technical professionals involved in optimising database performance through query tuning. It is ideal for Oracle Database Administrators, SQL developers, performance engineers, and application support staff who work with mission-critical systems where efficiency and speed are essential. The course is also well-suited for consultants and architects responsible for analysing SQL workloads and ensuring high-performing applications. 

  • Oracle DBAs managing performance tuning and resource optimisation 
  • SQL developers create and maintain complex queries in enterprise applications 
  • Performance engineers are responsible for tuning SQL workloads in large datasets 
  • Application support personnel troubleshooting slow-running SQL statements 
  • Consultants and solution architects analyse query efficiency and system throughput 

Register Your Interest

captcha

FAQs

You will learn to identify and tune inefficient SQL statements, use Oracle tools for SQL tuning, and optimize database performance effectively.
This course prepares you for roles like Oracle Database Administrator, SQL Performance Tuning Specialist, or Database Consultant.
You should have a solid understanding of Oracle Database architecture, SQL fundamentals, and basic database administration.
The course duration is usually 3 to 4 days, depending on the chosen schedule.
Please contact SSDN Technologies for the latest course fee and any ongoing discounts.
Yes, the course materials and reference guides remain accessible to you even after completing the course.
Recordings may be available for online sessions; please check this with your training coordinator.
The course is conducted by Oracle-certified trainers with expertise in database performance tuning and years of industry experience.
You can opt to attend the course either online or in a classroom setting, based on your preference.
Yes, you will be awarded a certificate of completion once you successfully finish the training.

Our Learners Say About Our Courses

underline
testimonialImg