Professional training – Oracle Technologies

Oracle SQL Fundamentals

Hands-on Oracle SQL Fundamentals course: you work on SELECT, WHERE, ORDER BY, Joins and set operators and Aggregate functions and GROUP BY and take away knowledge you can apply right away.

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

Overview

In “Oracle SQL Fundamentals” we combine fundamentals and practice: you get to know SELECT, WHERE, ORDER BY, Joins and set operators and Aggregate functions and GROUP BY, 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 Oracle 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

SELECT, WHERE, ORDER BYJoins and set operatorsAggregate functions and GROUP BYSubqueriesDML and transactionsCreating tables, constraints and views

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 Fundamentals – SELECT, WHERE, ORDER BY, Joins and set operators, Aggregate functions and GROUP BY, Subqueries, DML and transactions and Creating tables, constraints and views – and can apply them in practice.
  • You apply Oracle SQL Fundamentals correctly and understand the underlying architecture.
  • You configure and operate Oracle SQL Fundamentals securely and traceably.
  • You identify bottlenecks and faults around Oracle SQL Fundamentals and resolve them methodically.
  • You prepare changes, migrations and recoveries reliably.

Course outline

Module 1 Architecture and concepts of Oracle SQL Fundamentals
  • Structure, background processes and storage structures at a glance
  • Where Oracle 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: Oracle SQL Fundamentals
  • SELECT, WHERE, ORDER BY
  • Joins and set operators
  • Aggregate functions and GROUP BY
  • Subqueries
  • DML and transactions
  • Creating tables, constraints and views
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 Oracle 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 Wed, 16 December 2026 6 hrs Request
  • Salzburg Fri, 11 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 Thu, 10 December 2026 6 hrs Request
  • Kaiserslautern Fri, 11 December 2026 6 hrs Request
  • Online Tue, 15 December 2026 6 hrs Request

Frequently asked questions

Who is the Oracle SQL Fundamentals course for?

The course is for DBAs, developers and architects who operate, build on or introduce Oracle 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 Oracle 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 “Oracle 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