Enterprise Academy · Database platform

Oracle AI Database 26ai Platform Master Program

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

68 official Oracle documentation sets · every chapter mapped to a primary Oracle PDF

What it develops

Not how Oracle is used. How Oracle behaves.

The programme starts with database and operating-system fundamentals and progresses through professional DBA, advanced DBA and expert DBA engineering before moving into RAC, Data Guard, Exadata, Autonomous AI Database, Oracle's JSON, graph and event capabilities, AI Vector Search, Select AI and Oracle GoldenGate 26ai.

The objective is to understand not only how Oracle works, but why it behaves as it does when systems are under load, components fail, transactions must recover, databases must remain available and enterprise data must move safely between platforms.

Five levels of mastery

One Oracle platform, taken in order

Level 1

Oracle Foundations & Developer

Build the fundamentals before administration begins.

Learn relational database principles, Oracle architecture, SQL, PL/SQL, transactions, concurrency, data modelling, indexes, execution basics, Linux foundations, networking and the Oracle client/server model.

Understand the difference between an Oracle database, instance, container database, pluggable database, service, listener and Oracle home before operating them.

Documentation set · 14 PDFsURL listfetch script

Level 2

Professional Oracle DBA

Move from using Oracle to operating Oracle.

Learn database installation and creation, instance administration, initialization parameters, control files, redo, undo, tablespaces, datafiles, temp, users, privileges, profiles, services, networking, jobs, diagnostics and day-to-day production DBA operations.

Build deep command of Oracle Multitenant architecture including CDBs, PDBs, cloning, unplug/plug, refreshable PDBs, services, resource management and lifecycle administration.

Documentation set · 12 PDFsURL listfetch script

Level 3

Advanced Oracle DBA

Develop the disciplines required to operate important production databases.

Go deep into:

Oracle Grid Infrastructure and ASM

Documentation set · 23 PDFsURL listfetch script

Level 4

Expert DBA, Availability & Mission-Critical Oracle

This is where the program moves beyond conventional DBA training.

Oracle RAC

Understand cluster architecture before configuration.

Documentation set · 22 PDFsURL listfetch script

Level 5

Oracle AI Database 26ai Platform Engineering

Oracle 26ai is more than the traditional relational database.

The final level brings the complete platform together.

AI Vector Search

Documentation set · 34 PDFsURL listfetch script

Curriculum

15 tracks · 600 chapters

Every track is 40 chapters, and every chapter is anchored to a primary Oracle documentation set so the material can be traced back to the vendor's own reference rather than to secondary summaries.

Each chapter title opens its primary Oracle PDF, and the contents link opens the same manual's HTML table of contents, which is the reliable way to reach the exact section. We do not print page numbers: the mapping is one manual to many chapters rather than one page to one chapter, and Oracle repaginates its PDFs at each documentation refresh, so a printed page number would be wrong within a release or two.

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 WorkloadsDatabase Conceptscontents
  2. Relational Database Principles and the Relational ModelDatabase Conceptscontents
  3. Tables, Rows, Columns, Keys and RelationshipsDatabase Conceptscontents
  4. Integrity Constraints and Data Quality FundamentalsDatabase Conceptscontents
  5. SQL, PL/SQL and Oracle Programming LayersDatabase Conceptscontents
  6. ACID Transaction FundamentalsDatabase Conceptscontents
  7. Isolation, Consistency and ConcurrencyDatabase Conceptscontents
  8. Undo, Redo and Durability Mental ModelDatabase Conceptscontents
  9. Locks, Latches and Database CoordinationDatabase Conceptscontents
  10. Read Consistency and Oracle Multiversion ConcurrencyDatabase Conceptscontents
  11. Oracle AI Database 26ai Platform ArchitectureDatabase Conceptscontents
  12. Oracle Database versus Oracle InstanceDatabase Conceptscontents
  13. Physical versus Logical Database StructuresDatabase Conceptscontents
  14. Data Blocks, Extents and SegmentsDatabase Conceptscontents
  15. Datafiles, Tempfiles and Control FilesDatabase Conceptscontents
  16. Online Redo Logs and Archived RedoDatabase Conceptscontents
  17. System Global Area ArchitectureDatabase Conceptscontents
  18. Program Global Area and Process MemoryDatabase Conceptscontents
  19. Oracle Background ProcessesDatabase Conceptscontents
  20. Server Processes, Sessions and ConnectionsDatabase Conceptscontents
  21. Checkpoints and Instance RecoveryDatabase Conceptscontents
  22. System Change Numbers and Transaction OrderingDatabase Conceptscontents
  23. Schemas, Schema Objects and NamespacesDatabase Conceptscontents
  24. Data Dictionary and Dynamic Performance ViewsDatabase Conceptscontents
  25. Multitenant CDB and PDB Concept PreviewDatabase Conceptscontents
  26. Services, Instances and Connection RoutingDatabase Net Services Administrator's Guidecontents
  27. Oracle Net Listener FundamentalsDatabase Net Services Administrator's Guidecontents
  28. Linux Users, Groups and Process Fundamentals for OracleOracle AI Database Installation Guide for Linuxcontents
  29. Linux Filesystems, Devices and Permissions for OracleOracle AI Database Installation Guide for Linuxcontents
  30. Linux CPU, Memory and I/O Fundamentals for DBAsOracle AI Database Installation Guide for Linuxcontents
  31. Linux Networking and Name Resolution for OracleOracle AI Database Installation Guide for Linuxcontents
  32. ORACLE_BASE, ORACLE_HOME and Environment ArchitectureOracle AI Database Installation Guide for Linuxcontents
  33. Oracle Software Installation ArchitectureOracle AI Database Installation Guide for Linuxcontents
  34. Building a Personal Oracle AI Database Free 26ai LabOracle AI Database Free Installation Guide for Linuxcontents
  35. Oracle Editions, Options and Licensing FundamentalsDatabase Licensing Information User Manualcontents
  36. Oracle 26ai Release Model and Release UpdatesOracle AI Database 26ai New Featurescontents
  37. The Converged Database Platform ConceptOracle AI Database 26ai New Featurescontents
  38. Backup versus High Availability versus Disaster RecoveryHigh Availability Overview and Best Practicescontents
  39. Database Security, Least Privilege and Audit FundamentalsDatabase Security Guidecontents
  40. End-to-End Oracle Platform Mental ModelDatabase Conceptscontents

