Curriculum planned

Stage 02 · Relational Databases

Oracle Database

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

Browse planned curriculum Back to all courses

29planned chapters

145reserved lesson paths

Intermediate → Expertlearning level

Plannedcourse state

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

Course brief

From engine fundamentals to advanced production operations.

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

By the end

You will be able to

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

Complete planned syllabus

29 chapters · 145 lesson paths.

Every lesson path is reserved now but intentionally not linked until its lesson HTML is actually published. The sequence moves from foundations through internals, advanced features, administration, reliability, security, tuning, upgrades, and a production capstone.

Chapter 1

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

5 lessons

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

Planned02

Oracle AI Database 26ai LTS, Free/Developer Learning Paths, Licensing Awareness, and Feature BoundariesPlanned lesson · reserved path Chapter01/Lesson2.html

Planned03

On-Premises, OCI, Autonomous, Exadata, and Container-Based Learning/Deployment ModelsPlanned lesson · reserved path Chapter01/Lesson3.html

Planned04

Install or Provision an Oracle Lab, Configure Listener/Services, and Verify SQLcl/SQL*Plus ConnectivityPlanned lesson · reserved path Chapter01/Lesson4.html

Planned05

Build a Safe Course Environment with Users, Tablespaces, Sample Schemas, and Baseline BackupsPlanned lesson · reserved path Chapter01/Lesson5.html

Planned

Chapter 2

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

5 lessons

Oracle Instance vs Database, SGA Components, Background Processes, and Physical FilesPlanned lesson · reserved path Chapter02/Lesson1.html

Planned02

PGA, Work Areas, Session/Process Models, Dedicated vs Shared Server, and Connection LifecyclePlanned lesson · reserved path Chapter02/Lesson2.html

Planned03

Parameter Files, SPFILE/PFILE, Dynamic Parameters, ALTER SYSTEM, and ScopePlanned lesson · reserved path Chapter02/Lesson3.html

Planned04

STARTUP/SHUTDOWN States, Mount/Open Modes, Restricted Sessions, and Recovery ContextPlanned lesson · reserved path Chapter02/Lesson4.html

Planned05

Alert Log, ADR, Trace Files, Dynamic Performance Views, and Startup TroubleshootingPlanned lesson · reserved path Chapter02/Lesson5.html

Planned

Chapter 3

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

5 lessons

Database Blocks, Extents, Segments, Tablespaces, Datafiles, and Space AllocationPlanned lesson · reserved path Chapter03/Lesson1.html

Planned02

Permanent, Temporary, Undo Tablespaces and Bigfile vs Smallfile TradeoffsPlanned lesson · reserved path Chapter03/Lesson2.html

Planned03

Locally Managed Tablespaces, ASSM, High-Water Marks, and Space ReclamationPlanned lesson · reserved path Chapter03/Lesson3.html

Planned04

Automatic Storage Management Concepts: Disk Groups, Failure Groups, Striping, and MirroringPlanned lesson · reserved path Chapter03/Lesson4.html

Planned05

Design a Storage Layout for OLTP, Analytics, Temp, Undo, Recovery, and GrowthPlanned lesson · reserved path Chapter03/Lesson5.html

Planned

Chapter 4

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

5 lessons

Users vs Schemas, Object Ownership, Naming, Synonyms, and Namespace SemanticsPlanned lesson · reserved path Chapter04/Lesson1.html

Planned02

NUMBER, Character, DATE/TIMESTAMP, INTERVAL, RAW, LOB, JSON, VECTOR, and Specialized TypesPlanned lesson · reserved path Chapter04/Lesson2.html

Planned03

PRIMARY KEY, UNIQUE, FOREIGN KEY, CHECK, NOT NULL, DEFERRABLE, and RELY/NOVALIDATE ConceptsPlanned lesson · reserved path Chapter04/Lesson3.html

Planned04

Identity Columns, Sequences, Caching, Ordering, Gaps, and Scalable Identifier PatternsPlanned lesson · reserved path Chapter04/Lesson4.html

