Enterprise Academy · Database platform

Oracle AI Database 26ai Platform Master Programme

Understand how Oracle works. And why it behaves as it does under load.

Master the complete Oracle AI Database 26ai enterprise platform from first principles to expert production architecture. This is not a short Oracle SQL course and not a collection of product demonstrations. The programme builds the knowledge required to understand, build, administer, secure, tune, recover, scale and architect mission-critical Oracle platforms.

600 chapters · 15 tracks · 5 levels of mastery

Enrol or enquire See the 600 chapters
Curriculum

15 tracks · 600 chapters

Every track is 40 chapters. Open any track for its full chapter list, in teaching order.

T01 Database, Linux & Oracle Foundations Ch 1-40 · 40 chapters

Computer architecture, storage, processes, memory, Linux, filesystems, networking, relational theory, ACID, transactions, concurrency, locks, Oracle terminology, client/server architecture, Oracle homes, database files, instances, services and the complete Oracle platform mental model.

  1. Data Platforms, OLTP, Analytics and AI Workloads
  2. Relational Database Principles and the Relational Model
  3. Tables, Rows, Columns, Keys and Relationships
  4. Integrity Constraints and Data Quality Fundamentals
  5. SQL, PL/SQL and Oracle Programming Layers
  6. ACID Transaction Fundamentals
  7. Isolation, Consistency and Concurrency
  8. Undo, Redo and Durability Mental Model
  9. Locks, Latches and Database Coordination
  10. Read Consistency and Oracle Multiversion Concurrency
  11. Oracle AI Database 26ai Platform Architecture
  12. Oracle Database versus Oracle Instance
  13. Physical versus Logical Database Structures
  14. Data Blocks, Extents and Segments
  15. Datafiles, Tempfiles and Control Files
  16. Online Redo Logs and Archived Redo
  17. System Global Area Architecture
  18. Programme Global Area and Process Memory
  19. Oracle Background Processes
  20. Server Processes, Sessions and Connections
  21. Checkpoints and Instance Recovery
  22. System Change Numbers and Transaction Ordering
  23. Schemas, Schema Objects and Namespaces
  24. Data Dictionary and Dynamic Performance Views
  25. Multitenant CDB and PDB Concept Preview
  26. Services, Instances and Connection Routing
  27. Oracle Net Listener Fundamentals
  28. Linux Users, Groups and Process Fundamentals for Oracle
  29. Linux Filesystems, Devices and Permissions for Oracle
  30. Linux CPU, Memory and I/O Fundamentals for DBAs
  31. Linux Networking and Name Resolution for Oracle
  32. ORACLE_BASE, ORACLE_HOME and Environment Architecture
  33. Oracle Software Installation Architecture
  34. Building a Personal Oracle AI Database Free 26ai Lab
  35. Oracle Editions, Options and Licensing Fundamentals
  36. Oracle 26ai Release Model and Release Updates
  37. The Converged Database Platform Concept
  38. Backup versus High Availability versus Disaster Recovery
  39. Database Security, Least Privilege and Audit Fundamentals
  40. End-to-End Oracle Platform Mental Model
T02 Oracle SQL, Data Modelling & PL/SQL Engineering Ch 41-80 · 40 chapters

Oracle SQL from fundamentals through advanced analytics, joins, subqueries, set operations, DML, DDL, objects, constraints, indexes, sequences, views, materialized views, partitioning, SQL analytics, procedural PL/SQL, packages, procedures, functions, cursors, bulk processing, exceptions, triggers, dynamic SQL and production PL/SQL engineering.

  1. Oracle SQL Processing Model
  2. SELECT Fundamentals and Projection
  3. Filtering, Predicates and Three-Valued Logic
  4. Oracle Data Types and Type Conversion
  5. NULL Semantics and NULL-Safe Design
  6. Character, Numeric and Date-Time Functions
  7. CASE Expressions and Conditional SQL
  8. Joins and Relational Composition
  9. Outer Joins, Self Joins and Advanced Join Semantics
  10. GROUP BY, Aggregation and HAVING
  11. Scalar and Correlated Subqueries
  12. EXISTS, IN and Semi-Join Thinking
  13. Set Operators and Set-Based Design
  14. INSERT, UPDATE, DELETE and MERGE
  15. Transaction Control with COMMIT, ROLLBACK and SAVEPOINT
  16. DDL, Object Lifecycle and Implicit Commit Behaviour
  17. Primary, Unique, Foreign Key and Check Constraints
  18. Views and Security-Aware Abstraction
  19. Sequences, Identity Columns and Key Generation
  20. B-Tree, Bitmap and Function-Based Index Concepts
  21. Partitioned Tables and Partitioned Indexes
  22. Analytic Functions and Window Processing
  23. Hierarchical Queries and Recursive SQL
  24. Advanced Grouping, PIVOT and UNPIVOT
  25. SQL Execution Semantics and Deterministic Results
  26. PL/SQL Architecture and Anonymous Blocks
  27. Variables, Constants, Records and Collections
  28. PL/SQL Control Structures
  29. Explicit and Implicit Cursors
  30. Exception Handling and Error Propagation
  31. Stored Procedures and Functions
  32. Packages, Package State and Encapsulation
  33. Triggers and Their Appropriate Use
  34. Dynamic SQL with Native Dynamic SQL
  35. Bulk SQL with BULK COLLECT and FORALL
  36. PL/SQL Transaction Boundaries and Autonomous Transactions
  37. PL/SQL Performance and Context Switching
  38. Secure PL/SQL and Definer versus Invoker Rights
  39. Database Application Design Patterns
  40. SQL and PL/SQL Engineering Capstone