Primary Oracle documentationDatabase ConceptscontentsDatabase Administrator's GuidecontentsDatabase Net Services Administrator's GuidecontentsOracle AI Database Installation Guide for LinuxcontentsOracle AI Database Free Installation Guide for LinuxcontentsDatabase Licensing Information User ManualcontentsOracle AI Database 26ai New FeaturescontentsHigh Availability Overview and Best PracticescontentsOracle AI Database Backup and Recovery User's GuidecontentsDatabase Security Guidecontents

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 ModelSQL Language Referencecontents
  2. SELECT Fundamentals and ProjectionSQL Language Referencecontents
  3. Filtering, Predicates and Three-Valued LogicSQL Language Referencecontents
  4. Oracle Data Types and Type ConversionSQL Language Referencecontents
  5. NULL Semantics and NULL-Safe DesignSQL Language Referencecontents
  6. Character, Numeric and Date-Time FunctionsSQL Language Referencecontents
  7. CASE Expressions and Conditional SQLSQL Language Referencecontents
  8. Joins and Relational CompositionSQL Language Referencecontents
  9. Outer Joins, Self Joins and Advanced Join SemanticsSQL Language Referencecontents
  10. GROUP BY, Aggregation and HAVINGSQL Language Referencecontents
  11. Scalar and Correlated SubqueriesSQL Language Referencecontents
  12. EXISTS, IN and Semi-Join ThinkingSQL Language Referencecontents
  13. Set Operators and Set-Based DesignSQL Language Referencecontents
  14. INSERT, UPDATE, DELETE and MERGESQL Language Referencecontents
  15. Transaction Control with COMMIT, ROLLBACK and SAVEPOINTSQL Language Referencecontents
  16. DDL, Object Lifecycle and Implicit Commit BehaviourSQL Language Referencecontents
  17. Primary, Unique, Foreign Key and Check ConstraintsSQL Language Referencecontents
  18. Views and Security-Aware AbstractionSQL Language Referencecontents
  19. Sequences, Identity Columns and Key GenerationSQL Language Referencecontents
  20. B-Tree, Bitmap and Function-Based Index ConceptsSQL Language Referencecontents
  21. Partitioned Tables and Partitioned IndexesVLDB and Partitioning Guidecontents
  22. Analytic Functions and Window ProcessingSQL Language Referencecontents
  23. Hierarchical Queries and Recursive SQLSQL Language Referencecontents
  24. Advanced Grouping, PIVOT and UNPIVOTSQL Language Referencecontents
  25. SQL Execution Semantics and Deterministic ResultsSQL Language Referencecontents
  26. PL/SQL Architecture and Anonymous BlocksDatabase PL/SQL Language Referencecontents
  27. Variables, Constants, Records and CollectionsSQL Language Referencecontents
  28. PL/SQL Control StructuresDatabase PL/SQL Language Referencecontents
  29. Explicit and Implicit CursorsDatabase PL/SQL Language Referencecontents
  30. Exception Handling and Error PropagationDatabase PL/SQL Language Referencecontents
  31. Stored Procedures and FunctionsDatabase PL/SQL Language Referencecontents
  32. Packages, Package State and EncapsulationDatabase PL/SQL Language Referencecontents
  33. Triggers and Their Appropriate UseDatabase PL/SQL Language Referencecontents
  34. Dynamic SQL with Native Dynamic SQLDatabase PL/SQL Language Referencecontents
  35. Bulk SQL with BULK COLLECT and FORALLDatabase PL/SQL Language Referencecontents
  36. PL/SQL Transaction Boundaries and Autonomous TransactionsDatabase PL/SQL Language Referencecontents
  37. PL/SQL Performance and Context SwitchingDatabase PL/SQL Language Referencecontents
  38. Secure PL/SQL and Definer versus Invoker RightsDatabase PL/SQL Language Referencecontents
  39. Database Application Design PatternsDatabase Development Guidecontents
  40. SQL and PL/SQL Engineering CapstoneDatabase Development Guidecontents

Primary Oracle documentationSQL Language ReferencecontentsDatabase Development GuidecontentsVLDB and Partitioning GuidecontentsDatabase PL/SQL Language Referencecontents

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 LifecycleDatabase Administrator's Guidecontents
  2. Planning an Oracle AI Database 26ai InstallationOracle AI Database Installation Guide for Linuxcontents
  3. Linux Prerequisites and Preinstallation ValidationOracle AI Database Installation Guide for Linuxcontents
  4. Installing Oracle AI Database SoftwareOracle AI Database Installation Guide for Linuxcontents
  5. Creating Databases with DBCADatabase Administrator's Guidecontents
  6. Understanding Database Creation InternalsDatabase Administrator's Guidecontents
  7. Starting, Mounting, Opening and Shutting Down a DatabaseDatabase Administrator's Guidecontents
  8. PFILE, SPFILE and Initialization Parameter ManagementDatabase Administrator's Guidecontents
  9. Password Files and Administrative AuthenticationDatabase Administrator's Guidecontents
  10. SGA Configuration and Memory ManagementDatabase Administrator's Guidecontents
  11. PGA Configuration and Workarea ManagementDatabase Administrator's Guidecontents
  12. Control File Architecture and MultiplexingDatabase Administrator's Guidecontents
  13. Online Redo Log Architecture and MultiplexingDatabase Administrator's Guidecontents
  14. ARCHIVELOG Mode and Archive Destination ManagementOracle AI Database Backup and Recovery User's Guidecontents
  15. Undo Tablespaces and Automatic Undo ManagementDatabase Administrator's Guidecontents
  16. Temporary Tablespaces and Temporary SegmentsDatabase Administrator's Guidecontents
  17. Permanent Tablespaces and Segment Space ManagementDatabase Administrator's Guidecontents
  18. Datafiles, Autoextend and Oracle Managed FilesDatabase Administrator's Guidecontents
  19. Fast Recovery Area Architecture and ManagementOracle AI Database Backup and Recovery User's Guidecontents
  20. Block Size, Extents and Segment StorageDatabase Administrator's Guidecontents
  21. Users, Schemas and Account AdministrationDatabase Security Guidecontents
  22. System Privileges, Object Privileges and RolesDatabase Security Guidecontents
  23. Profiles, Password Policies and Resource LimitsDatabase Security Guidecontents
  24. Oracle Net Service Naming and Client ConnectivityDatabase Net Services Administrator's Guidecontents
  25. Listener Administration and Dynamic Service RegistrationDatabase Net Services Administrator's Guidecontents
  26. Database Services and Workload-Aware ConnectivityDatabase Net Services Administrator's Guidecontents
  27. Database Links and Distributed Database FundamentalsDatabase Administrator's Guidecontents
  28. Oracle Scheduler Jobs and ProgramsDatabase Administrator's Guidecontents
  29. Database Resource Manager FundamentalsDatabase Administrator's Guidecontents
  30. Alert Log, Trace Files and ADRDatabase Administrator's Guidecontents
  31. ADRCI and Diagnostic Incident PackagingOracle AI Database Utilities Guidecontents
  32. Dynamic Performance Views for Daily DBA WorkDatabase Referencecontents
  33. Data Dictionary Views for Daily DBA WorkDatabase Referencecontents
  34. Data Pump Export ArchitectureOracle AI Database Utilities Guidecontents
  35. Data Pump Import and Metadata MovementOracle AI Database Utilities Guidecontents
  36. SQL*Loader, External Tables and Bulk LoadingOracle AI Database Utilities Guidecontents
  37. Statistics Collection and Routine MaintenanceDatabase Administrator's Guidecontents
  38. Space Monitoring and Capacity ManagementDatabase Administrator's Guidecontents
  39. Daily, Weekly and Monthly DBA RunbooksDatabase Administrator's Guidecontents
  40. Core DBA Production Readiness AssessmentDatabase Administrator's Guidecontents

Primary Oracle documentationDatabase Administrator's GuidecontentsDatabase ReferencecontentsOracle AI Database Installation Guide for LinuxcontentsOracle AI Database Backup and Recovery User's GuidecontentsDatabase Security GuidecontentsDatabase Net Services Administrator's GuidecontentsOracle AI Database Utilities Guidecontents

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 ExistsReal Application Clusters Administration and Deployment Guidecontents
  2. CDB, Root, Seed and PDB ArchitectureMultitenant Administrator's Guidecontents
  3. Container IDs, Namespaces and CON_IDMultitenant Administrator's Guidecontents
  4. Common versus Local Users and RolesMultitenant Administrator's Guidecontents
  5. Common versus Local Objects and MetadataMultitenant Administrator's Guidecontents
  6. Creating a Container DatabaseMultitenant Administrator's Guidecontents
  7. Creating a PDB from the SeedMultitenant Administrator's Guidecontents
  8. Creating a PDB from Another PDBMultitenant Administrator's Guidecontents
  9. Hot Cloning a PDBMultitenant Administrator's Guidecontents
  10. Snapshot Copy PDBsMultitenant Administrator's Guidecontents
  11. Unplugging and Plugging PDBsMultitenant Administrator's Guidecontents
  12. PDB Compatibility and Plug-In ViolationsMultitenant Administrator's Guidecontents
  13. PDB Relocation between CDBsMultitenant Administrator's Guidecontents
  14. Refreshable Clone PDBsMultitenant Administrator's Guidecontents
  15. PDB Services and Connection RoutingMultitenant Administrator's Guidecontents
  16. Opening, Closing and Saving PDB StateMultitenant Administrator's Guidecontents
  17. PDB Storage and Tablespace ManagementMultitenant Administrator's Guidecontents
  18. PDB Resource Management and Resource PlansMultitenant Administrator's Guidecontents
  19. PDB Memory and I/O GovernanceMultitenant Administrator's Guidecontents
  20. Lockdown Profiles and PDB IsolationDatabase Security Guidecontents
  21. TDE and Keystore Considerations in MultitenantDatabase Security Guidecontents
  22. Common Audit Policies and PDB AuditingDatabase Security Guidecontents
  23. Application Containers and Application RootsMultitenant Administrator's Guidecontents
  24. Application PDBs and Application SeedsMultitenant Administrator's Guidecontents
  25. Application Installation and SynchronizationMultitenant Administrator's Guidecontents
  26. PDB Data Pump Export and ImportOracle AI Database Utilities Guidecontents
  27. PDB Backup ArchitectureOracle AI Database Backup and Recovery User's Guidecontents
  28. PDB Restore and RecoveryOracle AI Database Backup and Recovery User's Guidecontents
  29. PDB Point-in-Time RecoveryOracle AI Database Backup and Recovery User's Guidecontents
  30. PDB Flashback and Restore PointsOracle AI Database Backup and Recovery User's Guidecontents
  31. PDB Cloning for Dev/TestMultitenant Administrator's Guidecontents
  32. PDB Lifecycle AutomationMultitenant Administrator's Guidecontents
  33. PDB Upgrade and Compatibility ManagementOracle AI Database Upgrade Guidecontents
  34. PDB Patching and Fleet Maintenance ConceptsDatabase Patch Maintenance Guidelinescontents
  35. PDBs in Oracle RACReal Application Clusters Administration and Deployment Guidecontents
  36. PDBs with Oracle Data GuardData Guard Concepts and Administrationcontents
  37. Consolidation Density and Noisy-Neighbour ControlMultitenant Administrator's Guidecontents
  38. Multitenant Security Boundaries and GovernanceDatabase Security Guidecontents
  39. Multitenant Troubleshooting and Failure ScenariosMultitenant Administrator's Guidecontents
  40. Enterprise Multitenant Consolidation ArchitectureMultitenant Administrator's Guidecontents