Planned05

Virtual Columns, Defaults, Invisible Columns, Wide-Table Awareness, and Data-Integrity DesignPlanned lesson · reserved path Chapter04/Lesson5.html

Planned

Chapter 5

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

5 lessons

SELECT Semantics, NULL, Expressions, Conversion, NLS Effects, and Deterministic OrderingPlanned lesson · reserved path Chapter05/Lesson1.html

Planned02

INNER/OUTER/CROSS Joins, Legacy Join Syntax Awareness, and Cardinality ReasoningPlanned lesson · reserved path Chapter05/Lesson2.html

Planned03

Scalar/Correlated Subqueries, EXISTS/IN, Semijoins, Antijoins, and Subquery FactoringPlanned lesson · reserved path Chapter05/Lesson3.html

Planned04

UNION/UNION ALL/INTERSECT/MINUS, Query Composition, and Duplicate SemanticsPlanned lesson · reserved path Chapter05/Lesson4.html

Planned05

CONNECT BY, Recursive WITH, Hierarchical Data, Cycle Handling, and Tree TraversalPlanned lesson · reserved path Chapter05/Lesson5.html

Planned

Chapter 6

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

5 lessons

Analytic Functions, Partitions, Frames, Ranking, Running Metrics, and Gaps-and-IslandsPlanned lesson · reserved path Chapter06/Lesson1.html

Planned02

PIVOT/UNPIVOT, GROUPING SETS, CUBE, ROLLUP, and Advanced AggregationPlanned lesson · reserved path Chapter06/Lesson2.html

Planned03

MATCH_RECOGNIZE for Row Pattern Recognition and Event-Sequence AnalysisPlanned lesson · reserved path Chapter06/Lesson3.html

Planned04

MODEL Clause Concepts, Spreadsheet-Like Calculations, and Appropriate Use CasesPlanned lesson · reserved path Chapter06/Lesson4.html

Planned05

SQL Macros and Reusable SQL Abstractions, Optimizer Visibility, and MaintainabilityPlanned lesson · reserved path Chapter06/Lesson5.html

Planned

Chapter 7

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

5 lessons

INSERT, Multi-Table INSERT, UPDATE, DELETE, MERGE, RETURNING, and Error LoggingPlanned lesson · reserved path Chapter07/Lesson1.html

Planned02

Transactions, COMMIT, ROLLBACK, SAVEPOINT, Implicit Commit Boundaries, and Autonomous TransactionsPlanned lesson · reserved path Chapter07/Lesson2.html

Planned03

Oracle Read Consistency, SCNs, Undo, Statement-Level Snapshots, and Consistent GetsPlanned lesson · reserved path Chapter07/Lesson3.html

Planned04

Row Locks, Table Locks, ITL, Enqueues, SELECT FOR UPDATE, and Concurrency SemanticsPlanned lesson · reserved path Chapter07/Lesson4.html

Planned05

Deadlocks, Blocking Sessions, ORA-01555 Snapshot Too Old, Undo Sizing, and Retry DesignPlanned lesson · reserved path Chapter07/Lesson5.html

Planned

Chapter 8

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

5 lessons

B-Tree Index Structure, Leaf Blocks, Branches, Rowids, Selectivity, and Clustering FactorPlanned lesson · reserved path Chapter08/Lesson1.html

Planned02

Composite, Descending, Function-Based, Invisible, and Compressed IndexesPlanned lesson · reserved path Chapter08/Lesson2.html

Planned03

Bitmap Indexes for Analytical Workloads, DML Costs, and Concurrency LimitationsPlanned lesson · reserved path Chapter08/Lesson3.html

Planned04

Index-Organized Tables, Secondary Indexes, Overflow Segments, and Key-Based AccessPlanned lesson · reserved path Chapter08/Lesson4.html

Planned05

Domain/Spatial/Text/Vector Index Concepts and Choosing Specialized Access PathsPlanned lesson · reserved path Chapter08/Lesson5.html

Planned

Chapter 9

