Curriculum planned

Stage 03 · NoSQL, Search & Application Data

NoSQL and Distributed Database Fundamentals

A vendor-neutral course on NoSQL and distributed databases covering data models, CAP/PACELC, clocks, replication, quorums, sharding, consensus, conflict resolution, storage engines, indexing, transactions, security, observability, disaster recovery, cloud operations, and principled technology selection.

Browse planned curriculum Back to all courses

25planned chapters

125reserved lesson paths

Beginner → Advancedlearning level

Plannedcourse state

Coverage baselineVendor-neutral distributed-data principles with modern document, key-value, wide-column, graph, search, and cloud patterns

Course brief

Learn the tradeoffs underneath NoSQL products before learning product commands.

This syllabus deliberately separates foundations, data modeling, query behavior, internals, reliability, security, performance, operations, and production design so advanced material is not compressed into generic catch-all chapters.

By the end

You will be able to

Explain availability, consistency, latency, durability, ordering, and partition tolerance without reducing distributed systems to slogans
Choose document, key-value, wide-column, graph, search, cache, or relational approaches from access patterns and invariants
Reason about replication, quorums, partitioning, clocks, consensus, conflicts, transactions, and failure modes
Evaluate storage engines, indexes, compaction, TTL, caching, CDC, security, backup, observability, and cost as one operational system
Design and defend a polyglot data architecture using measurable workload requirements, migration strategy, SLOs, and failure testing

Complete planned syllabus

25 chapters · 125 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 advanced implementation, architecture, operations, reliability, security, tuning, and a production capstone.

Chapter 1

Why NoSQL Exists: Workloads, Scale, Flexibility, and Polyglot Persistence

5 lessons

Relational Databases vs NoSQL: Different Optimization Targets, Not Competing ReligionsPlanned lesson · reserved path Chapter01/Lesson1.html

Planned02

Horizontal Scale, Global Distribution, Flexible Schemas, High Write Rates, and Low-Latency AccessPlanned lesson · reserved path Chapter01/Lesson2.html

Planned03

Operational vs Analytical Workloads and Why One Database Rarely Optimizes Every Access PatternPlanned lesson · reserved path Chapter01/Lesson3.html

Planned04

Polyglot Persistence: Assigning Systems by Invariant, Query Shape, Latency, and OwnershipPlanned lesson · reserved path Chapter01/Lesson4.html

Planned05

Build a Decision Notebook: Workload, Data Volume, Consistency, Availability, Recovery, and Cost RequirementsPlanned lesson · reserved path Chapter01/Lesson5.html

Planned

Chapter 2

Distributed Systems Foundations: Nodes, Networks, Failure, and State

5 lessons

Processes, Nodes, Clusters, Partitions, Replicas, Coordinators, and Client RoutingPlanned lesson · reserved path Chapter02/Lesson1.html

Planned02

Partial Failure: Why a Distributed System Can Be Both Working and Broken at the Same TimePlanned lesson · reserved path Chapter02/Lesson2.html

Planned03

Latency, Timeouts, Retries, Duplicate Work, Backpressure, and the Fallacy of a Reliable NetworkPlanned lesson · reserved path Chapter02/Lesson3.html

Planned04

Failure Domains: Process, Host, Rack, Zone, Region, Provider, and Human OperationsPlanned lesson · reserved path Chapter02/Lesson4.html

Planned05

Define SLOs for Reads, Writes, Freshness, Durability, Recovery, and AvailabilityPlanned lesson · reserved path Chapter02/Lesson5.html

Planned

Chapter 3

CAP, PACELC, and Consistency/Availability Tradeoffs

5 lessons

CAP Precisely: Network Partitions Force a Consistency-or-Availability Choice for Conflicting OperationsPlanned lesson · reserved path Chapter03/Lesson1.html

Planned02

Why CAP Does Not Mean Pick Two During Normal OperationPlanned lesson · reserved path Chapter03/Lesson2.html

Planned03

PACELC: Latency vs Consistency Tradeoffs Even When the Network Is HealthyPlanned lesson · reserved path Chapter03/Lesson3.html

Planned04

Strong, Eventual, Bounded-Staleness, Session, and Tunable Consistency ModelsPlanned lesson · reserved path Chapter03/Lesson4.html