T03 Core Oracle DBA Ch 81-120 · 40 chapters

Installation, DBCA, startup and shutdown, instance architecture, SGA, PGA, background processes, control files, redo, undo, checkpoints, tablespaces, datafiles, temporary storage, initialization parameters, SPFILE, password files, data dictionary, dynamic performance views, users, profiles, privileges, services, listeners, jobs and operational DBA routines.

  1. DBA Responsibilities and the Production Database Lifecycle
  2. Planning an Oracle AI Database 26ai Installation
  3. Linux Prerequisites and Preinstallation Validation
  4. Installing Oracle AI Database Software
  5. Creating Databases with DBCA
  6. Understanding Database Creation Internals
  7. Starting, Mounting, Opening and Shutting Down a Database
  8. PFILE, SPFILE and Initialization Parameter Management
  9. Password Files and Administrative Authentication
  10. SGA Configuration and Memory Management
  11. PGA Configuration and Workarea Management
  12. Control File Architecture and Multiplexing
  13. Online Redo Log Architecture and Multiplexing
  14. ARCHIVELOG Mode and Archive Destination Management
  15. Undo Tablespaces and Automatic Undo Management
  16. Temporary Tablespaces and Temporary Segments
  17. Permanent Tablespaces and Segment Space Management
  18. Datafiles, Autoextend and Oracle Managed Files
  19. Fast Recovery Area Architecture and Management
  20. Block Size, Extents and Segment Storage
  21. Users, Schemas and Account Administration
  22. System Privileges, Object Privileges and Roles
  23. Profiles, Password Policies and Resource Limits
  24. Oracle Net Service Naming and Client Connectivity
  25. Listener Administration and Dynamic Service Registration
  26. Database Services and Workload-Aware Connectivity
  27. Database Links and Distributed Database Fundamentals
  28. Oracle Scheduler Jobs and Programmes
  29. Database Resource Manager Fundamentals
  30. Alert Log, Trace Files and ADR
  31. ADRCI and Diagnostic Incident Packaging
  32. Dynamic Performance Views for Daily DBA Work
  33. Data Dictionary Views for Daily DBA Work
  34. Data Pump Export Architecture
  35. Data Pump Import and Metadata Movement
  36. SQL*Loader, External Tables and Bulk Loading
  37. Statistics Collection and Routine Maintenance
  38. Space Monitoring and Capacity Management
  39. Daily, Weekly and Monthly DBA Runbooks
  40. Core DBA Production Readiness Assessment
T04 Multitenant DBA & Database Consolidation Ch 121-160 · 40 chapters

CDB architecture, root containers, PDBs, application containers, seed databases, creating and cloning PDBs, unplug/plug, refreshable clones, relocation, services, resource management, security boundaries, backup and recovery, patching, upgrades and enterprise consolidation.

  1. Why Oracle Multitenant Exists
  2. CDB, Root, Seed and PDB Architecture
  3. Container IDs, Namespaces and CON_ID
  4. Common versus Local Users and Roles
  5. Common versus Local Objects and Metadata
  6. Creating a Container Database
  7. Creating a PDB from the Seed
  8. Creating a PDB from Another PDB
  9. Hot Cloning a PDB
  10. Snapshot Copy PDBs
  11. Unplugging and Plugging PDBs
  12. PDB Compatibility and Plug-In Violations
  13. PDB Relocation between CDBs
  14. Refreshable Clone PDBs
  15. PDB Services and Connection Routing
  16. Opening, Closing and Saving PDB State
  17. PDB Storage and Tablespace Management
  18. PDB Resource Management and Resource Plans
  19. PDB Memory and I/O Governance
  20. Lockdown Profiles and PDB Isolation
  21. TDE and Keystore Considerations in Multitenant
  22. Common Audit Policies and PDB Auditing
  23. Application Containers and Application Roots
  24. Application PDBs and Application Seeds
  25. Application Installation and Synchronization
  26. PDB Data Pump Export and Import
  27. PDB Backup Architecture
  28. PDB Restore and Recovery
  29. PDB Point-in-Time Recovery
  30. PDB Flashback and Restore Points
  31. PDB Cloning for Dev/Test
  32. PDB Lifecycle Automation
  33. PDB Upgrade and Compatibility Management
  34. PDB Patching and Fleet Maintenance Concepts
  35. PDBs in Oracle RAC
  36. PDBs with Oracle Data Guard
  37. Consolidation Density and Noisy-Neighbour Control
  38. Multitenant Security Boundaries and Governance
  39. Multitenant Troubleshooting and Failure Scenarios
  40. Enterprise Multitenant Consolidation Architecture