Primary Oracle documentationReal Application Clusters Administration and Deployment GuidecontentsMultitenant Administrator's GuidecontentsDatabase Administrator's GuidecontentsDatabase Security GuidecontentsOracle AI Database Utilities GuidecontentsOracle AI Database Backup and Recovery User's GuidecontentsOracle AI Database Upgrade GuidecontentsDatabase Patch Maintenance GuidelinescontentsData Guard Concepts and Administrationcontents

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 ArchitectureClusterware Administration and Deployment Guidecontents
  2. Oracle Restart versus Clustered Grid InfrastructureDatabase Administrator's Guidecontents
  3. Grid Infrastructure Installation PlanningGrid Infrastructure Installation and Upgrade Guide for Linuxcontents
  4. Cluster Nodes, Cluster Membership and DiscoveryClusterware Administration and Deployment Guidecontents
  5. Oracle Cluster Registry ArchitectureClusterware Administration and Deployment Guidecontents
  6. Voting Files and Cluster QuorumClusterware Administration and Deployment Guidecontents
  7. Clusterware Resource ModelClusterware Administration and Deployment Guidecontents
  8. CRS, CSS, EVM and Clusterware Process ArchitectureClusterware Administration and Deployment Guidecontents
  9. SCAN, VIPs and Cluster Network IdentityClusterware Administration and Deployment Guidecontents
  10. Clusterware Resource Dependencies and PlacementClusterware Administration and Deployment Guidecontents
  11. CRSCTL Administration FundamentalsClusterware Administration and Deployment Guidecontents
  12. SRVCTL Administration FundamentalsClusterware Administration and Deployment Guidecontents
  13. ASM Architecture and the ASM InstanceAutomatic Storage Management Administrator's Guidecontents
  14. ASM Disk Discovery and Disk ProvisioningAutomatic Storage Management Administrator's Guidecontents
  15. ASM Disk Groups and Compatibility AttributesAutomatic Storage Management Administrator's Guidecontents
  16. Allocation Units, Extents and ASM StripingAutomatic Storage Management Administrator's Guidecontents
  17. External, Normal and High RedundancyAutomatic Storage Management Administrator's Guidecontents
  18. ASM Failure Groups and Failure DomainsAutomatic Storage Management Administrator's Guidecontents
  19. ASM Quorum Failure GroupsAutomatic Storage Management Administrator's Guidecontents
  20. ASM File Types and File NamingAutomatic Storage Management Administrator's Guidecontents
  21. ASM Templates and Storage PoliciesAutomatic Storage Management Administrator's Guidecontents
  22. ASM Rebalancing FundamentalsAutomatic Storage Management Administrator's Guidecontents
  23. ASM Rebalance Power and PerformanceAutomatic Storage Management Administrator's Guidecontents
  24. Adding, Dropping and Replacing ASM DisksAutomatic Storage Management Administrator's Guidecontents
  25. ASM Preferred Read and Read LocalityAutomatic Storage Management Administrator's Guidecontents
  26. ASM Dynamic Performance ViewsAutomatic Storage Management Administrator's Guidecontents
  27. ASM Metadata and Storage DiagnosticsAutomatic Storage Management Administrator's Guidecontents
  28. ASM Filter Driver ConceptsAutomatic Storage Management Administrator's Guidecontents
  29. Flex ASM ArchitectureAutomatic Storage Management Administrator's Guidecontents
  30. Flex ASM Clients and CardinalityAutomatic Storage Management Administrator's Guidecontents
  31. ACFS and ADVM ArchitectureAdvanced Cluster File System Administrator's Guidecontents
  32. Creating and Managing ACFS File SystemsAdvanced Cluster File System Administrator's Guidecontents
  33. ACFS SnapshotsAdvanced Cluster File System Administrator's Guidecontents
  34. ACFS Replication and Availability ConceptsAdvanced Cluster File System Administrator's Guidecontents
  35. ACFS Security and Encryption ConceptsAdvanced Cluster File System Administrator's Guidecontents
  36. Oracle Restart Resource AdministrationDatabase Administrator's Guidecontents
  37. Cluster Verification and Preflight ChecksClusterware Administration and Deployment Guidecontents
  38. Grid Infrastructure Upgrade StrategyGrid Infrastructure Installation and Upgrade Guide for Linuxcontents
  39. Grid Infrastructure Patching ConceptsDatabase Patch Maintenance Guidelinescontents
  40. Storage and Cluster Failure Engineering LabAutomatic Storage Management Administrator's Guidecontents

