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
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.
- Data Platforms, OLTP, Analytics and AI Workloads
- Relational Database Principles and the Relational Model
- Tables, Rows, Columns, Keys and Relationships
- Integrity Constraints and Data Quality Fundamentals
- SQL, PL/SQL and Oracle Programming Layers
- ACID Transaction Fundamentals
- Isolation, Consistency and Concurrency
- Undo, Redo and Durability Mental Model
- Locks, Latches and Database Coordination
- Read Consistency and Oracle Multiversion Concurrency
- Oracle AI Database 26ai Platform Architecture
- Oracle Database versus Oracle Instance
- Physical versus Logical Database Structures
- Data Blocks, Extents and Segments
- Datafiles, Tempfiles and Control Files
- Online Redo Logs and Archived Redo
- System Global Area Architecture
- Programme Global Area and Process Memory
- Oracle Background Processes
- Server Processes, Sessions and Connections
- Checkpoints and Instance Recovery
- System Change Numbers and Transaction Ordering
- Schemas, Schema Objects and Namespaces
- Data Dictionary and Dynamic Performance Views
- Multitenant CDB and PDB Concept Preview
- Services, Instances and Connection Routing
- Oracle Net Listener Fundamentals
- Linux Users, Groups and Process Fundamentals for Oracle
- Linux Filesystems, Devices and Permissions for Oracle
- Linux CPU, Memory and I/O Fundamentals for DBAs
- Linux Networking and Name Resolution for Oracle
- ORACLE_BASE, ORACLE_HOME and Environment Architecture
- Oracle Software Installation Architecture
- Building a Personal Oracle AI Database Free 26ai Lab
- Oracle Editions, Options and Licensing Fundamentals
- Oracle 26ai Release Model and Release Updates
- The Converged Database Platform Concept
- Backup versus High Availability versus Disaster Recovery
- Database Security, Least Privilege and Audit Fundamentals
- 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.
- Oracle SQL Processing Model
- SELECT Fundamentals and Projection
- Filtering, Predicates and Three-Valued Logic
- Oracle Data Types and Type Conversion
- NULL Semantics and NULL-Safe Design
- Character, Numeric and Date-Time Functions
- CASE Expressions and Conditional SQL
- Joins and Relational Composition
- Outer Joins, Self Joins and Advanced Join Semantics
- GROUP BY, Aggregation and HAVING
- Scalar and Correlated Subqueries
- EXISTS, IN and Semi-Join Thinking
- Set Operators and Set-Based Design
- INSERT, UPDATE, DELETE and MERGE
- Transaction Control with COMMIT, ROLLBACK and SAVEPOINT
- DDL, Object Lifecycle and Implicit Commit Behaviour
- Primary, Unique, Foreign Key and Check Constraints
- Views and Security-Aware Abstraction
- Sequences, Identity Columns and Key Generation
- B-Tree, Bitmap and Function-Based Index Concepts
- Partitioned Tables and Partitioned Indexes
- Analytic Functions and Window Processing
- Hierarchical Queries and Recursive SQL
- Advanced Grouping, PIVOT and UNPIVOT
- SQL Execution Semantics and Deterministic Results
- PL/SQL Architecture and Anonymous Blocks
- Variables, Constants, Records and Collections
- PL/SQL Control Structures
- Explicit and Implicit Cursors
- Exception Handling and Error Propagation
- Stored Procedures and Functions
- Packages, Package State and Encapsulation
- Triggers and Their Appropriate Use
- Dynamic SQL with Native Dynamic SQL
- Bulk SQL with BULK COLLECT and FORALL
- PL/SQL Transaction Boundaries and Autonomous Transactions
- PL/SQL Performance and Context Switching
- Secure PL/SQL and Definer versus Invoker Rights
- Database Application Design Patterns
- 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.
- DBA Responsibilities and the Production Database Lifecycle
- Planning an Oracle AI Database 26ai Installation
- Linux Prerequisites and Preinstallation Validation
- Installing Oracle AI Database Software
- Creating Databases with DBCA
- Understanding Database Creation Internals
- Starting, Mounting, Opening and Shutting Down a Database
- PFILE, SPFILE and Initialization Parameter Management
- Password Files and Administrative Authentication
- SGA Configuration and Memory Management
- PGA Configuration and Workarea Management
- Control File Architecture and Multiplexing
- Online Redo Log Architecture and Multiplexing
- ARCHIVELOG Mode and Archive Destination Management
- Undo Tablespaces and Automatic Undo Management
- Temporary Tablespaces and Temporary Segments
- Permanent Tablespaces and Segment Space Management
- Datafiles, Autoextend and Oracle Managed Files
- Fast Recovery Area Architecture and Management
- Block Size, Extents and Segment Storage
- Users, Schemas and Account Administration
- System Privileges, Object Privileges and Roles
- Profiles, Password Policies and Resource Limits
- Oracle Net Service Naming and Client Connectivity
- Listener Administration and Dynamic Service Registration
- Database Services and Workload-Aware Connectivity
- Database Links and Distributed Database Fundamentals
- Oracle Scheduler Jobs and Programmes
- Database Resource Manager Fundamentals
- Alert Log, Trace Files and ADR
- ADRCI and Diagnostic Incident Packaging
- Dynamic Performance Views for Daily DBA Work
- Data Dictionary Views for Daily DBA Work
- Data Pump Export Architecture
- Data Pump Import and Metadata Movement
- SQL*Loader, External Tables and Bulk Loading
- Statistics Collection and Routine Maintenance
- Space Monitoring and Capacity Management
- Daily, Weekly and Monthly DBA Runbooks
- 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.
- Why Oracle Multitenant Exists
- CDB, Root, Seed and PDB Architecture
- Container IDs, Namespaces and CON_ID
- Common versus Local Users and Roles
- Common versus Local Objects and Metadata
- Creating a Container Database
- Creating a PDB from the Seed
- Creating a PDB from Another PDB
- Hot Cloning a PDB
- Snapshot Copy PDBs
- Unplugging and Plugging PDBs
- PDB Compatibility and Plug-In Violations
- PDB Relocation between CDBs
- Refreshable Clone PDBs
- PDB Services and Connection Routing
- Opening, Closing and Saving PDB State
- PDB Storage and Tablespace Management
- PDB Resource Management and Resource Plans
- PDB Memory and I/O Governance
- Lockdown Profiles and PDB Isolation
- TDE and Keystore Considerations in Multitenant
- Common Audit Policies and PDB Auditing
- Application Containers and Application Roots
- Application PDBs and Application Seeds
- Application Installation and Synchronization
- PDB Data Pump Export and Import
- PDB Backup Architecture
- PDB Restore and Recovery
- PDB Point-in-Time Recovery
- PDB Flashback and Restore Points
- PDB Cloning for Dev/Test
- PDB Lifecycle Automation
- PDB Upgrade and Compatibility Management
- PDB Patching and Fleet Maintenance Concepts
- PDBs in Oracle RAC
- PDBs with Oracle Data Guard
- Consolidation Density and Noisy-Neighbour Control
- Multitenant Security Boundaries and Governance
- Multitenant Troubleshooting and Failure Scenarios
- 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.
- Oracle Grid Infrastructure Architecture
- Oracle Restart versus Clustered Grid Infrastructure
- Grid Infrastructure Installation Planning
- Cluster Nodes, Cluster Membership and Discovery
- Oracle Cluster Registry Architecture
- Voting Files and Cluster Quorum
- Clusterware Resource Model
- CRS, CSS, EVM and Clusterware Process Architecture
- SCAN, VIPs and Cluster Network Identity
- Clusterware Resource Dependencies and Placement
- CRSCTL Administration Fundamentals
- SRVCTL Administration Fundamentals
- ASM Architecture and the ASM Instance
- ASM Disk Discovery and Disk Provisioning
- ASM Disk Groups and Compatibility Attributes
- Allocation Units, Extents and ASM Striping
- External, Normal and High Redundancy
- ASM Failure Groups and Failure Domains
- ASM Quorum Failure Groups
- ASM File Types and File Naming
- ASM Templates and Storage Policies
- ASM Rebalancing Fundamentals
- ASM Rebalance Power and Performance
- Adding, Dropping and Replacing ASM Disks
- ASM Preferred Read and Read Locality
- ASM Dynamic Performance Views
- ASM Metadata and Storage Diagnostics
- ASM Filter Driver Concepts
- Flex ASM Architecture
- Flex ASM Clients and Cardinality
- ACFS and ADVM Architecture
- Creating and Managing ACFS File Systems
- ACFS Snapshots
- ACFS Replication and Availability Concepts
- ACFS Security and Encryption Concepts
- Oracle Restart Resource Administration
- Cluster Verification and Preflight Checks
- Grid Infrastructure Upgrade Strategy
- Grid Infrastructure Patching Concepts
- 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.
- Recovery Engineering: What Must Survive a Failure
- Instance Recovery versus Media Recovery
- ARCHIVELOG and NOARCHIVELOG Recovery Boundaries
- Fast Recovery Area and Recovery Retention
- RMAN Architecture, Channels and Server Sessions
- RMAN Repository and Control File Metadata
- Recovery Catalog Architecture
- Backup Sets and Backup Pieces
- Image Copies and Copy-Based Recovery
- Full Backups versus Incremental Backups
- Differential and Cumulative Incrementals
- Block Change Tracking
- Backing Up Archived Redo Logs
- Control File and SPFILE Autobackups
- RMAN Retention Policies and Obsolete Backups
- Backup Optimization
- Backup Compression
- Backup Encryption and Keystore Dependencies
- Validating Backups and Detecting Corruption
- RESTORE versus RECOVER Semantics
- Complete Database Media Recovery
- Incomplete Recovery and RESETLOGS
- Database Point-in-Time Recovery
- Tablespace Point-in-Time Recovery
- PDB Point-in-Time Recovery
- Recovering Individual Tables and Table Partitions
- Block Media Recovery
- Recovering a Lost Control File
- Recovering a Lost SPFILE
- Recovery after Online Redo Log Loss
- Recovery after Datafile Loss
- RMAN Crosscheck, Catalog and Uncatalog Operations
- Database Duplication from Backup
- Active Database Duplication
- Creating Standby Databases with RMAN
- Flashback Query and Historical Read
- Flashback Table
- Flashback Database and Flashback Logs
- Guaranteed Restore Points and Rewind Strategy
- 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.
- Performance Engineering Methodology
- DB Time and the Oracle Time Model
- Oracle Wait Interface Fundamentals
- Dynamic Performance Views for Performance Analysis
- Automatic Workload Repository Architecture
- Active Session History Architecture
- Automatic Database Diagnostic Monitor
- Database Metrics, Baselines and Thresholds
- CPU Saturation and Scheduler Diagnosis
- Buffer Cache Behaviour and Logical I/O
- Shared Pool, Library Cache and Cursor Management
- PGA, Workareas and Temporary Spill
- Storage I/O Latency and Throughput Analysis
- Concurrency, Enqueues and Blocking Sessions
- Latches, Mutexes and Internal Contention
- Hard Parsing, Soft Parsing and Cursor Sharing
- SQL Processing and the Optimizer Lifecycle
- Cost-Based Optimizer Fundamentals
- Optimizer Statistics Architecture
- Histograms, Skew and Selectivity
- Cardinality Estimation and Estimation Errors
- Table Access Paths and Full Scans
- B-Tree and Bitmap Index Access Paths
- Nested Loops, Hash Joins and Sort-Merge Joins
- Optimizer Transformations
- Partition Pruning and Partition-Wise Operations
- Reading Execution Plans Correctly
- DBMS_XPLAN and Runtime Plan Statistics
- SQL Monitoring and Long-Running SQL
- SQL Trace, TKPROF and Instrumentation
- SQL Tuning Advisor
- SQL Profiles
- SQL Plan Baselines
- SQL Patches and Targeted Plan Control
- Adaptive SQL and Plan Evolution Concepts
- Parallel Execution Fundamentals
- SQL Performance Analyzer
- Database Replay and Workload Validation
- Diagnosing a Production Performance Regression
- 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.
- Oracle Database Security Architecture
- Authentication Models and Administrative Authentication
- SYSDBA, SYSOPER, SYSBACKUP and Administrative Privileges
- System and Object Privilege Design
- Role Design and Least Privilege
- Profiles, Password Policies and Account Controls
- Proxy Authentication and Enterprise Access Patterns
- Network Encryption and TLS for Oracle Net
- Transparent Data Encryption Architecture
- Software Keystores, Wallets and Master Encryption Keys
- Tablespace Encryption
- Column Encryption
- Key Rotation, Rekeying and Keystore Backup
- External Key Management and Oracle Key Vault Integration Concepts
- Unified Auditing Architecture
- Fine-Grained Auditing
- Privilege Analysis
- Virtual Private Database and Row-Level Security
- Real Application Security Architecture
- Application Users, Sessions and Security Classes
- Database Vault Architecture
- Database Vault Realms
- Database Vault Command Rules
- Separation of Duties with Database Vault
- Oracle Label Security Architecture
- Label Policies and Data Classification
- Data Redaction Architecture
- Redaction Policies and Runtime Behaviour
- SQL Firewall Architecture
- SQL Firewall Capture, Allow Lists and Enforcement
- Data Masking Fundamentals
- Data Subsetting for Non-Production Environments
- Sensitive Data Discovery and Protection Strategy
- Oracle Deep Data Security
- Security in Multitenant CDBs and PDBs
- Security in RAC and Data Guard
- Security for Vector, RAG and AI Workloads
- Database Security Monitoring and Incident Response
- Enterprise Database Hardening Baseline
- 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.
- Why Oracle RAC Exists and When Not to Use It
- Shared-Everything Database Cluster Architecture
- RAC, Grid Infrastructure and Clusterware Boundaries
- Planning a RAC Installation
- RAC Network Architecture
- SCAN, VIP, Local Listener and Remote Listener
- RAC Shared Storage and ASM Dependencies
- RAC Instance Architecture
- RAC-Specific Background Processes
- Global Resource Directory
- Global Cache Service
- Global Enqueue Service
- Cache Fusion Fundamentals
- Current Block Transfers between Instances
- Consistent Read Block Transfers between Instances
- Interconnect Architecture and Latency
- Redo, Undo and Recovery in RAC
- Sequences, Services and Instance Affinity
- Starting and Stopping RAC Databases
- SRVCTL for RAC Database Administration
- RAC Services and Workload Placement
- Client-Side and Server-Side Load Balancing
- Fast Application Notification
- Fast Connection Failover
- Application Continuity and Transaction Guard Concepts
- Transparent Application Continuity Concepts
- Server Pools and Policy-Managed Concepts
- PDB Placement and Services in RAC
- Oracle RAC One Node
- RAC Instance Failure and Cluster Reconfiguration
- Instance Recovery after RAC Failure
- Global Cache Performance Waits
- Diagnosing gc cr and gc current Contention
- RAC Workload Design and Hot-Block Avoidance
- Rolling Maintenance and Availability
- RAC Patching Architecture
- Backup and Recovery in RAC
- GoldenGate Integration with RAC Concepts
- RAC Failure Injection and Troubleshooting
- 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.
- RPO, RTO and Disaster-Recovery Engineering
- Oracle Data Guard Architecture
- Physical Standby Database Architecture
- Redo Transport Services
- Synchronous versus Asynchronous Redo Transport
- Standby Redo Logs
- Redo Apply and Managed Recovery
- Real-Time Apply
- Data Guard Protection Modes
- Creating a Physical Standby
- Primary and Standby Initialization Parameters
- Log Archive Destinations and Transport Attributes
- Transport Lag versus Apply Lag
- Redo Gap Detection and Resolution
- Role Management and Database States
- Planned Switchover
- Unplanned Failover
- Reinstating a Former Primary
- Data Guard Broker Architecture
- DGMGRL Administration
- Fast-Start Failover
- Observer Architecture and Placement
- Far Sync Instances
- Snapshot Standby Databases
- Logical Standby Concepts and Use Cases
- Active Data Guard Read-Only Workloads
- Automatic Block Repair Concepts
- Backups on a Standby Database
- RAC plus Data Guard Architecture
- Multitenant and Data Guard
- Data Guard for Pluggable Databases Concepts
- Data Guard Network Failure Scenarios
- Data Guard Performance and Redo Transport Tuning
- Monitoring and Alerting for Data Guard
- Patching Data Guard with Minimal Downtime
- Rolling Upgrade Concepts
- Maximum Availability Architecture Principles
- Global Data Services with Replicated Databases
- Data Guard versus GoldenGate Decision Architecture
- 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.
- Oracle Software Maintenance Lifecycle
- Release Updates, Monthly Recommended Patches and One-Off Fixes
- Oracle Home Inventory and Software Configuration Baselines
- Out-of-Place versus In-Place Patching
- DBCA Gold-Image Patch Maintenance for Single Instance
- OPatch Fundamentals and Inventory Checks
- Patch Prerequisites, Conflict Detection and Rollback
- OPatchAuto for RAC
- OPatchAuto for Data Guard
- Fleet Patching and Provisioning Architecture
- FPP Gold Images and Image Management
- Provisioning Oracle Homes with FPP
- Fleet-Scale Database Patching
- Fleet-Scale Grid Infrastructure Patching
- Patching Strategy for Large Oracle Estates
- Database Upgrade Architecture
- COMPATIBLE and Upgrade Boundaries
- Pre-Upgrade Assessment and Remediation
- AutoUpgrade Architecture
- AutoUpgrade Analyze, Fixups and Deploy
- Upgrade Recovery, Fallback and Restore-Point Strategy
- Upgrading Multitenant Databases
- Upgrading RAC Databases
- Upgrading Data Guard Configurations
- Grid Infrastructure Upgrade Strategy
- Post-Upgrade Validation and Performance Regression Testing
- SQL Performance Analyzer for Change Validation
- Database Replay for Change Validation
- Data Pump as a Migration Mechanism
- Transportable Tablespaces and Cross-Platform Migration Concepts
- Oracle Enterprise Manager 24ai Architecture
- Targets, Agents, OMS and Management Repository
- Enterprise Manager Database Monitoring
- Enterprise Manager Incidents, Events and Notifications
- Enterprise Manager Jobs, Groups and Administration
- Autonomous Health Framework Architecture
- ORAchk and Compliance Health Checks
- Trace File Analyzer and Incident Collection
- ADRCI, Diagnostic Packaging and Support Evidence
- 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.
- Why Exadata Exists
- Oracle Exadata Hardware and Software Architecture
- Database Servers, Storage Servers and Network Fabric
- Exadata Storage Server Software and Cells
- Smart Scan and SQL Offload
- Storage Indexes
- Smart Flash Cache
- Exadata Persistent Memory and RDMA Concepts
- Hybrid Columnar Compression
- Exadata I/O Resource Management
- Exadata Smart Software Capabilities
- Exadata Database and Storage Metrics
- Exadata Workload Consolidation
- Exadata MAA and High Availability
- Exadata Security Architecture
- Exadata Patching and Lifecycle Concepts
- Exadata Capacity and Performance Engineering
- Exadata Failure Domains and Resilience
- Exadata On-Premises versus Cloud Service Architecture
- Exadata Architecture Review
- Autonomous AI Database Architecture
- Autonomous Database Workload Types and Service Levels
- Compute, Storage and Auto Scaling
- Autonomous Database Networking and Access
- Wallets, TLS and Autonomous Connectivity
- Users, Roles and Security in Autonomous Database
- Loading and Unloading Data in Autonomous Database
- DBMS_CLOUD and Object Storage Integration
- Autonomous Backup, Restore and Point-in-Time Recovery
- Cloning Autonomous Databases
- Autonomous Performance Management
- Autonomous AI and Vector Capabilities
- Autonomous Database Maintenance Model
- Oracle Base Database Service Concepts
- Exadata Database Service Concepts
- Exadata Cloud@Customer Concepts
- Hybrid Oracle Database Deployment Patterns
- OCI Network, Identity and Database Security Boundaries
- On-Premises to OCI Database Migration Architecture
- 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.
- Oracle Converged Data Architecture
- Native JSON Data in Oracle AI Database
- SQL/JSON Query and Generation
- JSON Data Guide and Schema Flexibility
- JSON Search and Indexing
- JSON Relational Duality Concepts
- Designing JSON Relational Duality Views
- Duality, Transactions and Application Consistency
- Property Graph Data Model Fundamentals
- SQL Property Graph and SQL/PGQ Concepts
- Graph Pattern Matching and Relationship Analytics
- RDF Graph and Semantic Data Fundamentals
- Graph Architecture Decision Patterns
- Oracle Spatial Data Types and Geometry
- Spatial Indexing and Spatial Query Concepts
- Geospatial Application Architecture
- Oracle Database In-Memory Architecture
- Dual-Format Row Store and Column Store
- In-Memory Population and Distribution
- In-Memory Query Acceleration
- Partitioning Strategy Fundamentals
- Range, List and Hash Partitioning
- Composite Partitioning
- Partition Lifecycle and Online Operations
- Materialized Views and Query Rewrite
- Parallel Execution for Data Platforms
- Transactional Event Queues Architecture
- Advanced Queuing Fundamentals
- TxEventQ versus Kafka and External Brokers
- Transactional Messaging and Database Commit Semantics
- Event-Driven Applications with TxEventQ
- Oracle Globally Distributed AI Database Architecture
- Sharding Keys, Chunks and Data Placement
- Replication and Availability in Globally Distributed Databases
- Global Data Services and Service Routing
- True Cache Architecture and Read Scaling Concepts
- JavaScript with Multilingual Engine
- Database APIs, ORDS and API-Centric Design Concepts
- Telemetry Streaming from Oracle AI Database
- 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.
- What Makes an AI-Native Database
- Embeddings and Vector Space Fundamentals
- Dense, Sparse and Binary Vector Concepts
- VECTOR Data Type Architecture
- Vector Distance Metrics
- Exact Vector Similarity Search
- Approximate Nearest-Neighbour Search
- Vector Index Architecture
- HNSW Index Fundamentals
- IVF Index Fundamentals and Trade-Offs
- Vector Index Accuracy, Recall and Latency
- Generating Embeddings inside Oracle
- ONNX Models and In-Database Inference Concepts
- Document Chunking and Chunk Metadata
- Vectorizing Enterprise Documents
- Metadata Filtering with Vector Search
- Hybrid Structured and Semantic Retrieval
- Reranking and Retrieval Quality
- RAG Architecture Fundamentals
- RAG Grounding, Context and Citation Design
- Select AI Architecture
- AI Profiles and Provider Configuration
- Natural Language to SQL with Select AI
- Prompt Construction and Schema Grounding
- Select AI Conversation and Context
- Select AI RAG
- Select AI Agents and Tool-Oriented Workflows
- Synthetic Data, Summarization and Translation Capabilities
- Private AI Services Container Architecture
- Private Models and Controlled Enterprise AI
- AI Credentials, Privileges and Data Access Security
- Prompt Injection and Database AI Threat Modelling
- Oracle Machine Learning for SQL Architecture
- Supervised Learning: Classification and Regression
- Unsupervised Learning: Clustering and Anomaly Detection
- Feature Extraction and In-Database Model Scoring
- Model Lifecycle, Evaluation and Deployment
- Combining Relational, JSON, Graph and Vector Data
- Observability and Performance for AI Database Workloads
- 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.
- Change Data Capture Fundamentals
- Log-Based CDC versus Trigger-Based Capture
- Transaction Logs, Oracle Redo and Commit Ordering
- Oracle GoldenGate 26ai Platform Use Cases
- GoldenGate Microservices Architecture
- GoldenGate Deployments and Service Boundaries
- Source Database Preparation and Supplemental Logging
- Extract Process Architecture
- Integrated Extract Concepts
- Extract Checkpoints and Recovery Position
- GoldenGate Trail File Architecture
- Trail Record Structure and Transaction Boundaries
- Distribution Service and Remote Trail Delivery
- Receiver Service Architecture
- Initial Load versus Ongoing CDC
- Instantiation and Replication Start Points
- Replicat Process Architecture
- Integrated Replicat Concepts
- Parallel Replicat and Apply Parallelism
- MAP, TABLE, Filtering and Routing Concepts
- Data Transformation in GoldenGate
- DDL Replication Concepts
- Sequences and Database Object Considerations
- Heartbeat Tables and End-to-End Lag
- Error Handling, REPERROR and Discard Files
- GoldenGate Security, Credentials and Encryption
- TLS and Secure Deployment Communication
- GoldenGate Monitoring and Operational Metrics
- LogDump and Trail-Level Troubleshooting
- Checkpoint Recovery and Process Repositioning
- Trail Retention, Purging and Disk Management
- GoldenGate Performance Engineering
- GoldenGate with Oracle RAC
- GoldenGate with Data Guard and MAA
- Bidirectional Replication and Loop Prevention
- Conflict Detection and Resolution Concepts
- Heterogeneous Replication Architecture
- Zero-Downtime Migration with GoldenGate
- GoldenGate Maximum Availability Hub
- GoldenGate Architecture, Failure and Troubleshooting Capstone
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.
Three ways to take Oracle AI Database 26ai Platform Master Programme
| 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 |
Get the programme guide
The full chapter list, what each module covers, and how the tiers compare - sent to your inbox as a PDF.
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