T05 Grid Infrastructure, ASM, ACFS & Storage Engineering Ch 161-200 · 40 chapters

Oracle Grid Infrastructure, Oracle Restart, ASM architecture, ASM instances, disk groups, allocation units, extents, striping, mirroring, failure groups, redundancy, rebalance, ASM Filter Driver concepts, Flex ASM, ACFS, ADVM, storage monitoring, disk failure and recovery.

  1. Oracle Grid Infrastructure Architecture
  2. Oracle Restart versus Clustered Grid Infrastructure
  3. Grid Infrastructure Installation Planning
  4. Cluster Nodes, Cluster Membership and Discovery
  5. Oracle Cluster Registry Architecture
  6. Voting Files and Cluster Quorum
  7. Clusterware Resource Model
  8. CRS, CSS, EVM and Clusterware Process Architecture
  9. SCAN, VIPs and Cluster Network Identity
  10. Clusterware Resource Dependencies and Placement
  11. CRSCTL Administration Fundamentals
  12. SRVCTL Administration Fundamentals
  13. ASM Architecture and the ASM Instance
  14. ASM Disk Discovery and Disk Provisioning
  15. ASM Disk Groups and Compatibility Attributes
  16. Allocation Units, Extents and ASM Striping
  17. External, Normal and High Redundancy
  18. ASM Failure Groups and Failure Domains
  19. ASM Quorum Failure Groups
  20. ASM File Types and File Naming
  21. ASM Templates and Storage Policies
  22. ASM Rebalancing Fundamentals
  23. ASM Rebalance Power and Performance
  24. Adding, Dropping and Replacing ASM Disks
  25. ASM Preferred Read and Read Locality
  26. ASM Dynamic Performance Views
  27. ASM Metadata and Storage Diagnostics
  28. ASM Filter Driver Concepts
  29. Flex ASM Architecture
  30. Flex ASM Clients and Cardinality
  31. ACFS and ADVM Architecture
  32. Creating and Managing ACFS File Systems
  33. ACFS Snapshots
  34. ACFS Replication and Availability Concepts
  35. ACFS Security and Encryption Concepts
  36. Oracle Restart Resource Administration
  37. Cluster Verification and Preflight Checks
  38. Grid Infrastructure Upgrade Strategy
  39. Grid Infrastructure Patching Concepts
  40. Storage and Cluster Failure Engineering Lab
T06 RMAN, Flashback & Deep Recovery Engineering Ch 201-240 · 40 chapters

Recovery fundamentals, redo and archive lifecycle, RMAN architecture, channels, backup sets, image copies, incremental backups, block change tracking, retention, control-file autobackups, recovery catalogues, encryption, compression, restore, recovery, PITR, tablespace recovery, PDB recovery, duplication, corruption, Flashback and disaster-recovery simulations.

  1. Recovery Engineering: What Must Survive a Failure
  2. Instance Recovery versus Media Recovery
  3. ARCHIVELOG and NOARCHIVELOG Recovery Boundaries
  4. Fast Recovery Area and Recovery Retention
  5. RMAN Architecture, Channels and Server Sessions
  6. RMAN Repository and Control File Metadata
  7. Recovery Catalog Architecture
  8. Backup Sets and Backup Pieces
  9. Image Copies and Copy-Based Recovery
  10. Full Backups versus Incremental Backups
  11. Differential and Cumulative Incrementals
  12. Block Change Tracking
  13. Backing Up Archived Redo Logs
  14. Control File and SPFILE Autobackups
  15. RMAN Retention Policies and Obsolete Backups
  16. Backup Optimization
  17. Backup Compression
  18. Backup Encryption and Keystore Dependencies
  19. Validating Backups and Detecting Corruption
  20. RESTORE versus RECOVER Semantics
  21. Complete Database Media Recovery
  22. Incomplete Recovery and RESETLOGS
  23. Database Point-in-Time Recovery
  24. Tablespace Point-in-Time Recovery
  25. PDB Point-in-Time Recovery
  26. Recovering Individual Tables and Table Partitions
  27. Block Media Recovery
  28. Recovering a Lost Control File
  29. Recovering a Lost SPFILE
  30. Recovery after Online Redo Log Loss
  31. Recovery after Datafile Loss
  32. RMAN Crosscheck, Catalog and Uncatalog Operations
  33. Database Duplication from Backup
  34. Active Database Duplication
  35. Creating Standby Databases with RMAN
  36. Flashback Query and Historical Read
  37. Flashback Table
  38. Flashback Database and Flashback Logs
  39. Guaranteed Restore Points and Rewind Strategy
  40. Enterprise Backup and Recovery Failure Lab
