Professional training – Oracle Technologies

Advanced PL/SQL

Hands-on Advanced PL/SQL course: you work on Packages and encapsulation, Collections and BULK COLLECT and FORALL and performance and take away knowledge you can apply right away.

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

Overview

In “Advanced PL/SQL” we combine fundamentals and practice: you get to know Packages and encapsulation, Collections and BULK COLLECT and FORALL and performance, apply what you learn in exercises and receive templates and checklists for your own use.

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 Advanced PL/SQL 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

Packages and encapsulationCollections and BULK COLLECTFORALL and performanceDynamic SQLAutonomous transactionsUnit testing and debugging

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 Advanced PL/SQL – Packages and encapsulation, Collections and BULK COLLECT, FORALL and performance, Dynamic SQL, Autonomous transactions and Unit testing and debugging – and can apply them in practice.
  • You apply Advanced PL/SQL correctly and understand the underlying architecture.
  • You configure and operate Advanced PL/SQL securely and traceably.
  • You identify bottlenecks and faults around Advanced PL/SQL and resolve them methodically.
  • You prepare changes, migrations and recoveries reliably.

Course outline

Module 1 Architecture and concepts of Advanced PL/SQL
  • Structure, background processes and storage structures at a glance
  • Where Advanced PL/SQL 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: Advanced PL/SQL
  • Packages and encapsulation
  • Collections and BULK COLLECT
  • FORALL and performance
  • Dynamic SQL
  • Autonomous transactions
  • Unit testing and debugging
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. Basic knowledge of the topic is helpful.

Technical requirements

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

Dates & locations

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

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

Frequently asked questions

Who is the Advanced PL/SQL course for?

The course is for DBAs, developers and architects who operate, build on or introduce Advanced PL/SQL. 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 Advanced PL/SQL 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 “Advanced PL/SQL” 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