Oracle Database

An end-to-end Oracle Database curriculum from SQL and PL/SQL through instance/storage internals, optimizer, multitenant architecture, RMAN, Data Guard, RAC concepts, security, partitioning, performance diagnostics, Flashback, JSON/vector/AI features, and production operations.

Browse curriculum Back to all courses

29chapters

145lesson paths

Intermediate → Expertlearning level

Publishedcourse state

Coverage baselineOracle AI Database 26ai LTS baseline, including converged and AI/vector capabilities

Course brief

From engine fundamentals to advanced production operations.

This syllabus deliberately separates conceptual foundations, hands-on SQL, engine internals, operational tooling, reliability, security, performance, and capstone work so each lesson can go deep without compressing advanced subjects into generic chapters.

By the end

You will be able to

Write advanced Oracle SQL and PL/SQL and reason about optimizer and cursor behavior
Understand multitenant, redo/undo, storage, indexing, partitioning, parallelism, and RAC concepts
Operate RMAN, Flashback, Data Guard, security, auditing, patching, and diagnostic tooling
Use converged Oracle capabilities including JSON, spatial, graph, vector search, and AI-oriented features
Design and defend a resilient production Oracle architecture with tested recovery and upgrade procedures

Complete syllabus

29 chapters · 145 lessons.

Every lesson path was reserved in the planned syllabus and is now linked because its lesson HTML is available. The sequence moves from foundations through internals, advanced features, administration, reliability, security, tuning, upgrades, and a production capstone.

Chapter 1

Oracle AI Database Foundations, Editions, Deployment Models, and Lab Setup

5 lessons

Oracle Database Architecture, Converged Database Model, Workloads, and Product TerminologyPublished lesson · Chapter01/Lesson1.html

Oracle Database

From engine fundamentals to advanced production operations.

You will be able to

29 chapters · 145 lessons.

Oracle AI Database Foundations, Editions, Deployment Models, and Lab Setup

Instance Architecture: SGA, PGA, Processes, Sessions, and Startup/Shutdown

Physical Storage: Datafiles, Tablespaces, Blocks, Segments, Extents, and ASM Concepts

Users, Schemas, Objects, Data Types, Keys, Constraints, and Sequences

Oracle SQL Fundamentals: Joins, Subqueries, Set Operations, and Hierarchical Queries

Advanced SQL: Analytic Functions, MODEL, PIVOT, MATCH_RECOGNIZE, and SQL Macros

DML, Transactions, Read Consistency, Undo, Locks, and Concurrency

B-Tree, Bitmap, Function-Based, Domain, and Specialized Indexes

Optimizer Internals, Statistics, Execution Plans, and SQL Tuning

Shared Pool, Cursor Management, Bind Variables, and SQL Execution Lifecycle

PL/SQL Fundamentals: Blocks, Types, Procedures, Functions, and Packages

Triggers, Dynamic SQL, Scheduler, Advanced PL/SQL, and Database APIs

Multitenant Architecture: CDBs, PDBs, Services, Cloning, and Lifecycle

Redo, Undo, Control Files, Checkpoints, and Instance Recovery

RMAN Backup, Restore, Recovery, and Disaster-Recovery Engineering

Flashback Technologies, Recycle Bin, Data Archive, and Recovery Without Restore

Data Guard, Standby Databases, Broker, and High Availability

RAC and Clustered Oracle Concepts

Partitioning, Parallel Execution, Compression, and Very Large Databases

Security: Privileges, Roles, Profiles, Unified Auditing, VPD, and Encryption

Resource Manager, Workload Governance, Services, and Capacity Control

Observability and Diagnostics: AWR, ASH, ADDM, Wait Events, and Tracing

Performance Engineering: Memory, I/O, SQL, Parallelism, and Contention

JSON, XML, Spatial, Graph, and Converged Data Capabilities

AI Vector Search, VECTOR Data, Select AI, and AI-Enabled Database Workloads

Sharding, Distributed Database Concepts, and Global Data Placement

Application Integration: Drivers, Pools, Session State, Transactions, and Resilience

Upgrades, Patching, Data Pump, Migration, and Zero/Low-Downtime Change

Production Capstone: Architect, Secure, Tune, Protect, and Operate Oracle

Help the academy stay free and grow.