Optimizer Internals, Statistics, Execution Plans, and SQL Tuning

5 lessons

Cost-Based Optimizer, Query Transformation, Join Order, Access Paths, and Cost ModelPlanned lesson · reserved path Chapter09/Lesson1.html

Planned02

DBMS_STATS, Histograms, Column Groups, Incremental Stats, and Stale StatisticsPlanned lesson · reserved path Chapter09/Lesson2.html

Planned03

EXPLAIN PLAN vs Runtime Plans, DBMS_XPLAN, Predicate Information, and Row-Source MetricsPlanned lesson · reserved path Chapter09/Lesson3.html

Planned04

Nested Loops, Hash Joins, Sort Merge Joins, Bloom Filters, Parallel Plans, and Adaptive FeaturesPlanned lesson · reserved path Chapter09/Lesson4.html

Planned05

Cardinality Errors, SQL Profiles/Baselines/Patches, Hints, and Evidence-Driven Plan ControlPlanned lesson · reserved path Chapter09/Lesson5.html

Planned

Chapter 10

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

5 lessons

Parse, Bind, Execute, Fetch; Library Cache, Shared SQL Areas, and Child CursorsPlanned lesson · reserved path Chapter10/Lesson1.html

Planned02

Hard Parse vs Soft Parse, Cursor Sharing, Bind Variables, and SQL Injection DefensePlanned lesson · reserved path Chapter10/Lesson2.html

Planned03

Bind Peeking, Adaptive Cursor Sharing, Histograms, and Skewed PredicatesPlanned lesson · reserved path Chapter10/Lesson3.html

Planned04

Session Cursor Cache, Open Cursors, Parse Storms, and Shared Pool ContentionPlanned lesson · reserved path Chapter10/Lesson4.html

Planned05

Diagnose Cursor Proliferation and Stabilize High-Throughput OLTP SQLPlanned lesson · reserved path Chapter10/Lesson5.html

Planned

Chapter 11

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

5 lessons

PL/SQL Block Structure, Variables, Records, Collections, Control Flow, and ScopePlanned lesson · reserved path Chapter11/Lesson1.html

Planned02

Procedures and Functions, Parameter Modes, Overloading, Determinism, and SQL IntegrationPlanned lesson · reserved path Chapter11/Lesson2.html

Planned03

Packages, Specification vs Body, State, Initialization, Encapsulation, and Editioning AwarenessPlanned lesson · reserved path Chapter11/Lesson3.html

Planned04

Cursors, Bulk Collect, FORALL, Context Switches, and High-Performance Data ProcessingPlanned lesson · reserved path Chapter11/Lesson4.html

Planned05

Exceptions, Error Stacks, Logging, Assertions, and Testable PL/SQL DesignPlanned lesson · reserved path Chapter11/Lesson5.html

Planned

Chapter 12

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

5 lessons

Row/Statement/Compound Triggers, Mutating Tables, Ordering, and Audit PatternsPlanned lesson · reserved path Chapter12/Lesson1.html

Planned02

Native Dynamic SQL, DBMS_SQL, Bind Variables, Identifier Validation, and Injection SafetyPlanned lesson · reserved path Chapter12/Lesson2.html

Planned03

DBMS_SCHEDULER Jobs, Programs, Chains, Credentials, Windows, and Operational ObservabilityPlanned lesson · reserved path Chapter12/Lesson3.html

Planned04

Pipelined/Polymorphic Table Functions and Advanced SQL/PLSQL Integration ConceptsPlanned lesson · reserved path Chapter12/Lesson4.html

Planned05

Design Server-Side APIs with Packages, Privileges, Transaction Boundaries, and Deployment DisciplinePlanned lesson · reserved path Chapter12/Lesson5.html

Planned

Chapter 13

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

5 lessons

CDB Root, PDBs, Application Containers, Common vs Local Users, and ContainersPlanned lesson · reserved path Chapter13/Lesson1.html

Planned02