Primary Oracle documentationClusterware Administration and Deployment GuidecontentsGrid Infrastructure Installation and Upgrade Guide for LinuxcontentsDatabase Administrator's GuidecontentsAutomatic Storage Management Administrator's GuidecontentsAdvanced Cluster File System Administrator's GuidecontentsDatabase Patch Maintenance Guidelinescontents

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 FailureOracle AI Database Backup and Recovery User's Guidecontents
  2. Instance Recovery versus Media RecoveryOracle AI Database Backup and Recovery User's Guidecontents
  3. ARCHIVELOG and NOARCHIVELOG Recovery BoundariesOracle AI Database Backup and Recovery User's Guidecontents
  4. Fast Recovery Area and Recovery RetentionOracle AI Database Backup and Recovery User's Guidecontents
  5. RMAN Architecture, Channels and Server SessionsOracle AI Database Backup and Recovery Referencecontents
  6. RMAN Repository and Control File MetadataOracle AI Database Backup and Recovery Referencecontents
  7. Recovery Catalog ArchitectureOracle AI Database Backup and Recovery Referencecontents
  8. Backup Sets and Backup PiecesOracle AI Database Backup and Recovery User's Guidecontents
  9. Image Copies and Copy-Based RecoveryOracle AI Database Backup and Recovery User's Guidecontents
  10. Full Backups versus Incremental BackupsOracle AI Database Backup and Recovery User's Guidecontents
  11. Differential and Cumulative IncrementalsOracle AI Database Backup and Recovery User's Guidecontents
  12. Block Change TrackingOracle AI Database Backup and Recovery User's Guidecontents
  13. Backing Up Archived Redo LogsOracle AI Database Backup and Recovery User's Guidecontents
  14. Control File and SPFILE AutobackupsOracle AI Database Backup and Recovery User's Guidecontents
  15. RMAN Retention Policies and Obsolete BackupsOracle AI Database Backup and Recovery User's Guidecontents
  16. Backup OptimizationOracle AI Database Backup and Recovery User's Guidecontents
  17. Backup CompressionOracle AI Database Backup and Recovery User's Guidecontents
  18. Backup Encryption and Keystore DependenciesOracle AI Database Backup and Recovery User's Guidecontents
  19. Validating Backups and Detecting CorruptionOracle AI Database Backup and Recovery User's Guidecontents
  20. RESTORE versus RECOVER SemanticsOracle AI Database Backup and Recovery User's Guidecontents
  21. Complete Database Media RecoveryOracle AI Database Backup and Recovery User's Guidecontents
  22. Incomplete Recovery and RESETLOGSOracle AI Database Backup and Recovery User's Guidecontents
  23. Database Point-in-Time RecoveryOracle AI Database Backup and Recovery User's Guidecontents
  24. Tablespace Point-in-Time RecoveryOracle AI Database Backup and Recovery User's Guidecontents
  25. PDB Point-in-Time RecoveryOracle AI Database Backup and Recovery User's Guidecontents
  26. Recovering Individual Tables and Table PartitionsOracle AI Database Backup and Recovery User's Guidecontents
  27. Block Media RecoveryOracle AI Database Backup and Recovery User's Guidecontents
  28. Recovering a Lost Control FileOracle AI Database Backup and Recovery User's Guidecontents
  29. Recovering a Lost SPFILEOracle AI Database Backup and Recovery User's Guidecontents
  30. Recovery after Online Redo Log LossOracle AI Database Backup and Recovery User's Guidecontents
  31. Recovery after Datafile LossOracle AI Database Backup and Recovery User's Guidecontents
  32. RMAN Crosscheck, Catalog and Uncatalog OperationsOracle AI Database Backup and Recovery Referencecontents
  33. Database Duplication from BackupOracle AI Database Backup and Recovery User's Guidecontents
  34. Active Database DuplicationOracle AI Database Backup and Recovery User's Guidecontents
  35. Creating Standby Databases with RMANOracle AI Database Backup and Recovery User's Guidecontents
  36. Flashback Query and Historical ReadOracle AI Database Backup and Recovery User's Guidecontents
  37. Flashback TableOracle AI Database Backup and Recovery User's Guidecontents
  38. Flashback Database and Flashback LogsOracle AI Database Backup and Recovery User's Guidecontents
  39. Guaranteed Restore Points and Rewind StrategyOracle AI Database Backup and Recovery User's Guidecontents
  40. Enterprise Backup and Recovery Failure LabOracle AI Database Backup and Recovery User's Guidecontents

Primary Oracle documentationOracle AI Database Backup and Recovery User's GuidecontentsOracle AI Database Backup and Recovery ReferencecontentsDatabase Administrator's Guidecontents

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 MethodologyDatabase Performance Tuning Guidecontents
  2. DB Time and the Oracle Time ModelDatabase Performance Tuning Guidecontents
  3. Oracle Wait Interface FundamentalsDatabase Performance Tuning Guidecontents
  4. Dynamic Performance Views for Performance AnalysisDatabase Referencecontents
  5. Automatic Workload Repository ArchitectureDatabase Performance Tuning Guidecontents
  6. Active Session History ArchitectureDatabase Performance Tuning Guidecontents
  7. Automatic Database Diagnostic MonitorDatabase Performance Tuning Guidecontents
  8. Database Metrics, Baselines and ThresholdsDatabase Performance Tuning Guidecontents
  9. CPU Saturation and Scheduler DiagnosisDatabase Performance Tuning Guidecontents
  10. Buffer Cache Behaviour and Logical I/ODatabase Performance Tuning Guidecontents
  11. Shared Pool, Library Cache and Cursor ManagementDatabase Performance Tuning Guidecontents
  12. PGA, Workareas and Temporary SpillDatabase Performance Tuning Guidecontents
  13. Storage I/O Latency and Throughput AnalysisDatabase Performance Tuning Guidecontents
  14. Concurrency, Enqueues and Blocking SessionsDatabase Performance Tuning Guidecontents
  15. Latches, Mutexes and Internal ContentionDatabase Performance Tuning Guidecontents
  16. Hard Parsing, Soft Parsing and Cursor SharingDatabase Performance Tuning Guidecontents
  17. SQL Processing and the Optimizer LifecycleSQL Tuning Guidecontents
  18. Cost-Based Optimizer FundamentalsSQL Tuning Guidecontents
  19. Optimizer Statistics ArchitectureSQL Tuning Guidecontents
  20. Histograms, Skew and SelectivitySQL Tuning Guidecontents
  21. Cardinality Estimation and Estimation ErrorsSQL Tuning Guidecontents
  22. Table Access Paths and Full ScansSQL Tuning Guidecontents
  23. B-Tree and Bitmap Index Access PathsSQL Tuning Guidecontents
  24. Nested Loops, Hash Joins and Sort-Merge JoinsSQL Tuning Guidecontents
  25. Optimizer TransformationsSQL Tuning Guidecontents
  26. Partition Pruning and Partition-Wise OperationsSQL Tuning Guidecontents
  27. Reading Execution Plans CorrectlySQL Tuning Guidecontents
  28. DBMS_XPLAN and Runtime Plan StatisticsSQL Tuning Guidecontents
  29. SQL Monitoring and Long-Running SQLDatabase Performance Tuning Guidecontents
  30. SQL Trace, TKPROF and InstrumentationDatabase Performance Tuning Guidecontents
  31. SQL Tuning AdvisorSQL Tuning Guidecontents
  32. SQL ProfilesSQL Tuning Guidecontents
  33. SQL Plan BaselinesSQL Tuning Guidecontents
  34. SQL Patches and Targeted Plan ControlSQL Tuning Guidecontents
  35. Adaptive SQL and Plan Evolution ConceptsSQL Tuning Guidecontents
  36. Parallel Execution FundamentalsDatabase Performance Tuning Guidecontents
  37. SQL Performance AnalyzerReal Application Testing Guidecontents
  38. Database Replay and Workload ValidationReal Application Testing Guidecontents
  39. Diagnosing a Production Performance RegressionDatabase Performance Tuning Guidecontents
  40. Performance Engineering CapstoneDatabase Performance Tuning Guidecontents

Primary Oracle documentationDatabase Performance Tuning GuidecontentsSQL Tuning GuidecontentsDatabase ReferencecontentsReal Application Testing Guidecontents

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 ArchitectureDatabase Security Guidecontents
  2. Authentication Models and Administrative AuthenticationDatabase Security Guidecontents
  3. SYSDBA, SYSOPER, SYSBACKUP and Administrative PrivilegesDatabase Security Guidecontents
  4. System and Object Privilege DesignDatabase Security Guidecontents
  5. Role Design and Least PrivilegeDatabase Security Guidecontents
  6. Profiles, Password Policies and Account ControlsDatabase Security Guidecontents
  7. Proxy Authentication and Enterprise Access PatternsDatabase Security Guidecontents
  8. Network Encryption and TLS for Oracle NetDatabase Security Guidecontents
  9. Transparent Data Encryption ArchitectureTransparent Data Encryptioncontents
  10. Software Keystores, Wallets and Master Encryption KeysTransparent Data Encryptioncontents
  11. Tablespace EncryptionTransparent Data Encryptioncontents
  12. Column EncryptionTransparent Data Encryptioncontents
  13. Key Rotation, Rekeying and Keystore BackupTransparent Data Encryptioncontents
  14. External Key Management and Oracle Key Vault Integration ConceptsTransparent Data Encryptioncontents
  15. Unified Auditing ArchitectureDatabase Security Guidecontents
  16. Fine-Grained AuditingDatabase Security Guidecontents
  17. Privilege AnalysisDatabase Security Guidecontents
  18. Virtual Private Database and Row-Level SecurityDatabase Security Guidecontents
  19. Real Application Security ArchitectureReal Application Security Administrator's and Developer's Guidecontents
  20. Application Users, Sessions and Security ClassesReal Application Security Administrator's and Developer's Guidecontents
  21. Database Vault ArchitectureDatabase Vault Administrator's Guidecontents
  22. Database Vault RealmsDatabase Vault Administrator's Guidecontents
  23. Database Vault Command RulesDatabase Vault Administrator's Guidecontents
  24. Separation of Duties with Database VaultDatabase Vault Administrator's Guidecontents
  25. Oracle Label Security ArchitectureLabel Security Administrator's Guidecontents
  26. Label Policies and Data ClassificationLabel Security Administrator's Guidecontents
  27. Data Redaction ArchitectureData Redactioncontents
  28. Redaction Policies and Runtime BehaviourData Redactioncontents
  29. SQL Firewall ArchitectureOracle Database SQL Firewall User's Guidecontents
  30. SQL Firewall Capture, Allow Lists and EnforcementOracle Database SQL Firewall User's Guidecontents
  31. Data Masking FundamentalsOracle Data Masking and Subsetting User's Guidecontents
  32. Data Subsetting for Non-Production EnvironmentsOracle Data Masking and Subsetting User's Guidecontents
  33. Sensitive Data Discovery and Protection StrategyDatabase Security Guidecontents
  34. Oracle Deep Data SecurityOracle Deep Data Security Guidecontents
  35. Security in Multitenant CDBs and PDBsDatabase Security Guidecontents
  36. Security in RAC and Data GuardDatabase Security Guidecontents
  37. Security for Vector, RAG and AI WorkloadsAI Enablement Guidecontents
  38. Database Security Monitoring and Incident ResponseDatabase Security Guidecontents
  39. Enterprise Database Hardening BaselineDatabase Security Guidecontents
  40. Oracle Security Architecture CapstoneDatabase Security Guidecontents