Planned05

Map Business Invariants to the Weakest Consistency Model That Still Preserves CorrectnessPlanned lesson · reserved path Chapter03/Lesson5.html

Planned

Chapter 4

Time, Ordering, Logical Clocks, and Versioning

5 lessons

Why Wall Clocks Are Dangerous: Drift, Skew, NTP, and Cross-Node OrderingPlanned lesson · reserved path Chapter04/Lesson1.html

Planned02

Lamport Clocks and Happens-Before ReasoningPlanned lesson · reserved path Chapter04/Lesson2.html

Planned03

Vector Clocks/Version Vectors and Detecting Concurrent UpdatesPlanned lesson · reserved path Chapter04/Lesson3.html

Planned04

Hybrid Logical Clocks and Practical Time-Aware OrderingPlanned lesson · reserved path Chapter04/Lesson4.html

Planned05

Use Versions, ETags, Timestamps, and Idempotency Keys Without Pretending Time Is PerfectPlanned lesson · reserved path Chapter04/Lesson5.html

Planned

Chapter 5

Replication Patterns: Leaders, Multi-Leader, and Leaderless Systems

5 lessons

Single-Leader Replication: Logs, Followers, Failover, and Read ScalingPlanned lesson · reserved path Chapter05/Lesson1.html

Planned02

Synchronous vs Asynchronous Replication: Latency, Durability, and Data-Loss WindowsPlanned lesson · reserved path Chapter05/Lesson2.html

Planned03

Multi-Leader Replication: Geographic Writes, Conflict Risk, and Topology ComplexityPlanned lesson · reserved path Chapter05/Lesson3.html

Planned04

Leaderless/Dynamo-Style Replication: Coordinators, Replica Sets, Sloppy Quorums, and Hinted HandoffPlanned lesson · reserved path Chapter05/Lesson4.html

Planned05

Choose a Replication Pattern from Write Locality, Failure Tolerance, and Conflict SemanticsPlanned lesson · reserved path Chapter05/Lesson5.html

Planned

Chapter 6

Quorums, Consistency Levels, Read Repair, and Anti-Entropy

5 lessons

Replication Factor, Read Quorum, Write Quorum, and the Meaning of R + W > NPlanned lesson · reserved path Chapter06/Lesson1.html

Planned02

Tunable Consistency: Per-Operation Choices and Their Failure/Latency ConsequencesPlanned lesson · reserved path Chapter06/Lesson2.html

Planned03

Read Repair, Merkle Trees, Anti-Entropy, and Convergence After Missed WritesPlanned lesson · reserved path Chapter06/Lesson3.html

Planned04

Quorum Edge Cases: Network Partitions, Stale Replicas, Failed Coordinators, and TimeoutsPlanned lesson · reserved path Chapter06/Lesson4.html

Planned05

Measure Staleness and Correctness Instead of Treating Consistency Labels as GuaranteesPlanned lesson · reserved path Chapter06/Lesson5.html

Planned

Chapter 7

Partitioning and Sharding: Range, Hash, Directory, and Consistent Hashing

5 lessons

Why Partition Data: Capacity, Throughput, Parallelism, and Failure IsolationPlanned lesson · reserved path Chapter07/Lesson1.html

Planned02

Range Partitioning vs Hash Partitioning: Locality, Skew, and Query RoutingPlanned lesson · reserved path Chapter07/Lesson2.html

Planned03

Consistent Hashing, Token Rings, Virtual Nodes, and RebalancingPlanned lesson · reserved path Chapter07/Lesson3.html

Planned04

Hot Partitions, Hot Keys, Monotonic Identifiers, Celebrity Data, and Write ConcentrationPlanned lesson · reserved path Chapter07/Lesson4.html

Planned05

Resharding, Split/Merge Operations, Online Rebalancing, and Capacity HeadroomPlanned lesson · reserved path Chapter07/Lesson5.html

Planned

Chapter 8

Membership, Failure Detection, Gossip, and Cluster Coordination

5 lessons

Static Membership vs Dynamic Discovery and Service RegistrationPlanned lesson · reserved path Chapter08/Lesson1.html

Planned02