Create/Open/Close/Save State for PDBs and Service-Based Connection ManagementPlanned lesson · reserved path Chapter13/Lesson2.html

Planned03

PDB Cloning, Snapshot/Refresh Concepts, Unplug/Plug, Relocation, and PortabilityPlanned lesson · reserved path Chapter13/Lesson3.html

Planned04

Resource Management, Isolation, Storage, Security, and Operational Boundaries Across PDBsPlanned lesson · reserved path Chapter13/Lesson4.html

Planned05

Patch, Upgrade, Backup, Recovery, and Monitoring Considerations in Multitenant DeploymentsPlanned lesson · reserved path Chapter13/Lesson5.html

Planned

Chapter 14

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

5 lessons

Redo Log Buffer, Online Redo Logs, Log Groups/Members, Log Switches, and ArchivingPlanned lesson · reserved path Chapter14/Lesson1.html

Planned02

Undo Segments, Retention, Read Consistency, Flashback Dependencies, and Transaction RecoveryPlanned lesson · reserved path Chapter14/Lesson2.html

Planned03

Control Files, SCNs, Checkpoints, Datafile Headers, and Recovery MetadataPlanned lesson · reserved path Chapter14/Lesson3.html

Planned04

Instance Recovery, Roll Forward/Roll Back, Fast-Start Recovery, and MTTR TuningPlanned lesson · reserved path Chapter14/Lesson4.html

Planned05

Diagnose Redo/Checkpoint Pressure, Log File Sync, Log Switch Issues, and Recovery RiskPlanned lesson · reserved path Chapter14/Lesson5.html

Planned

Chapter 15

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

5 lessons

RMAN Architecture, Repository, Channels, Backup Sets vs Image Copies, and IncrementalsPlanned lesson · reserved path Chapter15/Lesson1.html

Planned02

Control File/SPFILE Backups, Archived Logs, Retention Policies, and Recovery Catalog ConceptsPlanned lesson · reserved path Chapter15/Lesson2.html

Planned03

Restore and Recover Databases, Tablespaces, Datafiles, PDBs, and Selected ObjectsPlanned lesson · reserved path Chapter15/Lesson3.html

Planned04

Block Media Recovery, Validation, Corruption Detection, Crosschecks, and Backup OptimizationPlanned lesson · reserved path Chapter15/Lesson4.html

Planned05

Point-in-Time Recovery, Duplicate Database, Restore Drills, RPO/RTO, and Backup SecurityPlanned lesson · reserved path Chapter15/Lesson5.html

Planned

Chapter 16

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

5 lessons

Flashback Query with AS OF SCN/TIMESTAMP and Undo-Dependent Historical ReadsPlanned lesson · reserved path Chapter16/Lesson1.html

Planned02

Flashback Version Query and Transaction Query for Change InvestigationPlanned lesson · reserved path Chapter16/Lesson2.html

Planned03

Flashback Table, Recycle Bin, and Safe Object/Data Recovery WorkflowsPlanned lesson · reserved path Chapter16/Lesson3.html

Planned04

Flashback Database, Flashback Logs, Guaranteed Restore Points, and Operational TradeoffsPlanned lesson · reserved path Chapter16/Lesson4.html

Planned05

Flashback Data Archive, Blockchain/History Concepts, Retention, Compliance, and AuditingPlanned lesson · reserved path Chapter16/Lesson5.html

Planned

Chapter 17

Data Guard, Standby Databases, Broker, and High Availability

5 lessons

Physical Standby Architecture, Redo Transport, Apply, Protection Modes, and RolesPlanned lesson · reserved path Chapter17/Lesson1.html

Planned02

Data Guard Broker Configuration, Health, Switchover, Failover, and Reinstate WorkflowsPlanned lesson · reserved path Chapter17/Lesson2.html

Planned03

Synchronous vs Asynchronous Transport, Far Sync Concepts, Lag, and Network DesignPlanned lesson · reserved path Chapter17/Lesson3.html

Planned04