Primary Oracle documentationDatabase Security GuidecontentsDatabase Licensing Information User ManualcontentsTransparent Data EncryptioncontentsReal Application Security Administrator's and Developer's GuidecontentsDatabase Vault Administrator's GuidecontentsLabel Security Administrator's GuidecontentsData RedactioncontentsOracle Database SQL Firewall User's GuidecontentsOracle Data Masking and Subsetting User's GuidecontentsOracle Deep Data Security GuidecontentsAI Enablement Guidecontents

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 ItReal Application Clusters Administration and Deployment Guidecontents
  2. Shared-Everything Database Cluster ArchitectureReal Application Clusters Administration and Deployment Guidecontents
  3. RAC, Grid Infrastructure and Clusterware BoundariesClusterware Administration and Deployment Guidecontents
  4. Planning a RAC InstallationReal Application Clusters Installation Guide for Linux and UNIXcontents
  5. RAC Network ArchitectureReal Application Clusters Administration and Deployment Guidecontents
  6. SCAN, VIP, Local Listener and Remote ListenerClusterware Administration and Deployment Guidecontents
  7. RAC Shared Storage and ASM DependenciesAutomatic Storage Management Administrator's Guidecontents
  8. RAC Instance ArchitectureReal Application Clusters Administration and Deployment Guidecontents
  9. RAC-Specific Background ProcessesReal Application Clusters Administration and Deployment Guidecontents
  10. Global Resource DirectoryReal Application Clusters Administration and Deployment Guidecontents
  11. Global Cache ServiceReal Application Clusters Administration and Deployment Guidecontents
  12. Global Enqueue ServiceReal Application Clusters Administration and Deployment Guidecontents
  13. Cache Fusion FundamentalsReal Application Clusters Administration and Deployment Guidecontents
  14. Current Block Transfers between InstancesReal Application Clusters Administration and Deployment Guidecontents
  15. Consistent Read Block Transfers between InstancesReal Application Clusters Administration and Deployment Guidecontents
  16. Interconnect Architecture and LatencyReal Application Clusters Administration and Deployment Guidecontents
  17. Redo, Undo and Recovery in RACReal Application Clusters Administration and Deployment Guidecontents
  18. Sequences, Services and Instance AffinityReal Application Clusters Administration and Deployment Guidecontents
  19. Starting and Stopping RAC DatabasesReal Application Clusters Administration and Deployment Guidecontents
  20. SRVCTL for RAC Database AdministrationClusterware Administration and Deployment Guidecontents
  21. RAC Services and Workload PlacementReal Application Clusters Administration and Deployment Guidecontents
  22. Client-Side and Server-Side Load BalancingReal Application Clusters Administration and Deployment Guidecontents
  23. Fast Application NotificationReal Application Clusters Administration and Deployment Guidecontents
  24. Fast Connection FailoverReal Application Clusters Administration and Deployment Guidecontents
  25. Application Continuity and Transaction Guard ConceptsHigh Availability Overview and Best Practicescontents
  26. Transparent Application Continuity ConceptsHigh Availability Overview and Best Practicescontents
  27. Server Pools and Policy-Managed ConceptsReal Application Clusters Administration and Deployment Guidecontents
  28. PDB Placement and Services in RACReal Application Clusters Administration and Deployment Guidecontents
  29. Oracle RAC One NodeReal Application Clusters Administration and Deployment Guidecontents
  30. RAC Instance Failure and Cluster ReconfigurationReal Application Clusters Administration and Deployment Guidecontents
  31. Instance Recovery after RAC FailureReal Application Clusters Administration and Deployment Guidecontents
  32. Global Cache Performance WaitsReal Application Clusters Administration and Deployment Guidecontents
  33. Diagnosing gc cr and gc current ContentionReal Application Clusters Administration and Deployment Guidecontents
  34. RAC Workload Design and Hot-Block AvoidanceReal Application Clusters Administration and Deployment Guidecontents
  35. Rolling Maintenance and AvailabilityOPatchAuto RACcontents
  36. RAC Patching ArchitectureOPatchAuto RACcontents
  37. Backup and Recovery in RACOracle AI Database Backup and Recovery User's Guidecontents
  38. GoldenGate Integration with RAC ConceptsReference for Oracle GoldenGatecontents
  39. RAC Failure Injection and TroubleshootingReal Application Clusters Administration and Deployment Guidecontents
  40. RAC Architecture and Design ReviewReal Application Clusters Administration and Deployment Guidecontents

Primary Oracle documentationReal Application Clusters Administration and Deployment GuidecontentsClusterware Administration and Deployment GuidecontentsReal Application Clusters Installation Guide for Linux and UNIXcontentsGrid Infrastructure Installation and Upgrade Guide for LinuxcontentsAutomatic Storage Management Administrator's GuidecontentsHigh Availability Overview and Best PracticescontentsOPatchAuto RACcontentsOracle AI Database Backup and Recovery User's GuidecontentsReference for Oracle GoldenGatecontents

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 EngineeringHigh Availability Overview and Best Practicescontents
  2. Oracle Data Guard ArchitectureData Guard Concepts and Administrationcontents
  3. Physical Standby Database ArchitectureData Guard Concepts and Administrationcontents
  4. Redo Transport ServicesData Guard Concepts and Administrationcontents
  5. Synchronous versus Asynchronous Redo TransportData Guard Concepts and Administrationcontents
  6. Standby Redo LogsData Guard Concepts and Administrationcontents
  7. Redo Apply and Managed RecoveryData Guard Concepts and Administrationcontents
  8. Real-Time ApplyData Guard Concepts and Administrationcontents
  9. Data Guard Protection ModesData Guard Concepts and Administrationcontents
  10. Creating a Physical StandbyData Guard Concepts and Administrationcontents
  11. Primary and Standby Initialization ParametersData Guard Concepts and Administrationcontents
  12. Log Archive Destinations and Transport AttributesData Guard Concepts and Administrationcontents
  13. Transport Lag versus Apply LagData Guard Concepts and Administrationcontents
  14. Redo Gap Detection and ResolutionData Guard Concepts and Administrationcontents
  15. Role Management and Database StatesData Guard Concepts and Administrationcontents
  16. Planned SwitchoverData Guard Concepts and Administrationcontents
  17. Unplanned FailoverData Guard Concepts and Administrationcontents
  18. Reinstating a Former PrimaryData Guard Concepts and Administrationcontents
  19. Data Guard Broker ArchitectureData Guard Brokercontents
  20. DGMGRL AdministrationData Guard Brokercontents
  21. Fast-Start FailoverData Guard Brokercontents
  22. Observer Architecture and PlacementData Guard Brokercontents
  23. Far Sync InstancesData Guard Concepts and Administrationcontents
  24. Snapshot Standby DatabasesData Guard Concepts and Administrationcontents
  25. Logical Standby Concepts and Use CasesData Guard Concepts and Administrationcontents
  26. Active Data Guard Read-Only WorkloadsData Guard Concepts and Administrationcontents
  27. Automatic Block Repair ConceptsData Guard Concepts and Administrationcontents
  28. Backups on a Standby DatabaseOracle AI Database Backup and Recovery User's Guidecontents
  29. RAC plus Data Guard ArchitectureReal Application Clusters Administration and Deployment Guidecontents
  30. Multitenant and Data GuardData Guard Concepts and Administrationcontents
  31. Data Guard for Pluggable Databases ConceptsData Guard Concepts and Administrationcontents
  32. Data Guard Network Failure ScenariosData Guard Concepts and Administrationcontents
  33. Data Guard Performance and Redo Transport TuningData Guard Concepts and Administrationcontents
  34. Monitoring and Alerting for Data GuardData Guard Concepts and Administrationcontents
  35. Patching Data Guard with Minimal DowntimeOPatchAuto Oracle Data Guardcontents
  36. Rolling Upgrade ConceptsData Guard Concepts and Administrationcontents
  37. Maximum Availability Architecture PrinciplesHigh Availability Overview and Best Practicescontents
  38. Global Data Services with Replicated DatabasesGlobal Data Services Concepts and Administration Guidecontents
  39. Data Guard versus GoldenGate Decision ArchitectureReference for Oracle GoldenGatecontents
  40. Enterprise Site-Failure and DR ExerciseData Guard Concepts and Administrationcontents