Heartbeats, Phi Accrual and Other Failure Detectors: Suspicion Is Not ProofPlanned lesson · reserved path Chapter08/Lesson2.html

Planned03

Gossip Protocols: Epidemic Membership and Metadata DisseminationPlanned lesson · reserved path Chapter08/Lesson3.html

Planned04

Split Brain, Fencing, Leases, Epochs/Terms, and Avoiding Two Active OwnersPlanned lesson · reserved path Chapter08/Lesson4.html

Planned05

Operational Coordination: Topology Changes, Rolling Maintenance, and Convergence WindowsPlanned lesson · reserved path Chapter08/Lesson5.html

Planned

Chapter 9

Storage Engines: WAL, B-Trees, LSM Trees, Memtables, SSTables, and Compaction

5 lessons

Write-Ahead Logs and Durability Before Mutating Indexed StatePlanned lesson · reserved path Chapter09/Lesson1.html

Planned02

B-Tree/B+Tree Storage: Read Locality, In-Place Updates, and Page ManagementPlanned lesson · reserved path Chapter09/Lesson2.html

Planned03

LSM Trees: Memtables, Immutable Sorted Files, Write Amplification, and Read AmplificationPlanned lesson · reserved path Chapter09/Lesson3.html

Planned04

Compaction Strategies, Tombstones, Bloom Filters, Caches, and Space AmplificationPlanned lesson · reserved path Chapter09/Lesson4.html

Planned05

Choose Storage Behavior by Write Rate, Read Pattern, SSD Characteristics, and RetentionPlanned lesson · reserved path Chapter09/Lesson5.html

Planned

Chapter 10

Key-Value Databases and Data-Structure Stores

5 lessons

Keys as the API: Lookup Semantics, Namespaces, Prefixes, and Atomic Single-Key OperationsPlanned lesson · reserved path Chapter10/Lesson1.html

Planned02

Values as Bytes, Documents, or Data Structures: Modeling Beyond Simple StringsPlanned lesson · reserved path Chapter10/Lesson2.html

Planned03

TTL, Expiration, Eviction, Counters, Conditional Writes, and Compare-and-SetPlanned lesson · reserved path Chapter10/Lesson3.html

Planned04

Caching vs System-of-Record Usage: Durability, Recovery, and Source-of-Truth BoundariesPlanned lesson · reserved path Chapter10/Lesson4.html

Planned05

Use Cases: Sessions, Caches, Feature State, Rate Limits, Idempotency, and CoordinationPlanned lesson · reserved path Chapter10/Lesson5.html

Planned

Chapter 11

Document Databases and Aggregate-Oriented Modeling

5 lessons

Documents, Nested Objects, Arrays, Dynamic Fields, and BSON/JSON-Like RepresentationsPlanned lesson · reserved path Chapter11/Lesson1.html

Planned02

Embed vs Reference: Aggregate Boundaries, Duplication, Update Frequency, and Read LocalityPlanned lesson · reserved path Chapter11/Lesson2.html

Planned03

Document Growth, Size Limits, Large Arrays, Bucketing, and Schema VersioningPlanned lesson · reserved path Chapter11/Lesson3.html

Planned04

Querying Nested Structures, Multikey Indexing, Aggregation Pipelines, and Denormalized ReadsPlanned lesson · reserved path Chapter11/Lesson4.html

Planned05

Model One-to-One, One-to-Many, Many-to-Many, and Event Data with Workload EvidencePlanned lesson · reserved path Chapter11/Lesson5.html

Planned

Chapter 12

Wide-Column Databases and Query-First Partition Design

5 lessons

Partitions, Rows, Clustering Columns, Column Families/Tables, and Sparse DataPlanned lesson · reserved path Chapter12/Lesson1.html

Planned02

Partition Key Design: Distribution, Bounded Partitions, and Single-Partition QueriesPlanned lesson · reserved path Chapter12/Lesson2.html

Planned03

Clustering Order, Time Bucketing, Denormalized Tables, and Query-First ModelingPlanned lesson · reserved path Chapter12/Lesson3.html

Planned04

Tombstones, TTL, Compaction, Repair, and Why Deletes Can Be Operationally ExpensivePlanned lesson · reserved path Chapter12/Lesson4.html