T07 Oracle Performance & SQL Tuning Ch 241-280 · 40 chapters

Performance methodology, instrumentation, time model, wait events, V$ views, AWR, ASH, ADDM, Performance Hub concepts, SGA/PGA tuning, buffer cache, shared pool, parsing, CPU, I/O, concurrency, locks, latches, optimizer architecture, statistics, cardinality, execution plans, access paths, joins, transformations, partition pruning, SQL profiles, SQL patches and SQL plan management.

  1. Performance Engineering Methodology
  2. DB Time and the Oracle Time Model
  3. Oracle Wait Interface Fundamentals
  4. Dynamic Performance Views for Performance Analysis
  5. Automatic Workload Repository Architecture
  6. Active Session History Architecture
  7. Automatic Database Diagnostic Monitor
  8. Database Metrics, Baselines and Thresholds
  9. CPU Saturation and Scheduler Diagnosis
  10. Buffer Cache Behaviour and Logical I/O
  11. Shared Pool, Library Cache and Cursor Management
  12. PGA, Workareas and Temporary Spill
  13. Storage I/O Latency and Throughput Analysis
  14. Concurrency, Enqueues and Blocking Sessions
  15. Latches, Mutexes and Internal Contention
  16. Hard Parsing, Soft Parsing and Cursor Sharing
  17. SQL Processing and the Optimizer Lifecycle
  18. Cost-Based Optimizer Fundamentals
  19. Optimizer Statistics Architecture
  20. Histograms, Skew and Selectivity
  21. Cardinality Estimation and Estimation Errors
  22. Table Access Paths and Full Scans
  23. B-Tree and Bitmap Index Access Paths
  24. Nested Loops, Hash Joins and Sort-Merge Joins
  25. Optimizer Transformations
  26. Partition Pruning and Partition-Wise Operations
  27. Reading Execution Plans Correctly
  28. DBMS_XPLAN and Runtime Plan Statistics
  29. SQL Monitoring and Long-Running SQL
  30. SQL Trace, TKPROF and Instrumentation
  31. SQL Tuning Advisor
  32. SQL Profiles
  33. SQL Plan Baselines
  34. SQL Patches and Targeted Plan Control
  35. Adaptive SQL and Plan Evolution Concepts
  36. Parallel Execution Fundamentals
  37. SQL Performance Analyzer
  38. Database Replay and Workload Validation
  39. Diagnosing a Production Performance Regression
  40. Performance Engineering Capstone
T08 Oracle Security, Governance & Compliance Ch 281-320 · 40 chapters

Authentication, authorization, administrative privileges, privilege analysis, roles, profiles, auditing, Unified Audit, TDE, wallet architecture, Oracle Key Vault concepts, Database Vault, Label Security, VPD, Real Application Security, Data Redaction, SQL Firewall, data masking, sensitive-data discovery, Data Safe and enterprise separation of duties.

  1. Oracle Database Security Architecture
  2. Authentication Models and Administrative Authentication
  3. SYSDBA, SYSOPER, SYSBACKUP and Administrative Privileges
  4. System and Object Privilege Design
  5. Role Design and Least Privilege
  6. Profiles, Password Policies and Account Controls
  7. Proxy Authentication and Enterprise Access Patterns
  8. Network Encryption and TLS for Oracle Net
  9. Transparent Data Encryption Architecture
  10. Software Keystores, Wallets and Master Encryption Keys
  11. Tablespace Encryption
  12. Column Encryption
  13. Key Rotation, Rekeying and Keystore Backup
  14. External Key Management and Oracle Key Vault Integration Concepts
  15. Unified Auditing Architecture
  16. Fine-Grained Auditing
  17. Privilege Analysis
  18. Virtual Private Database and Row-Level Security
  19. Real Application Security Architecture
  20. Application Users, Sessions and Security Classes
  21. Database Vault Architecture
  22. Database Vault Realms
  23. Database Vault Command Rules
  24. Separation of Duties with Database Vault
  25. Oracle Label Security Architecture
  26. Label Policies and Data Classification
  27. Data Redaction Architecture
  28. Redaction Policies and Runtime Behaviour
  29. SQL Firewall Architecture
  30. SQL Firewall Capture, Allow Lists and Enforcement
  31. Data Masking Fundamentals
  32. Data Subsetting for Non-Production Environments
  33. Sensitive Data Discovery and Protection Strategy
  34. Oracle Deep Data Security
  35. Security in Multitenant CDBs and PDBs
  36. Security in RAC and Data Guard
  37. Security for Vector, RAG and AI Workloads
  38. Database Security Monitoring and Incident Response
  39. Enterprise Database Hardening Baseline
  40. Oracle Security Architecture Capstone
