Professional training – Oracle Technologies

Oracle SQL Tuning

Oracle SQL Tuning in 6 focused hours: Reading execution plans, Index strategies and access paths and Join methods and join order – practical, with exercises and templates for your daily work.

Duration
6 hours, one session
Level
Expert
Format
Online or on-site
Language
German or English
Certificate
Certificate of attendance

Overview

“Oracle SQL Tuning” is a compact live course in the field of Oracle Technologies. It centres on Reading execution plans, Index strategies and access paths and Join methods and join order – explained with realistic examples and deepened in exercises you can transfer straight to your daily work.

Oracle databases and the surrounding middleware carry business-critical applications in many organizations, from ERP to specialist software. That calls for solid knowledge of operations, performance, security and development, and increasingly of cloud topics and migration. Our Oracle SQL Tuning courses are aimed at DBAs, developers and architects who want to run their environment reliably, remove bottlenecks precisely and make changes safely. You work in a provided lab environment on realistic tasks and take proven approaches back to your team. The course runs online or on site, lasts one day and is offered at a fixed price per participant.

The course is delivered live – either online in a virtual classroom or on-site in our training rooms in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run it exclusively for your team.

Focus areas of the course

Reading execution plansIndex strategies and access pathsJoin methods and join orderBind variables and cursor sharingSQL plan management and baselinesSQL Tuning Advisor

Who is this course for?

  • Database administrators (DBAs)
  • Application and database developers
  • System administrators with Oracle responsibility
  • IT architects and consultants in Oracle environments

What you will be able to do

  • You know the key topics of Oracle SQL Tuning – Reading execution plans, Index strategies and access paths, Join methods and join order, Bind variables and cursor sharing, SQL plan management and baselines and SQL Tuning Advisor – and can apply them in practice.
  • You apply Oracle SQL Tuning correctly and understand the underlying architecture.
  • You configure and operate Oracle SQL Tuning securely and traceably.
  • You identify bottlenecks and faults around Oracle SQL Tuning and resolve them methodically.
  • You prepare changes, migrations and recoveries reliably.

Course outline

Module 1 Architecture and concepts of Oracle SQL Tuning
  • Structure, background processes and storage structures at a glance
  • Where Oracle SQL Tuning fits into the overall Oracle architecture
  • Typical use cases and differences from alternatives
  • Licensing and option questions, as far as relevant for planning
Module 2 Focus areas: Oracle SQL Tuning
  • Reading execution plans
  • Index strategies and access paths
  • Join methods and join order
  • Bind variables and cursor sharing
  • SQL plan management and baselines
  • SQL Tuning Advisor
Module 3 Setup and configuration
  • Prerequisites and preparing the lab environment
  • Installation and base configuration step by step
  • Key parameters, defaults and their effects
  • Setting up users, privileges and access protection properly
Module 4 Operations, performance and availability
  • Daily operational tasks and routine maintenance
  • Using monitoring, diagnostic data and analysis tools
  • Identifying and resolving bottlenecks
  • Mastering backup, recovery and failure scenarios
Module 5 Practice, troubleshooting and best practices
  • Exercises on realistic data sets
  • Typical failure patterns and structured troubleshooting
  • Preparing changes, patches and migrations safely
  • Checklists and standards for production use
Module 6 Transfer to your daily work
  • Exercise based on a realistic case
  • Typical mistakes and how to avoid them
  • Checklist and templates to take away
  • Open questions, outlook and resources for further learning

Prerequisites

Basic knowledge of databases and SQL is helpful. Entry-level courses require no prior Oracle experience. Solid hands-on experience with the topic is expected.

Technical requirements

Laptop with a current browser and SSH client; the Oracle lab environment for Oracle SQL Tuning is provided by us.

Dates & locations

For every location we suggest a date roughly four weeks ahead. Your preferred date is always possible.

  • Munich Wed, 16 December 2026 6 hrs Request
  • Salzburg Mon, 14 December 2026 6 hrs Request
  • Berlin Fri, 11 December 2026 6 hrs Request
  • Augsburg Fri, 11 December 2026 6 hrs Request
  • Hanover Wed, 16 December 2026 6 hrs Request
  • Bremen Wed, 16 December 2026 6 hrs Request
  • Stuttgart Wed, 16 December 2026 6 hrs Request
  • Kaiserslautern Wed, 16 December 2026 6 hrs Request
  • Online Fri, 11 December 2026 6 hrs Request

Frequently asked questions

Who is the Oracle SQL Tuning course for?

The course is for DBAs, developers and architects who operate, build on or introduce Oracle SQL Tuning. Depending on the level, we start with the fundamentals or deepen tuning, high availability and migration. In a short pre-call we can clarify your priorities.

Do I need my own Oracle installation for the exercises?

No. For Oracle SQL Tuning we provide a prepared lab environment that you access via browser and SSH, and you carry out every exercise yourself. On request we also discuss scenarios from your own environment, without needing any production data.

How much does “Oracle SQL Tuning” cost?

The course costs a flat €949 plus VAT per participant – whether online or on-site. This includes 6 hours of live training with a trainer, course materials, a lab environment and a certificate of attendance.

Can I suggest my own date?

Yes. For every location we suggest a date roughly four weeks ahead. In the request form you can always describe your preferred date or period in free text – we check availability and get back to you within one working day.

Is the course online or on-site?

Both are possible: live online in a virtual classroom or on-site in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run the course exclusively for your team.

Can the course be tailored to our team?

Yes. Tailor-made courses cost approx. €4,500 more, depending on the topic and by arrangement. We agree content, examples and exercises with you in advance.

More courses in Oracle Technologies

All 28 courses in Oracle Technologies