Adding Value Consulting
Oracle 19c SQL Performance Tuning - 2 days Online Classroom
IT Service & Architecture
Data Analysis

Oracle 19c SQL Performance Tuning - 2 days Online Classroom

1.450,00 EUR

  • 2 days
Live Virtual Classroom
Classroom
In House / In Company

Improve the speed and efficiency of your Oracle databases with the Oracle 19c SQL Performance Tuning course. This practical two-day training equips SQL developers, database professionals, and application support teams with the techniques needed to identify, analyse, and resolve SQL performance issues. Through hands-on exercises, you'll learn how Oracle's optimizer works, interpret execution plans, use SQL Trace and Autotrace, optimise joins and indexes, and apply SQL Tuning Advisor recommendations. By the end of the course, you'll be able to write faster, more efficient SQL that enhances application performance and database responsiveness.

Key Features

Language

Course and materials are in English

Level

Intermediate level

2 days (8 hours / day) live classroom

with accredited trainers

30+ recommended study hours

Exercises and solutions

Downloadable PDF documents with detailed content (slides, explanations)

Certificate

Certificate of completion available

Hero

Learning Outcomes

At the end of this course, you will be able to:

Understand

Explore cost-based optimisation, optimizer modes, dynamic statistics, adaptive optimisation, and query transformations. By understanding how Oracle evaluates and executes queries, you'll be better equipped to improve SQL performance and influence execution plans effectively.

Examine

Examine access paths, indexing strategies, partitioning, and optimizer statistics to improve query efficiency and reduce execution time across complex database workloads.

Develop

Develop the skills to fine-tune SQL execution by applying Oracle hints to influence optimizer decisions, join methods, and access paths.

Implement

Learn how Oracle handles views, inline views, and the WITH clause, enabling you to optimize query transformations and achieve more consistent, high-performing SQL execution.

Hero

Course timeline

  1. Oracle SQL Performance Tuning Fundamentals

    Day 1

    • Understand Oracle SQL performance tuning concepts, roles, and best practices for developers and DBAs.
    • Analyse SQL execution using Explain Plan, Autotrace, SQL Trace, and performance analysis tools.
    • Explore the Oracle Optimizer, cost-based optimisation, adaptive features, and statistics management.
    • Learn how Oracle processes sorting operations and manages temporary storage during query execution.
    • Design and optimise indexes, including B-tree, composite, and descending indexes for improved performance.
    • Identify optimal access paths and understand the factors that influence Oracle's execution plans.

  2. Advanced SQL Optimisation Techniques

    Day 2

    • Implement advanced indexing strategies, including bitmap, function-based, compressed, invisible, and partitioned indexes.
    • Optimise SQL joins by selecting the most efficient join methods and access paths.
    • Improve SQL performance using SQL Tuning Advisor and the DBMS_SQLTUNE package.
    • Enhance query design with sequence caching, views, inline views, and the WITH clause.
    • Influence execution plans using Oracle hints, query transformations, and join optimisation techniques.
    • Apply SQL performance best practices, including bind variables, result caching, cursor sharing, and PL/SQL optimisation.
Oracle 19c SQL Performance Tuning

Who Should Enroll in this Program?

SQL Developers

Oracle Database Developers

Application Developers

Oracle Database Administrators (DBAs)

Technical Support Engineers

IT professionals responsible for improving Oracle SQL performance

Start course now

Prerequisites

  • A working knowledge of Oracle SQL
  • Experience writing SQL queries in Oracle Database
  • Knowledge equivalent to an Oracle SQL fundamentals course is recommended
  • Basic familiarity with Oracle database concepts and SQL Developer is beneficial.

Licensing

and equality policy

Licensing and accreditation

This course is offered according to Partner Program Agreement and complies with the License Agreement requirements.

Equity Policy

AVCdoes not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.

Frequently Asked Questions

Contact background

Need a Custom In-company or Group Training?

Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.