Active Data Guard Concepts, Read-Only Workloads, Backup Offload, and Licensing AwarenessPlanned lesson · reserved path Chapter17/Lesson4.html

Planned05

Failure Injection, Observer/Fast-Start Failover Concepts, Split-Brain Avoidance, and DR TestingPlanned lesson · reserved path Chapter17/Lesson5.html

Planned

Chapter 18

RAC and Clustered Oracle Concepts

5 lessons

Oracle RAC Architecture, Shared Database, Multiple Instances, Cache Fusion, and GCS/GESPlanned lesson · reserved path Chapter18/Lesson1.html

Planned02

Clusterware, SCAN, VIPs, Services, Instance Affinity, and Client Failover ConceptsPlanned lesson · reserved path Chapter18/Lesson2.html

Planned03

Global Cache Waits, Hot Blocks, Sequence/Index Contention, and Scale-Out Workload DesignPlanned lesson · reserved path Chapter18/Lesson3.html

Planned04

Rolling Maintenance, Instance Failure, Service Relocation, and Operational ResiliencePlanned lesson · reserved path Chapter18/Lesson4.html

Planned05

When RAC Fits vs Data Guard, Sharding, or Application-Level Scaling—and Cost/Complexity TradeoffsPlanned lesson · reserved path Chapter18/Lesson5.html

Planned

Chapter 19

Partitioning, Parallel Execution, Compression, and Very Large Databases

5 lessons

Range, List, Hash, Interval, Composite Partitioning, and Partitioning-Key DesignPlanned lesson · reserved path Chapter19/Lesson1.html

Planned02

Partition Pruning, Partition-Wise Joins, Local/Global Indexes, and Maintenance OperationsPlanned lesson · reserved path Chapter19/Lesson2.html

Planned03

Exchange Partition, Rolling Windows, Bulk Loads, Archiving, and Lifecycle AutomationPlanned lesson · reserved path Chapter19/Lesson3.html

Planned04

Parallel Query/DML/DDL, Degree of Parallelism, PX Servers, Skew, and Resource ConsumptionPlanned lesson · reserved path Chapter19/Lesson4.html

Planned05

Table/Index Compression Concepts, Heat Map/ILM Awareness, and Multi-Terabyte DesignPlanned lesson · reserved path Chapter19/Lesson5.html

Planned

Chapter 20

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

5 lessons

System/Object Privileges, Roles, Administrative Privileges, Definer/Invoker Rights, and Least PrivilegePlanned lesson · reserved path Chapter20/Lesson1.html

Planned02

Profiles, Password Policy, Resource Limits, Proxy Authentication, and Account LifecyclePlanned lesson · reserved path Chapter20/Lesson2.html

Planned03

Unified Auditing, Audit Policies, Fine-Grained Auditing, and Forensic DesignPlanned lesson · reserved path Chapter20/Lesson3.html

Planned04

Virtual Private Database, Fine-Grained Access Control, Redaction Concepts, and Tenant IsolationPlanned lesson · reserved path Chapter20/Lesson4.html

Planned05

TLS/Native Network Encryption, TDE Wallet/Keystore Concepts, Backup Encryption, and Key GovernancePlanned lesson · reserved path Chapter20/Lesson5.html

Planned

Chapter 21

Resource Manager, Workload Governance, Services, and Capacity Control

5 lessons

Database Resource Manager Plans, Consumer Groups, Directives, and CPU/Parallel LimitsPlanned lesson · reserved path Chapter21/Lesson1.html

Planned02

Mapping Sessions to Consumer Groups by Service, User, Module, and Workload ClassPlanned lesson · reserved path Chapter21/Lesson2.html

Planned03

Active Session Pool, Queueing, Undo/Execution Limits, and Runaway Query ControlPlanned lesson · reserved path Chapter21/Lesson3.html

Planned04

Services as Workload Boundaries for RAC/Data Guard/Applications and Operational RoutingPlanned lesson · reserved path Chapter21/Lesson4.html

Planned05

