Professional training – Oracle Technologies

PL/SQL Fundamentals

PL/SQL Fundamentals in 6 focused hours: Block structure and variables, Control structures and loops and Cursors – practical, with exercises and templates for your daily work.

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

Overview

“PL/SQL Fundamentals” is a compact live course in the field of Oracle Technologies. It centres on Block structure and variables, Control structures and loops and Cursors – 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 PL/SQL Fundamentals 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

Block structure and variablesControl structures and loopsCursorsException handlingProcedures and functionsTriggers overview

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 PL/SQL Fundamentals – Block structure and variables, Control structures and loops, Cursors, Exception handling, Procedures and functions and Triggers overview – and can apply them in practice.
  • You apply PL/SQL Fundamentals correctly and understand the underlying architecture.
  • You configure and operate PL/SQL Fundamentals securely and traceably.
  • You identify bottlenecks and faults around PL/SQL Fundamentals and resolve them methodically.
  • You prepare changes, migrations and recoveries reliably.

Course outline

Module 1 Architecture and concepts of PL/SQL Fundamentals
  • Structure, background processes and storage structures at a glance
  • Where PL/SQL Fundamentals 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: PL/SQL Fundamentals
  • Block structure and variables
  • Control structures and loops
  • Cursors
  • Exception handling
  • Procedures and functions
  • Triggers overview
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. No prior knowledge is required.

Technical requirements

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

Dates & locations

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

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

Frequently asked questions

Who is the PL/SQL Fundamentals course for?

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