T09 RAC, Clusterware & Highly Available Database Engineering Ch 321-360 · 40 chapters

Cluster architecture, Grid Infrastructure, Clusterware, OCR, voting disks, SCAN, VIPs, listeners, RAC instances, services, Cache Fusion, global resource management, GCS, GES, interconnects, workload placement, node failure, instance recovery, services, connection management, application continuity, RAC performance and advanced troubleshooting.

  1. Why Oracle RAC Exists and When Not to Use It
  2. Shared-Everything Database Cluster Architecture
  3. RAC, Grid Infrastructure and Clusterware Boundaries
  4. Planning a RAC Installation
  5. RAC Network Architecture
  6. SCAN, VIP, Local Listener and Remote Listener
  7. RAC Shared Storage and ASM Dependencies
  8. RAC Instance Architecture
  9. RAC-Specific Background Processes
  10. Global Resource Directory
  11. Global Cache Service
  12. Global Enqueue Service
  13. Cache Fusion Fundamentals
  14. Current Block Transfers between Instances
  15. Consistent Read Block Transfers between Instances
  16. Interconnect Architecture and Latency
  17. Redo, Undo and Recovery in RAC
  18. Sequences, Services and Instance Affinity
  19. Starting and Stopping RAC Databases
  20. SRVCTL for RAC Database Administration
  21. RAC Services and Workload Placement
  22. Client-Side and Server-Side Load Balancing
  23. Fast Application Notification
  24. Fast Connection Failover
  25. Application Continuity and Transaction Guard Concepts
  26. Transparent Application Continuity Concepts
  27. Server Pools and Policy-Managed Concepts
  28. PDB Placement and Services in RAC
  29. Oracle RAC One Node
  30. RAC Instance Failure and Cluster Reconfiguration
  31. Instance Recovery after RAC Failure
  32. Global Cache Performance Waits
  33. Diagnosing gc cr and gc current Contention
  34. RAC Workload Design and Hot-Block Avoidance
  35. Rolling Maintenance and Availability
  36. RAC Patching Architecture
  37. Backup and Recovery in RAC
  38. GoldenGate Integration with RAC Concepts
  39. RAC Failure Injection and Troubleshooting
  40. RAC Architecture and Design Review
T10 Data Guard, Disaster Recovery & Maximum Availability Architecture Ch 361-400 · 40 chapters

Standby architecture, physical standby, logical standby, snapshot standby, redo transport, standby redo, apply services, Data Guard protection modes, broker, FSFO, observer, Far Sync, Data Guard for PDBs, switchover, failover, reinstate, rolling maintenance, DR testing, RPO/RTO and Oracle Maximum Availability Architecture.

  1. RPO, RTO and Disaster-Recovery Engineering
  2. Oracle Data Guard Architecture
  3. Physical Standby Database Architecture
  4. Redo Transport Services
  5. Synchronous versus Asynchronous Redo Transport
  6. Standby Redo Logs
  7. Redo Apply and Managed Recovery
  8. Real-Time Apply
  9. Data Guard Protection Modes
  10. Creating a Physical Standby
  11. Primary and Standby Initialization Parameters
  12. Log Archive Destinations and Transport Attributes
  13. Transport Lag versus Apply Lag
  14. Redo Gap Detection and Resolution
  15. Role Management and Database States
  16. Planned Switchover
  17. Unplanned Failover
  18. Reinstating a Former Primary
  19. Data Guard Broker Architecture
  20. DGMGRL Administration
  21. Fast-Start Failover
  22. Observer Architecture and Placement
  23. Far Sync Instances
  24. Snapshot Standby Databases
  25. Logical Standby Concepts and Use Cases
  26. Active Data Guard Read-Only Workloads
  27. Automatic Block Repair Concepts
  28. Backups on a Standby Database
  29. RAC plus Data Guard Architecture
  30. Multitenant and Data Guard
  31. Data Guard for Pluggable Databases Concepts
  32. Data Guard Network Failure Scenarios
  33. Data Guard Performance and Redo Transport Tuning
  34. Monitoring and Alerting for Data Guard
  35. Patching Data Guard with Minimal Downtime
  36. Rolling Upgrade Concepts
  37. Maximum Availability Architecture Principles
  38. Global Data Services with Replicated Databases
  39. Data Guard versus GoldenGate Decision Architecture
  40. Enterprise Site-Failure and DR Exercise
