Oracle Database is one of the most widely used relational database systems for demanding applications. Its strengths are reliability, scalability and security – provided that the data model, queries and operations are set up properly.
In our Oracle Database courses, you work hands-on in a database environment. You write and optimise SQL queries, understand tables, indexes and access rights, set up backup and recovery procedures and learn to identify bottlenecks before they affect operations.
PL/SQL is the Oracle database's programming language – and the way to build logic that runs right where the data lives. Over five days you build blocks, cursors, procedures, functions, packages and triggers, and learn to catch errors cleanly. The course works on the current Oracle AI Database 26ai (formerly Oracle Database 23ai) and prepares you for exam 1Z0-149 «Oracle Database Program with PL/SQL» – Oracle's only current PL/SQL certification.
An introduction to SQL on the Oracle database – from your first query to subqueries, joins and creating your own objects. The course works on the current Oracle AI Database 26ai, which emerged from Oracle Database 23ai in October 2025 and has also been available as an on-premises version for Linux since January 2026. Alongside classic SQL craft, you get to know the platform's new capabilities: JSON, property graphs and AI Vector Search directly in SQL. The course prepares you for the Oracle AI Database SQL Associate certification (exam 1Z0-171).
The advanced course for anyone who already uses PL/SQL and now wants to develop more cleanly, securely and quickly. The focus is on packages and program structure, bulk processing, dynamic SQL, compound triggers, LOBs and JSON – plus an extensive block on performance: compiler optimisation, Result Cache, profiling with DBMS_HPROF and PL/Scope. On top of that, the new capabilities of Oracle AI Database 26ai (formerly 23ai) from a developer's perspective: duality views, vectors and SQL Firewall.
The foundation administration course on the current Oracle AI Database 26ai release. You get to know the architecture, create databases, operate instances, configure Oracle Net, work with the multitenant architecture, manage storage, users and privileges, load and transport data, and get an introduction to monitoring and performance. New compared to the 19c world: AI Vector Search, JSON Duality Views, SQL Firewall and True Cache from an administration perspective. The course prepares you for the Oracle AI Database Administration Associate certification (exam 1Z0-182).
The advanced course for production operations: patching and upgrading, multitenant in depth, backup and recovery strategies with RMAN and Flashback, performance diagnostics with AWR, ADDM and Active Session History, SQL and optimizer tuning, and memory management and In-Memory. Plus what's new in Oracle AI Database 26ai from an operations perspective. Oracle now bundles these topics in the learning path for the Oracle AI Database Administration Professional certification (exam 1Z0-183) – this course covers them compactly in one week.