Planned05

Use Cases: Telemetry, Time-Ordered Events, High-Write Services, and Multi-Region WorkloadsPlanned lesson · reserved path Chapter12/Lesson5.html

Planned

Chapter 13

Graph Databases: Property Graphs, Relationships, Traversal, and Path Queries

5 lessons

Nodes, Relationships/Edges, Labels, Properties, and Graph Schema ChoicesPlanned lesson · reserved path Chapter13/Lesson1.html

Planned02

Adjacency, Index-Free Traversal Concepts, and When Relationships Are First-Class DataPlanned lesson · reserved path Chapter13/Lesson2.html

Planned03

Path, Neighborhood, Reachability, Pattern Matching, and Variable-Length TraversalPlanned lesson · reserved path Chapter13/Lesson3.html

Planned04

Supernodes, Dense Graphs, Partitioning Challenges, and Distributed Graph TradeoffsPlanned lesson · reserved path Chapter13/Lesson4.html

Planned05

Use Cases: Identity, Fraud, Recommendations, Networks, Knowledge Graphs, and Dependency AnalysisPlanned lesson · reserved path Chapter13/Lesson5.html

Planned

Chapter 14

Search, Secondary Indexes, Inverted Indexes, and Vector Retrieval

5 lessons

Primary Access Paths vs Secondary Indexes and the Cost of Maintaining Alternate ViewsPlanned lesson · reserved path Chapter14/Lesson1.html

Planned02

Inverted Indexes, Tokens, Analyzers, Relevance, Filters, Facets, and AggregationsPlanned lesson · reserved path Chapter14/Lesson2.html

Planned03

Local vs Global Secondary Indexes in Distributed DatabasesPlanned lesson · reserved path Chapter14/Lesson3.html

Planned04

Vector Embeddings, Approximate Nearest Neighbor Search, HNSW, and Hybrid RetrievalPlanned lesson · reserved path Chapter14/Lesson4.html

Planned05

Choose Database-Native Search vs Dedicated Search/Vector InfrastructurePlanned lesson · reserved path Chapter14/Lesson5.html

Planned

Chapter 15

Access-Pattern-Driven Modeling, Denormalization, and Materialized Views

5 lessons

Start from Queries, Commands, Invariants, Cardinalities, and Change RatesPlanned lesson · reserved path Chapter15/Lesson1.html

Planned02

Denormalization as Precomputed Work: Duplicated Data, Write Fan-Out, and Repair StrategiesPlanned lesson · reserved path Chapter15/Lesson2.html

Planned03

Aggregate Boundaries, Bounded Contexts, and Data Ownership Across ServicesPlanned lesson · reserved path Chapter15/Lesson3.html

Planned04

Materialized Views, Projection Tables, CQRS Read Models, and Eventually Consistent Derived DataPlanned lesson · reserved path Chapter15/Lesson4.html

Planned05

Review a Relational Schema and Redesign It for Document, Wide-Column, and Key-Value WorkloadsPlanned lesson · reserved path Chapter15/Lesson5.html

Planned

Chapter 16

Transactions Beyond One Record: Atomicity, 2PC, Sagas, and Compensation

5 lessons

Single-Key/Single-Document Atomicity and Why It Is So ValuablePlanned lesson · reserved path Chapter16/Lesson1.html

Planned02

Optimistic Concurrency, Compare-and-Set, Lightweight Transactions, and Conditional MutationsPlanned lesson · reserved path Chapter16/Lesson2.html

Planned03

Two-Phase Commit: Coordinator State, Blocking Failure Modes, and Recovery ComplexityPlanned lesson · reserved path Chapter16/Lesson3.html

Planned04

Sagas: Orchestration vs Choreography, Compensating Actions, and Business-Level AtomicityPlanned lesson · reserved path Chapter16/Lesson4.html

Planned05

Design Invariants to Minimize Distributed Transactions Without Pretending They Never MatterPlanned lesson · reserved path Chapter16/Lesson5.html

Planned

Chapter 17

Consensus: Raft, Paxos, Quorums, Terms, Logs, and Linearizable Decisions

5 lessons