Design Governance for OLTP, Batch, Analytics, Maintenance, and Administrative WorkloadsPlanned lesson · reserved path Chapter21/Lesson5.html

Planned

Chapter 22

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

5 lessons

Dynamic Performance Views for Sessions, SQL, Locks, I/O, Memory, and Instance HealthPlanned lesson · reserved path Chapter22/Lesson1.html

Planned02

Wait Interface, Time Model Statistics, DB Time, DB CPU, and Bottleneck ClassificationPlanned lesson · reserved path Chapter22/Lesson2.html

Planned03

AWR Snapshots/Reports, Baselines, Top SQL, Load Profile, and Licensing AwarenessPlanned lesson · reserved path Chapter22/Lesson3.html

Planned04

ASH, Session-Level History, Blocking Chains, Time-Series Diagnosis, and Incident ReconstructionPlanned lesson · reserved path Chapter22/Lesson4.html

Planned05

SQL Trace/TKPROF, Real-Time SQL Monitoring Concepts, ADDM, and Evidence-Based TroubleshootingPlanned lesson · reserved path Chapter22/Lesson5.html

Planned

Chapter 23

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

5 lessons

SGA/PGA Sizing, Buffer Cache, Shared Pool, Large Pool, Result Cache, and Memory AdvisorsPlanned lesson · reserved path Chapter23/Lesson1.html

Planned02

Physical/Logical I/O, Direct Path, Smart Scan Awareness, Storage Latency, and I/O CalibrationPlanned lesson · reserved path Chapter23/Lesson2.html

Planned03

Latch/Mutex/Enqueue Contention, Hot Blocks, Sequences, ITL, and Concurrency HotspotsPlanned lesson · reserved path Chapter23/Lesson3.html

Planned04

Temp Usage, Sorts, Hashes, Spill Behavior, PGA Work Areas, and Parallel Execution PressurePlanned lesson · reserved path Chapter23/Lesson4.html

Planned05

Benchmarking, Baselines, Capacity Planning, Load Profiles, and Performance Regression TestingPlanned lesson · reserved path Chapter23/Lesson5.html

Planned

Chapter 24

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

5 lessons

Native JSON Storage, SQL/JSON Queries, JSON Relational Duality Concepts, and IndexingPlanned lesson · reserved path Chapter24/Lesson1.html

Planned02

XMLType/XML DB Awareness, Legacy XML Workloads, and Migration BoundariesPlanned lesson · reserved path Chapter24/Lesson2.html

Planned03

Spatial Data Types, Indexing, Geospatial Queries, and Location AnalyticsPlanned lesson · reserved path Chapter24/Lesson3.html

Planned04

Graph Modeling/Analytics Concepts and Integrating Graph with Relational DataPlanned lesson · reserved path Chapter24/Lesson4.html

Planned05

Choose Oracle Converged Features vs Specialized External Platforms Based on Workload EvidencePlanned lesson · reserved path Chapter24/Lesson5.html

Planned

Chapter 25

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

5 lessons

Vector Data Type, Embeddings, Distance Metrics, Similarity Search, and Relational FilteringPlanned lesson · reserved path Chapter25/Lesson1.html

Planned02

Vector Index Concepts, Approximate vs Exact Search, Recall/Latency Tradeoffs, and EvaluationPlanned lesson · reserved path Chapter25/Lesson2.html

Planned03

Hybrid Search Architectures Combining Relational Predicates, Text, JSON, and VectorsPlanned lesson · reserved path Chapter25/Lesson3.html

Planned04

Select AI / Natural-Language-to-SQL Concepts, Governance, Validation, and Prompt/Data SecurityPlanned lesson · reserved path Chapter25/Lesson4.html

Planned05

Production AI Database Design: Embedding Pipelines, Model Drift, Access Control, Cost, and ObservabilityPlanned lesson · reserved path Chapter25/Lesson5.html

Planned

Chapter 26

Sharding, Distributed Database Concepts, and Global Data Placement

5 lessons

Oracle Sharding Architecture, Shard Catalog, Shard Directors, and Sharded TablesPlanned lesson · reserved path Chapter26/Lesson1.html