T11 Expert DBA Operations, Enterprise Manager, Patching, Upgrade & Fleet Management Ch 401-440 · 40 chapters

Release Updates, patch strategy, OPatch, OPatchAuto, out-of-place maintenance, gold images, AutoUpgrade, Replay Upgrade concepts, Grid and database upgrades, Fleet Patching and Provisioning, lifecycle automation, configuration drift, fleet standardisation, health checking, ADR, AHF, ORAchk, TFA, incident analysis and expert production runbooks.

  1. Oracle Software Maintenance Lifecycle
  2. Release Updates, Monthly Recommended Patches and One-Off Fixes
  3. Oracle Home Inventory and Software Configuration Baselines
  4. Out-of-Place versus In-Place Patching
  5. DBCA Gold-Image Patch Maintenance for Single Instance
  6. OPatch Fundamentals and Inventory Checks
  7. Patch Prerequisites, Conflict Detection and Rollback
  8. OPatchAuto for RAC
  9. OPatchAuto for Data Guard
  10. Fleet Patching and Provisioning Architecture
  11. FPP Gold Images and Image Management
  12. Provisioning Oracle Homes with FPP
  13. Fleet-Scale Database Patching
  14. Fleet-Scale Grid Infrastructure Patching
  15. Patching Strategy for Large Oracle Estates
  16. Database Upgrade Architecture
  17. COMPATIBLE and Upgrade Boundaries
  18. Pre-Upgrade Assessment and Remediation
  19. AutoUpgrade Architecture
  20. AutoUpgrade Analyze, Fixups and Deploy
  21. Upgrade Recovery, Fallback and Restore-Point Strategy
  22. Upgrading Multitenant Databases
  23. Upgrading RAC Databases
  24. Upgrading Data Guard Configurations
  25. Grid Infrastructure Upgrade Strategy
  26. Post-Upgrade Validation and Performance Regression Testing
  27. SQL Performance Analyzer for Change Validation
  28. Database Replay for Change Validation
  29. Data Pump as a Migration Mechanism
  30. Transportable Tablespaces and Cross-Platform Migration Concepts
  31. Oracle Enterprise Manager 24ai Architecture
  32. Targets, Agents, OMS and Management Repository
  33. Enterprise Manager Database Monitoring
  34. Enterprise Manager Incidents, Events and Notifications
  35. Enterprise Manager Jobs, Groups and Administration
  36. Autonomous Health Framework Architecture
  37. ORAchk and Compliance Health Checks
  38. Trace File Analyzer and Incident Collection
  39. ADRCI, Diagnostic Packaging and Support Evidence
  40. Expert DBA Change, Incident and Fleet Operations Capstone
T12 Exadata, Autonomous AI Database, OCI & Enterprise Deployment Ch 441-480 · 40 chapters

Exadata architecture, database servers, storage servers, Smart Scan concepts, Smart Flash Cache, storage indexes, offload architecture, Exadata performance engineering, Autonomous AI Database, autonomous operations, OCI database services, Exadata Database Service, hybrid architecture, cloud migration, backup, networking, security and operational responsibility models.

  1. Why Exadata Exists
  2. Oracle Exadata Hardware and Software Architecture
  3. Database Servers, Storage Servers and Network Fabric
  4. Exadata Storage Server Software and Cells
  5. Smart Scan and SQL Offload
  6. Storage Indexes
  7. Smart Flash Cache
  8. Exadata Persistent Memory and RDMA Concepts
  9. Hybrid Columnar Compression
  10. Exadata I/O Resource Management
  11. Exadata Smart Software Capabilities
  12. Exadata Database and Storage Metrics
  13. Exadata Workload Consolidation
  14. Exadata MAA and High Availability
  15. Exadata Security Architecture
  16. Exadata Patching and Lifecycle Concepts
  17. Exadata Capacity and Performance Engineering
  18. Exadata Failure Domains and Resilience
  19. Exadata On-Premises versus Cloud Service Architecture
  20. Exadata Architecture Review
  21. Autonomous AI Database Architecture
  22. Autonomous Database Workload Types and Service Levels
  23. Compute, Storage and Auto Scaling
  24. Autonomous Database Networking and Access
  25. Wallets, TLS and Autonomous Connectivity
  26. Users, Roles and Security in Autonomous Database
  27. Loading and Unloading Data in Autonomous Database
  28. DBMS_CLOUD and Object Storage Integration
  29. Autonomous Backup, Restore and Point-in-Time Recovery
  30. Cloning Autonomous Databases
  31. Autonomous Performance Management
  32. Autonomous AI and Vector Capabilities
  33. Autonomous Database Maintenance Model
  34. Oracle Base Database Service Concepts
  35. Exadata Database Service Concepts
  36. Exadata Cloud@Customer Concepts
  37. Hybrid Oracle Database Deployment Patterns
  38. OCI Network, Identity and Database Security Boundaries
  39. On-Premises to OCI Database Migration Architecture
  40. Choosing the Right Oracle Deployment Model