Primary Oracle documentationHigh Availability Overview and Best PracticescontentsData Guard Concepts and AdministrationcontentsData Guard BrokercontentsOracle AI Database Backup and Recovery User's GuidecontentsReal Application Clusters Administration and Deployment GuidecontentsOPatchAuto Oracle Data GuardcontentsGlobal Data Services Concepts and Administration GuidecontentsReference for Oracle GoldenGatecontents

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 LifecycleDatabase Patch Maintenance Guidelinescontents
  2. Release Updates, Monthly Recommended Patches and One-Off FixesDatabase Patch Maintenance Guidelinescontents
  3. Oracle Home Inventory and Software Configuration BaselinesDatabase Patch Maintenance Guidelinescontents
  4. Out-of-Place versus In-Place PatchingDatabase Patch Maintenance Guidelinescontents
  5. DBCA Gold-Image Patch Maintenance for Single InstanceOracle AI Database Patch Maintenance Using Database Configuration Assistantcontents
  6. OPatch Fundamentals and Inventory ChecksOPatch SIcontents
  7. Patch Prerequisites, Conflict Detection and RollbackDatabase Patch Maintenance Guidelinescontents
  8. OPatchAuto for RACOPatchAuto RACcontents
  9. OPatchAuto for Data GuardOPatchAuto Oracle Data Guardcontents
  10. Fleet Patching and Provisioning ArchitectureFleet Patching and Provisioning Administrator's Guidecontents
  11. FPP Gold Images and Image ManagementFleet Patching and Provisioning Administrator's Guidecontents
  12. Provisioning Oracle Homes with FPPFleet Patching and Provisioning Administrator's Guidecontents
  13. Fleet-Scale Database PatchingFleet Patching and Provisioning Administrator's Guidecontents
  14. Fleet-Scale Grid Infrastructure PatchingFleet Patching and Provisioning Administrator's Guidecontents
  15. Patching Strategy for Large Oracle EstatesDatabase Patch Maintenance Guidelinescontents
  16. Database Upgrade ArchitectureOracle AI Database Upgrade Guidecontents
  17. COMPATIBLE and Upgrade BoundariesOracle AI Database Upgrade Guidecontents
  18. Pre-Upgrade Assessment and RemediationOracle AI Database Upgrade Guidecontents
  19. AutoUpgrade ArchitectureOracle AI Database Upgrade Guidecontents
  20. AutoUpgrade Analyze, Fixups and DeployOracle AI Database Upgrade Guidecontents
  21. Upgrade Recovery, Fallback and Restore-Point StrategyOracle AI Database Upgrade Guidecontents
  22. Upgrading Multitenant DatabasesDatabase Patch Maintenance Guidelinescontents
  23. Upgrading RAC DatabasesDatabase Patch Maintenance Guidelinescontents
  24. Upgrading Data Guard ConfigurationsDatabase Patch Maintenance Guidelinescontents
  25. Grid Infrastructure Upgrade StrategyOracle AI Database Upgrade Guidecontents
  26. Post-Upgrade Validation and Performance Regression TestingOracle AI Database Upgrade Guidecontents
  27. SQL Performance Analyzer for Change ValidationReal Application Testing Guidecontents
  28. Database Replay for Change ValidationReal Application Testing Guidecontents
  29. Data Pump as a Migration MechanismOracle AI Database Utilities Guidecontents
  30. Transportable Tablespaces and Cross-Platform Migration ConceptsOracle AI Database Utilities Guidecontents
  31. Oracle Enterprise Manager 24ai ArchitectureEnterprise Manager Administrator's Guidecontents
  32. Targets, Agents, OMS and Management RepositoryEnterprise Manager Administrator's Guidecontents
  33. Enterprise Manager Database MonitoringEnterprise Manager Administrator's Guidecontents
  34. Enterprise Manager Incidents, Events and NotificationsEnterprise Manager Administrator's Guidecontents
  35. Enterprise Manager Jobs, Groups and AdministrationEnterprise Manager Administrator's Guidecontents
  36. Autonomous Health Framework ArchitectureAutonomous Health Framework User's Guidecontents
  37. ORAchk and Compliance Health ChecksAutonomous Health Framework User's Guidecontents
  38. Trace File Analyzer and Incident CollectionAutonomous Health Framework User's Guidecontents
  39. ADRCI, Diagnostic Packaging and Support EvidenceOracle AI Database Utilities Guidecontents
  40. Expert DBA Change, Incident and Fleet Operations CapstoneFleet Patching and Provisioning Administrator's Guidecontents