What Consensus Solves: Agreement Despite Failures Under Specific AssumptionsPlanned lesson · reserved path Chapter17/Lesson1.html

Planned02

Raft Mental Model: Leaders, Terms, Log Replication, Commit Index, and ElectionsPlanned lesson · reserved path Chapter17/Lesson2.html

Planned03

Paxos Mental Model: Proposers, Acceptors, Ballots, Quorums, and Chosen ValuesPlanned lesson · reserved path Chapter17/Lesson3.html

Planned04

Linearizability, Leader Leases, Fencing Tokens, and Metadata/Control-Plane ConsensusPlanned lesson · reserved path Chapter17/Lesson4.html

Planned05

Distinguish Consensus for Cluster Metadata from Replication of Application DataPlanned lesson · reserved path Chapter17/Lesson5.html

Planned

Chapter 18

Conflict Detection and Resolution: LWW, Merge Logic, CRDTs, and Idempotency

5 lessons

Lost Updates, Concurrent Writes, Duplicate Events, and Retry-Induced ConflictsPlanned lesson · reserved path Chapter18/Lesson1.html

Planned02

Last-Write-Wins: Simple Semantics, Clock Dependence, and Silent Data LossPlanned lesson · reserved path Chapter18/Lesson2.html

Planned03

Application-Level Merge: Domain Rules, Versions, and Human ResolutionPlanned lesson · reserved path Chapter18/Lesson3.html

Planned04

CRDT Foundations: Counters, Sets, Registers, Monotonic State, and ConvergencePlanned lesson · reserved path Chapter18/Lesson4.html

Planned05

Idempotent Commands, Deduplication Windows, Request IDs, and Exactly-Once IllusionsPlanned lesson · reserved path Chapter18/Lesson5.html

Planned

Chapter 19

TTL, Caching, Eviction, Expiration, and Ephemeral Data

5 lessons

Expiration Semantics: Lazy vs Active Expiry and What TTL Means Under ReplicationPlanned lesson · reserved path Chapter19/Lesson1.html

Planned02

Cache-Aside, Read-Through, Write-Through, Write-Behind, and Refresh-Ahead PatternsPlanned lesson · reserved path Chapter19/Lesson2.html

Planned03

LRU, LFU, Random, TTL-Aware Eviction, and Memory PressurePlanned lesson · reserved path Chapter19/Lesson3.html

Planned04

Cache Stampedes, Thundering Herds, Hot Keys, Negative Caching, and Jittered ExpiryPlanned lesson · reserved path Chapter19/Lesson4.html

Planned05

Decide What May Disappear, What Must Survive, and How to Reconstruct Ephemeral StatePlanned lesson · reserved path Chapter19/Lesson5.html

Planned

Chapter 20

Events, CDC, Streams, and Data Synchronization

5 lessons

Change Data Capture from Logs vs Application-Published EventsPlanned lesson · reserved path Chapter20/Lesson1.html

Planned02

Outbox Pattern, Dual-Write Failure, Idempotent Consumers, and Ordering KeysPlanned lesson · reserved path Chapter20/Lesson2.html

Planned03

Event Streams, Consumer Groups, Replay, Retention, and BackpressurePlanned lesson · reserved path Chapter20/Lesson3.html

Planned04

Build Search Indexes, Caches, Warehouses, and Read Models from Change StreamsPlanned lesson · reserved path Chapter20/Lesson4.html

Planned05

Reconciliation Jobs and Anti-Corruption Layers for Long-Lived Data SynchronizationPlanned lesson · reserved path Chapter20/Lesson5.html

Planned

Chapter 21

Security, Identity, Encryption, Multi-Tenancy, and Data Governance

5 lessons

Authentication, Authorization, Roles, Service Identities, and Least PrivilegePlanned lesson · reserved path Chapter21/Lesson1.html

Planned02

TLS in Transit, Encryption at Rest, Key Management, and Client-Side/Field-Level EncryptionPlanned lesson · reserved path Chapter21/Lesson2.html

Planned03

Tenant Isolation by Key, Collection/Table, Database, Cluster, or AccountPlanned lesson · reserved path Chapter21/Lesson3.html

Planned04

Auditing, Data Classification, Retention, Legal Holds, Deletion, and Backup GovernancePlanned lesson · reserved path Chapter21/Lesson4.html

