Learning paths
Learning path

Modern Data Stores

Where data lives: OLTP and OLAP, warehouses and lakehouses, NoSQL, streaming, vector databases and how to choose.

8 lessons
How do you want to learn?
  1. Lesson 1

    Start here: Modern Data Stores

    Modern data management encompasses a diverse ecosystem of specialized technologies, ranging from document-based platforms like MongoDB to high-performance analytic engines like ClickHouse.

  2. Lesson 2

    OLTP vs OLAP

    Why transactional (OLTP) and analytical (OLAP) databases are built so differently, from row versus column storage to how each runs queries.

  3. Lesson 3

    Warehouse vs Lake vs Lakehouse

    Warehouses, data lakes and lakehouses compared, and how open table formats like Apache Iceberg and Delta bring database features to files on S3.

  4. Lesson 4

    NoSQL Families

    Modern distributed databases and key-value stores, such as Amazon DynamoDB, Redis, ScyllaDB, MongoDB, PostgreSQL, and Neo4j, utilize diverse architecture patterns and data modeling strategies to achieve high…

  5. Lesson 5

    Streaming and Event-Driven Data

    Modern data architectures increasingly rely on event streaming and change data capture to synchronize and process information across distributed systems.

  6. Lesson 6

    Vector Databases

    How vector databases store and search embeddings, how their indexes trade accuracy for speed, and when Postgres with pgvector is enough.

  7. Lesson 7

    Running Data Stores in Production

    What goes wrong once a database is live: replication, failover, backups and concurrency, and how distributed databases fail in production.

  8. Lesson 8

    Choosing a Data Store

    Modern data architecture requires balancing system stability and operational simplicity against the desire for advanced technical features.

Save to playlist

Manage playlists →

Share