Primary Oracle documentationDatabase Patch Maintenance GuidelinescontentsFleet Patching and Provisioning Administrator's GuidecontentsOracle AI Database Patch Maintenance Using Database Configuration AssistantcontentsOPatch SIcontentsOPatchAuto RACcontentsOPatchAuto Oracle Data GuardcontentsOracle AI Database Upgrade GuidecontentsReal Application Testing GuidecontentsOracle AI Database Utilities GuidecontentsEnterprise Manager Administrator's GuidecontentsAutonomous Health Framework User's Guidecontents

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 ExistsOracle Exadata System Overviewcontents
  2. Oracle Exadata Hardware and Software ArchitectureOracle Exadata System Overviewcontents
  3. Database Servers, Storage Servers and Network FabricUsing Oracle Autonomous AI Database Serverlesscontents
  4. Exadata Storage Server Software and CellsOracle Exadata System Overviewcontents
  5. Smart Scan and SQL OffloadUsing Oracle Autonomous AI Database Serverlesscontents
  6. Storage IndexesUsing Oracle Autonomous AI Database Serverlesscontents
  7. Smart Flash CacheUsing Oracle Autonomous AI Database Serverlesscontents
  8. Exadata Persistent Memory and RDMA ConceptsOracle Exadata System Software User's Guidecontents
  9. Hybrid Columnar CompressionUsing Oracle Autonomous AI Database Serverlesscontents
  10. Exadata I/O Resource ManagementOracle Exadata System Software User's Guidecontents
  11. Exadata Smart Software CapabilitiesOracle Exadata System Software User's Guidecontents
  12. Exadata Database and Storage MetricsOracle Exadata System Software User's Guidecontents
  13. Exadata Workload ConsolidationOracle Exadata System Overviewcontents
  14. Exadata MAA and High AvailabilityOracle Exadata System Overviewcontents
  15. Exadata Security ArchitectureOracle Exadata Security Guidecontents
  16. Exadata Patching and Lifecycle ConceptsOracle Exadata System Overviewcontents
  17. Exadata Capacity and Performance EngineeringOracle Exadata System Software User's Guidecontents
  18. Exadata Failure Domains and ResilienceOracle Exadata System Overviewcontents
  19. Exadata On-Premises versus Cloud Service ArchitectureOracle Exadata System Overviewcontents
  20. Exadata Architecture ReviewOracle Exadata System Overviewcontents
  21. Autonomous AI Database ArchitectureUsing Oracle Autonomous AI Database Serverlesscontents
  22. Autonomous Database Workload Types and Service LevelsUsing Oracle Autonomous AI Database Serverlesscontents
  23. Compute, Storage and Auto ScalingUsing Oracle Autonomous AI Database Serverlesscontents
  24. Autonomous Database Networking and AccessUsing Oracle Autonomous AI Database Serverlesscontents
  25. Wallets, TLS and Autonomous ConnectivityUsing Oracle Autonomous AI Database Serverlesscontents
  26. Users, Roles and Security in Autonomous DatabaseUsing Oracle Autonomous AI Database Serverlesscontents
  27. Loading and Unloading Data in Autonomous DatabaseUsing Oracle Autonomous AI Database Serverlesscontents
  28. DBMS_CLOUD and Object Storage IntegrationUsing Oracle Autonomous AI Database Serverlesscontents
  29. Autonomous Backup, Restore and Point-in-Time RecoveryUsing Oracle Autonomous AI Database Serverlesscontents
  30. Cloning Autonomous DatabasesUsing Oracle Autonomous AI Database Serverlesscontents
  31. Autonomous Performance ManagementUsing Oracle Autonomous AI Database Serverlesscontents
  32. Autonomous AI and Vector CapabilitiesUsing Oracle Autonomous AI Database Serverlesscontents
  33. Autonomous Database Maintenance ModelUsing Oracle Autonomous AI Database Serverlesscontents
  34. Oracle Base Database Service ConceptsUsing Oracle Autonomous AI Database Serverlesscontents
  35. Exadata Database Service ConceptsOracle Exadata System Overviewcontents
  36. Exadata Cloud@Customer ConceptsOracle Exadata System Overviewcontents
  37. Hybrid Oracle Database Deployment PatternsUsing Oracle Autonomous AI Database Serverlesscontents
  38. OCI Network, Identity and Database Security BoundariesUsing Oracle Autonomous AI Database Serverlesscontents
  39. On-Premises to OCI Database Migration ArchitectureUsing Oracle Autonomous AI Database Serverlesscontents
  40. Choosing the Right Oracle Deployment ModelUsing Oracle Autonomous AI Database Serverlesscontents

Primary Oracle documentationOracle Exadata System OverviewcontentsOracle Exadata System Software User's GuidecontentsUsing Oracle Autonomous AI Database ServerlesscontentsHigh Availability Overview and Best PracticescontentsOracle Exadata Security GuidecontentsAI Enablement Guidecontents

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 ArchitectureDatabase Development Guidecontents
  2. Native JSON Data in Oracle AI DatabaseJSON Developer's Guidecontents
  3. SQL/JSON Query and GenerationJSON Developer's Guidecontents
  4. JSON Data Guide and Schema FlexibilityJSON Developer's Guidecontents
  5. JSON Search and IndexingJSON Developer's Guidecontents
  6. JSON Relational Duality ConceptsJSON Developer's Guidecontents
  7. Designing JSON Relational Duality ViewsJSON Developer's Guidecontents
  8. Duality, Transactions and Application ConsistencyJSON Developer's Guidecontents
  9. Property Graph Data Model FundamentalsOracle AI Database 26ai New Featurescontents
  10. SQL Property Graph and SQL/PGQ ConceptsOracle AI Database 26ai New Featurescontents
  11. Graph Pattern Matching and Relationship AnalyticsOracle AI Database 26ai New Featurescontents
  12. RDF Graph and Semantic Data FundamentalsGraph Developer's Guide for RDF Graphcontents
  13. Graph Architecture Decision PatternsDatabase Development Guidecontents
  14. Oracle Spatial Data Types and GeometrySpatial Developer's Guidecontents
  15. Spatial Indexing and Spatial Query ConceptsSpatial Developer's Guidecontents
  16. Geospatial Application ArchitectureSpatial Developer's Guidecontents
  17. Oracle Database In-Memory ArchitectureDatabase In-Memory Guidecontents
  18. Dual-Format Row Store and Column StoreDatabase Development Guidecontents
  19. In-Memory Population and DistributionDatabase In-Memory Guidecontents
  20. In-Memory Query AccelerationDatabase In-Memory Guidecontents
  21. Partitioning Strategy FundamentalsVLDB and Partitioning Guidecontents
  22. Range, List and Hash PartitioningVLDB and Partitioning Guidecontents
  23. Composite PartitioningVLDB and Partitioning Guidecontents
  24. Partition Lifecycle and Online OperationsVLDB and Partitioning Guidecontents
  25. Materialized Views and Query RewriteData Warehousing Guidecontents
  26. Parallel Execution for Data PlatformsData Warehousing Guidecontents
  27. Transactional Event Queues ArchitectureDatabase Transactional Event Queues and Advanced Queuing User's Guidecontents
  28. Advanced Queuing FundamentalsDatabase Transactional Event Queues and Advanced Queuing User's Guidecontents
  29. TxEventQ versus Kafka and External BrokersDatabase Transactional Event Queues and Advanced Queuing User's Guidecontents
  30. Transactional Messaging and Database Commit SemanticsDatabase Transactional Event Queues and Advanced Queuing User's Guidecontents
  31. Event-Driven Applications with TxEventQDatabase Transactional Event Queues and Advanced Queuing User's Guidecontents
  32. Oracle Globally Distributed AI Database ArchitectureOracle Globally Distributed AI Database Guidecontents
  33. Sharding Keys, Chunks and Data PlacementOracle Globally Distributed AI Database Guidecontents
  34. Replication and Availability in Globally Distributed DatabasesOracle Globally Distributed AI Database Guidecontents
  35. Global Data Services and Service RoutingGlobal Data Services Concepts and Administration Guidecontents
  36. True Cache Architecture and Read Scaling ConceptsOracle AI Database 26ai New Featurescontents
  37. JavaScript with Multilingual EngineOracle Database JavaScript Developer's Guidecontents
  38. Database APIs, ORDS and API-Centric Design ConceptsDatabase Development Guidecontents
  39. Telemetry Streaming from Oracle AI DatabaseOracle AI Database Telemetry Streaming Developer's Guidecontents
  40. Modern Oracle Application Architecture CapstoneDatabase Development Guidecontents