Planned05

Protect Administrative Interfaces, Cluster Metadata, Network Paths, and SecretsPlanned lesson · reserved path Chapter21/Lesson5.html

Planned

Chapter 22

Backup, Restore, Repair, Disaster Recovery, and Durability Engineering

5 lessons

Logical vs Physical Backups, Snapshots, Continuous Backups, and Change-Log ArchivingPlanned lesson · reserved path Chapter22/Lesson1.html

Planned02

Replication Is Not Backup: Operator Error, Corruption, Bad Deployments, and RansomwarePlanned lesson · reserved path Chapter22/Lesson2.html

Planned03

RPO/RTO, Regional Failure, Quorum Loss, Restore Ordering, and Dependency RecoveryPlanned lesson · reserved path Chapter22/Lesson3.html

Planned04

Test Restores, Integrity Checks, Reconciliation, and Repair After Partial RecoveryPlanned lesson · reserved path Chapter22/Lesson4.html

Planned05

Write a Disaster-Recovery Runbook and Prove It with Game-Day ExercisesPlanned lesson · reserved path Chapter22/Lesson5.html

Planned

Chapter 23

Observability, Capacity, Benchmarking, and Performance Engineering

5 lessons

Golden Signals for Databases: Latency, Throughput, Errors, Saturation, and FreshnessPlanned lesson · reserved path Chapter23/Lesson1.html

Planned02

Per-Partition/Shard Metrics, Replication Lag, Queue Depth, Compaction, Cache, and Storage SignalsPlanned lesson · reserved path Chapter23/Lesson2.html

Planned03

Benchmark Workload Shapes, Not Marketing Numbers: Keys, Values, Zipf Skew, Concurrency, and DurabilityPlanned lesson · reserved path Chapter23/Lesson3.html

Planned04

Tail Latency, Coordinated Omission, Warmup, GC, Network, Disk, and Client-Pool EffectsPlanned lesson · reserved path Chapter23/Lesson4.html

Planned05

Capacity Models for Data Size, Replication, Indexes, Headroom, Growth, and Failure ScenariosPlanned lesson · reserved path Chapter23/Lesson5.html

Planned

Chapter 24

Cloud and Managed NoSQL: Autoscaling, Serverless, Global Tables, and Cost

5 lessons

Managed Control Planes vs Self-Managed Data Planes: Responsibility BoundariesPlanned lesson · reserved path Chapter24/Lesson1.html

Planned02

Provisioned Throughput, Autoscaling, Serverless Billing, Storage, Egress, and Request PricingPlanned lesson · reserved path Chapter24/Lesson2.html

Planned03

Global Replication, Multi-Region Writes, Conflict Semantics, and Regulatory Data ResidencyPlanned lesson · reserved path Chapter24/Lesson3.html

Planned04

Backups, Upgrades, Observability, Private Networking, and Vendor-Specific Failure ModesPlanned lesson · reserved path Chapter24/Lesson4.html

Planned05

Model Total Cost of Ownership Including Operations, Lock-In, Migration, and Developer TimePlanned lesson · reserved path Chapter24/Lesson5.html

Planned

Chapter 25

Technology Selection, Migration, Polyglot Architecture, and Capstone

5 lessons

Build a Database Selection Matrix from Queries, Invariants, Latency, Scale, Operations, and SkillsPlanned lesson · reserved path Chapter25/Lesson1.html

Planned02

Avoid Cargo-Cult NoSQL: Recognize Workloads Better Served by Relational DatabasesPlanned lesson · reserved path Chapter25/Lesson2.html

Planned03

Migrate Safely with Dual Reads/Writes, Backfills, CDC, Verification, Cutover, and RollbackPlanned lesson · reserved path Chapter25/Lesson3.html

Planned04

Design a Polyglot Architecture with Explicit Ownership, Synchronization, SLOs, and Failure BoundariesPlanned lesson · reserved path Chapter25/Lesson4.html

Planned05

Capstone: Defend a Distributed Data Architecture Under Partitions, Growth, Incidents, and Cost ConstraintsPlanned lesson · reserved path Chapter25/Lesson5.html

Planned