T13 Modern Oracle Application & Data Architecture Ch 481-520 · 40 chapters

JSON, native JSON data, JSON indexing, JSON Relational Duality, GraphQL integration, SQL property graphs, graph queries, spatial data, temporal data, In-Memory concepts, partitioning, materialized views, Transactional Event Queues, Advanced Queuing, Kafka-compatible event patterns, microservices, sagas, lock-free reservations, True Cache, Globally Distributed Database, JavaScript/MLE, ORDS and API-oriented database development.

  1. Oracle Converged Data Architecture
  2. Native JSON Data in Oracle AI Database
  3. SQL/JSON Query and Generation
  4. JSON Data Guide and Schema Flexibility
  5. JSON Search and Indexing
  6. JSON Relational Duality Concepts
  7. Designing JSON Relational Duality Views
  8. Duality, Transactions and Application Consistency
  9. Property Graph Data Model Fundamentals
  10. SQL Property Graph and SQL/PGQ Concepts
  11. Graph Pattern Matching and Relationship Analytics
  12. RDF Graph and Semantic Data Fundamentals
  13. Graph Architecture Decision Patterns
  14. Oracle Spatial Data Types and Geometry
  15. Spatial Indexing and Spatial Query Concepts
  16. Geospatial Application Architecture
  17. Oracle Database In-Memory Architecture
  18. Dual-Format Row Store and Column Store
  19. In-Memory Population and Distribution
  20. In-Memory Query Acceleration
  21. Partitioning Strategy Fundamentals
  22. Range, List and Hash Partitioning
  23. Composite Partitioning
  24. Partition Lifecycle and Online Operations
  25. Materialized Views and Query Rewrite
  26. Parallel Execution for Data Platforms
  27. Transactional Event Queues Architecture
  28. Advanced Queuing Fundamentals
  29. TxEventQ versus Kafka and External Brokers
  30. Transactional Messaging and Database Commit Semantics
  31. Event-Driven Applications with TxEventQ
  32. Oracle Globally Distributed AI Database Architecture
  33. Sharding Keys, Chunks and Data Placement
  34. Replication and Availability in Globally Distributed Databases
  35. Global Data Services and Service Routing
  36. True Cache Architecture and Read Scaling Concepts
  37. JavaScript with Multilingual Engine
  38. Database APIs, ORDS and API-Centric Design Concepts
  39. Telemetry Streaming from Oracle AI Database
  40. Modern Oracle Application Architecture Capstone
T14 Oracle AI Database 26ai: Vector, RAG, ML & Select AI Ch 521-560 · 40 chapters

AI database architecture, embeddings, ONNX models, VECTOR datatype, vector distance, exact search, approximate search, HNSW, quantisation, vector indexes, hybrid retrieval, chunking, pipelines, AI Vector Search, Select AI, NL2SQL, AI profiles, RAG, synthetic data, summarisation, translation, AI agents, private models, private AI services, security, observability and production AI architecture.

  1. What Makes an AI-Native Database
  2. Embeddings and Vector Space Fundamentals
  3. Dense, Sparse and Binary Vector Concepts
  4. VECTOR Data Type Architecture
  5. Vector Distance Metrics
  6. Exact Vector Similarity Search
  7. Approximate Nearest-Neighbour Search
  8. Vector Index Architecture
  9. HNSW Index Fundamentals
  10. IVF Index Fundamentals and Trade-Offs
  11. Vector Index Accuracy, Recall and Latency
  12. Generating Embeddings inside Oracle
  13. ONNX Models and In-Database Inference Concepts
  14. Document Chunking and Chunk Metadata
  15. Vectorizing Enterprise Documents
  16. Metadata Filtering with Vector Search
  17. Hybrid Structured and Semantic Retrieval
  18. Reranking and Retrieval Quality
  19. RAG Architecture Fundamentals
  20. RAG Grounding, Context and Citation Design
  21. Select AI Architecture
  22. AI Profiles and Provider Configuration
  23. Natural Language to SQL with Select AI
  24. Prompt Construction and Schema Grounding
  25. Select AI Conversation and Context
  26. Select AI RAG
  27. Select AI Agents and Tool-Oriented Workflows
  28. Synthetic Data, Summarization and Translation Capabilities
  29. Private AI Services Container Architecture
  30. Private Models and Controlled Enterprise AI
  31. AI Credentials, Privileges and Data Access Security
  32. Prompt Injection and Database AI Threat Modelling
  33. Oracle Machine Learning for SQL Architecture
  34. Supervised Learning: Classification and Regression
  35. Unsupervised Learning: Clustering and Anomaly Detection
  36. Feature Extraction and In-Database Model Scoring
  37. Model Lifecycle, Evaluation and Deployment
  38. Combining Relational, JSON, Graph and Vector Data
  39. Observability and Performance for AI Database Workloads
  40. Enterprise Oracle 26ai AI/RAG Architecture Capstone