Primary Oracle documentationDatabase Development GuidecontentsOracle AI Database 26ai New FeaturescontentsJSON Developer's GuidecontentsSQL Language ReferencecontentsGraph Developer's Guide for RDF GraphcontentsSpatial Developer's GuidecontentsDatabase In-Memory GuidecontentsDatabase Performance Tuning GuidecontentsVLDB and Partitioning GuidecontentsData Warehousing GuidecontentsDatabase Transactional Event Queues and Advanced Queuing User's GuidecontentsOracle Globally Distributed AI Database GuidecontentsGlobal Data Services Concepts and Administration GuidecontentsHigh Availability Overview and Best PracticescontentsOracle Database JavaScript Developer's GuidecontentsOracle AI Database Telemetry Streaming Developer's Guidecontents

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 DatabaseAI Vector Search User's Guidecontents
  2. Embeddings and Vector Space FundamentalsAI Vector Search User's Guidecontents
  3. Dense, Sparse and Binary Vector ConceptsAI Vector Search User's Guidecontents
  4. VECTOR Data Type ArchitectureAI Vector Search User's Guidecontents
  5. Vector Distance MetricsAI Vector Search User's Guidecontents
  6. Exact Vector Similarity SearchAI Vector Search User's Guidecontents
  7. Approximate Nearest-Neighbour SearchAI Vector Search User's Guidecontents
  8. Vector Index ArchitectureAI Vector Search User's Guidecontents
  9. HNSW Index FundamentalsAI Vector Search User's Guidecontents
  10. IVF Index Fundamentals and Trade-OffsAI Vector Search User's Guidecontents
  11. Vector Index Accuracy, Recall and LatencyAI Vector Search User's Guidecontents
  12. Generating Embeddings inside OracleAI Vector Search User's Guidecontents
  13. ONNX Models and In-Database Inference ConceptsAI Vector Search User's Guidecontents
  14. Document Chunking and Chunk MetadataAI Vector Search User's Guidecontents
  15. Vectorizing Enterprise DocumentsAI Vector Search User's Guidecontents
  16. Metadata Filtering with Vector SearchAI Vector Search User's Guidecontents
  17. Hybrid Structured and Semantic RetrievalAI Vector Search User's Guidecontents
  18. Reranking and Retrieval QualityAI Vector Search User's Guidecontents
  19. RAG Architecture FundamentalsAI Vector Search User's Guidecontents
  20. RAG Grounding, Context and Citation DesignAI Vector Search User's Guidecontents
  21. Select AI ArchitectureOracle AI Database Select AI User's Guidecontents
  22. AI Profiles and Provider ConfigurationOracle AI Database Select AI User's Guidecontents
  23. Natural Language to SQL with Select AIOracle AI Database Select AI User's Guidecontents
  24. Prompt Construction and Schema GroundingOracle AI Database Select AI User's Guidecontents
  25. Select AI Conversation and ContextOracle AI Database Select AI User's Guidecontents
  26. Select AI RAGOracle AI Database Select AI User's Guidecontents
  27. Select AI Agents and Tool-Oriented WorkflowsOracle AI Database Select AI User's Guidecontents
  28. Synthetic Data, Summarization and Translation CapabilitiesOracle AI Database Select AI User's Guidecontents
  29. Private AI Services Container ArchitecturePrivate AI Services Container User's Guidecontents
  30. Private Models and Controlled Enterprise AIPrivate AI Services Container User's Guidecontents
  31. AI Credentials, Privileges and Data Access SecurityAI Enablement Guidecontents
  32. Prompt Injection and Database AI Threat ModellingAI Enablement Guidecontents
  33. Oracle Machine Learning for SQL ArchitectureOracle Machine Learning for SQL Conceptscontents
  34. Supervised Learning: Classification and RegressionOracle Machine Learning for SQL Conceptscontents
  35. Unsupervised Learning: Clustering and Anomaly DetectionOracle Machine Learning for SQL Conceptscontents
  36. Feature Extraction and In-Database Model ScoringOracle Machine Learning for SQL Conceptscontents
  37. Model Lifecycle, Evaluation and DeploymentOracle Machine Learning for SQL Conceptscontents
  38. Combining Relational, JSON, Graph and Vector DataAI Enablement Guidecontents
  39. Observability and Performance for AI Database WorkloadsAI Vector Search User's Guidecontents
  40. Enterprise Oracle 26ai AI/RAG Architecture CapstoneAI Vector Search User's Guidecontents

Primary Oracle documentationAI Vector Search User's GuidecontentsAI Enablement GuidecontentsOracle AI Database Select AI User's GuidecontentsPrivate AI Services Container User's GuidecontentsDatabase Security GuidecontentsOracle Machine Learning for SQL ConceptscontentsOracle Machine Learning for SQL User's GuidecontentsDatabase Performance Tuning Guidecontents

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 FundamentalsReference for Oracle GoldenGatecontents
  2. Log-Based CDC versus Trigger-Based CaptureReference for Oracle GoldenGatecontents
  3. Transaction Logs, Oracle Redo and Commit OrderingDatabase Conceptscontents
  4. Oracle GoldenGate 26ai Platform Use CasesReference for Oracle GoldenGatecontents
  5. GoldenGate Microservices ArchitectureReference for Oracle GoldenGatecontents
  6. GoldenGate Deployments and Service BoundariesReference for Oracle GoldenGatecontents
  7. Source Database Preparation and Supplemental LoggingReference for Oracle GoldenGatecontents
  8. Extract Process ArchitectureReference for Oracle GoldenGatecontents
  9. Integrated Extract ConceptsReference for Oracle GoldenGatecontents
  10. Extract Checkpoints and Recovery PositionReference for Oracle GoldenGatecontents
  11. GoldenGate Trail File ArchitectureLogDump Reference Guidecontents
  12. Trail Record Structure and Transaction BoundariesLogDump Reference Guidecontents
  13. Distribution Service and Remote Trail DeliveryReference for Oracle GoldenGatecontents
  14. Receiver Service ArchitectureReference for Oracle GoldenGatecontents
  15. Initial Load versus Ongoing CDCReference for Oracle GoldenGatecontents
  16. Instantiation and Replication Start PointsReference for Oracle GoldenGatecontents
  17. Replicat Process ArchitectureReference for Oracle GoldenGatecontents
  18. Integrated Replicat ConceptsReference for Oracle GoldenGatecontents
  19. Parallel Replicat and Apply ParallelismReference for Oracle GoldenGatecontents
  20. MAP, TABLE, Filtering and Routing ConceptsReference for Oracle GoldenGatecontents
  21. Data Transformation in GoldenGateReference for Oracle GoldenGatecontents
  22. DDL Replication ConceptsReference for Oracle GoldenGatecontents
  23. Sequences and Database Object ConsiderationsReference for Oracle GoldenGatecontents
  24. Heartbeat Tables and End-to-End LagReference for Oracle GoldenGatecontents
  25. Error Handling, REPERROR and Discard FilesReference for Oracle GoldenGatecontents
  26. GoldenGate Security, Credentials and EncryptionReference for Oracle GoldenGatecontents
  27. TLS and Secure Deployment CommunicationReference for Oracle GoldenGatecontents
  28. GoldenGate Monitoring and Operational MetricsReference for Oracle GoldenGatecontents
  29. LogDump and Trail-Level TroubleshootingLogDump Reference Guidecontents
  30. Checkpoint Recovery and Process RepositioningReference for Oracle GoldenGatecontents
  31. Trail Retention, Purging and Disk ManagementReference for Oracle GoldenGatecontents
  32. GoldenGate Performance EngineeringReference for Oracle GoldenGatecontents
  33. GoldenGate with Oracle RACReference for Oracle GoldenGatecontents
  34. GoldenGate with Data Guard and MAAUsing Oracle GoldenGate Maximum Availability Hub 26aicontents
  35. Bidirectional Replication and Loop PreventionReference for Oracle GoldenGatecontents
  36. Conflict Detection and Resolution ConceptsReference for Oracle GoldenGatecontents
  37. Heterogeneous Replication ArchitectureReference for Oracle GoldenGatecontents
  38. Zero-Downtime Migration with GoldenGateReference for Oracle GoldenGatecontents
  39. GoldenGate Maximum Availability HubUsing Oracle GoldenGate Maximum Availability Hub 26aicontents
  40. GoldenGate Architecture, Failure and Troubleshooting CapstoneReference for Oracle GoldenGatecontents

Primary Oracle documentationReference for Oracle GoldenGatecontentsLogDump Reference GuidecontentsDatabase ConceptscontentsReal Application Clusters Administration and Deployment GuidecontentsUsing Oracle GoldenGate Maximum Availability Hub 26aicontentsData Guard Concepts and AdministrationcontentsOracle AI Database Upgrade Guidecontents

Documentation bundles

Get the official PDFs, level by level

Every chapter title in the curriculum links straight to its primary Oracle PDF. For offline study, each level ships a manifest of the Oracle URLs it uses and a fetch script that downloads them into one folder.

We do not host or redistribute Oracle's PDFs. They are Oracle's copyrighted documentation, so the scripts download directly from docs.oracle.com and you end up with the same folder of files, obtained from the vendor. The 600 chapters draw on 68 distinct documents, so a level bundle is a handful of PDFs rather than hundreds.

Sourcing

Anchored to official Oracle documentation

Each chapter carries a primary Oracle-hosted PDF, with a second official Oracle document for adjacent architecture where it helps. Across the programme that spans 68 Oracle documentation sets for Oracle AI Database 26ai and the surrounding platform.

Documentation baseline: 2026-09-14. 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 Program

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

Build real Oracle platform capability

Take the full programme, or bring a track to your DBA and platform team.

Enrol or enquire All database programmes