Planned02

Sharding Keys, Data Distribution, Duplicated Tables, Locality, and Query RoutingPlanned lesson · reserved path Chapter26/Lesson2.html

Planned03

Cross-Shard Queries/Transactions, Consistency, Failure Domains, and Application DesignPlanned lesson · reserved path Chapter26/Lesson3.html

Planned04

Resharding, Scaling, Deployment Topology, Data Sovereignty, and Operational ComplexityPlanned lesson · reserved path Chapter26/Lesson4.html

Planned05

Compare Sharding with RAC, Data Guard, Partitioning, and Application-Level DistributionPlanned lesson · reserved path Chapter26/Lesson5.html

Planned

Chapter 27

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

5 lessons

JDBC, ODP.NET, Python/Node Drivers, Connection Descriptors, Services, and TLSPlanned lesson · reserved path Chapter27/Lesson1.html

Planned02

Connection Pooling, DRCP Concepts, FAN/Application Continuity Awareness, and Session InitializationPlanned lesson · reserved path Chapter27/Lesson2.html

Planned03

Bind Variables, Array/Bulk Operations, Type Mapping, LOB Streaming, and Injection DefensePlanned lesson · reserved path Chapter27/Lesson3.html

Planned04

Transaction Boundaries, Retries, Idempotency, Distributed Transaction Awareness, and Failure SemanticsPlanned lesson · reserved path Chapter27/Lesson4.html

Planned05

ORMs, SQL Visibility, N+1, Pagination, Schema Migrations, and Deployment CoordinationPlanned lesson · reserved path Chapter27/Lesson5.html

Planned

Chapter 28

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

5 lessons

Release Update Patching, OPatch/Datapatch Concepts, Fleet Consistency, and Rollback PlanningPlanned lesson · reserved path Chapter28/Lesson1.html

Planned02

Database Upgrade Planning, Compatibility Parameters, Prechecks, Deprecated Features, and ValidationPlanned lesson · reserved path Chapter28/Lesson2.html

Planned03

Data Pump Export/Import, Transportable Tablespaces, Network Import, and Migration WorkflowsPlanned lesson · reserved path Chapter28/Lesson3.html

Planned04

Online Redefinition, Edition-Based Redefinition Concepts, Expand/Contract, and Lock-Aware DDLPlanned lesson · reserved path Chapter28/Lesson4.html

Planned05

Cross-Platform/Cloud Migration, GoldenGate Awareness, Cutover Rehearsal, and Post-Migration VerificationPlanned lesson · reserved path Chapter28/Lesson5.html

Planned

Chapter 29

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

5 lessons

Define SLOs, Workload Classes, Data Model, Multitenant/HA Choices, Capacity, and Architecture RecordPlanned lesson · reserved path Chapter29/Lesson1.html

Planned02

Implement Schema, PL/SQL APIs, Partitioning/Indexes, Security, Services, and Change AutomationPlanned lesson · reserved path Chapter29/Lesson2.html

Planned03

Tune SQL, Optimizer Statistics, Memory, I/O, Parallelism, and Contention from Diagnostic EvidencePlanned lesson · reserved path Chapter29/Lesson3.html

Planned04

Implement RMAN/PITR, Data Guard, Monitoring, Auditing, Patching, and Incident RunbooksPlanned lesson · reserved path Chapter29/Lesson4.html

Planned05

Run Restore, Switchover/Failover, Corruption, Performance, Security, and Upgrade Drills—and Defend the DesignPlanned lesson · reserved path Chapter29/Lesson5.html

Planned

Keep knowledge open

Help the academy stay free and grow.

If these curricula save you planning time, a small donation supports new lessons, technical review, diagrams, examples, and long-term maintenance.

ETHEthereum / ERC-20 only

0x716c4Ab160C4B66F31a28AE2448BfF68fc3a2ef0

Send only assets compatible with the Ethereum/ERC-20 network. Do not send TRC-20/TRON assets.