T15 Oracle GoldenGate 26ai, CDC & Real-Time Data Engineering Ch 561-600 · 40 chapters

CDC fundamentals, transaction logs, Oracle redo, GoldenGate architecture, Microservices Architecture, deployments, Extract, integrated capture, trails, checkpoints, Distribution Service, Receiver Service, Replicat, Parallel Replicat, initial load, instantiation, heartbeat, lag, recovery, transformations, conflict handling, active-active concepts, heterogeneous replication, PostgreSQL, MySQL and SQL Server integration, Kafka/data-platform integration, vector-data replication and GoldenGate AI capabilities.

  1. Change Data Capture Fundamentals
  2. Log-Based CDC versus Trigger-Based Capture
  3. Transaction Logs, Oracle Redo and Commit Ordering
  4. Oracle GoldenGate 26ai Platform Use Cases
  5. GoldenGate Microservices Architecture
  6. GoldenGate Deployments and Service Boundaries
  7. Source Database Preparation and Supplemental Logging
  8. Extract Process Architecture
  9. Integrated Extract Concepts
  10. Extract Checkpoints and Recovery Position
  11. GoldenGate Trail File Architecture
  12. Trail Record Structure and Transaction Boundaries
  13. Distribution Service and Remote Trail Delivery
  14. Receiver Service Architecture
  15. Initial Load versus Ongoing CDC
  16. Instantiation and Replication Start Points
  17. Replicat Process Architecture
  18. Integrated Replicat Concepts
  19. Parallel Replicat and Apply Parallelism
  20. MAP, TABLE, Filtering and Routing Concepts
  21. Data Transformation in GoldenGate
  22. DDL Replication Concepts
  23. Sequences and Database Object Considerations
  24. Heartbeat Tables and End-to-End Lag
  25. Error Handling, REPERROR and Discard Files
  26. GoldenGate Security, Credentials and Encryption
  27. TLS and Secure Deployment Communication
  28. GoldenGate Monitoring and Operational Metrics
  29. LogDump and Trail-Level Troubleshooting
  30. Checkpoint Recovery and Process Repositioning
  31. Trail Retention, Purging and Disk Management
  32. GoldenGate Performance Engineering
  33. GoldenGate with Oracle RAC
  34. GoldenGate with Data Guard and MAA
  35. Bidirectional Replication and Loop Prevention
  36. Conflict Detection and Resolution Concepts
  37. Heterogeneous Replication Architecture
  38. Zero-Downtime Migration with GoldenGate
  39. GoldenGate Maximum Availability Hub
  40. GoldenGate Architecture, Failure and Troubleshooting Capstone
Legal

Trademarks and independence

Oracle, Oracle Database, Exadata, Autonomous Database and GoldenGate are trademarks of Oracle Corporation. This programme is independently produced and is not affiliated with, endorsed by, or certified by Oracle.

How it is delivered

Three ways to take Oracle AI Database 26ai Platform Master Programme

Self-paced is a document-and-media programme with lifetime access - no live sessions. Cohort and enterprise add live instructor-led training. Mentorship is not offered in any tier.
Feature Self-paced Cohort Enterprise
Format Written chapters, video explainers and podcasts Everything in self-paced, plus scheduled live sessions Everything in cohort, delivered privately to your team
Live sessions None Scheduled, instructor-led Scheduled, instructor-led, private
Mentorship Not offered Not offered Not offered
Access Lifetime Lifetime Lifetime for every enrolled seat
Pace Entirely your own Guided schedule with a peer group Agreed with your desk
Tailoring Fixed curriculum Fixed curriculum Sequenced to your markets, systems and governance
Best for Individuals learning around a job Individuals who want structure and deadlines Desks building the same capability together
For individuals

Get the programme guide

The full chapter list, what each module covers, and how the tiers compare - sent to your inbox as a PDF.

For teams

Run this for my desk

Private delivery for your desk, sequenced to your markets and systems. Tell us the team and we will scope it.

Run this for my desk