Skip to content

    Backend System Design, module B05

    Relational databases and SQL

    The relational model, SQL, indexes, query plans, transactions, MVCC, locking, JPA, migrations and partitioning.

    1 of 14 lessons published

    1. 1
      Databases Basics

      Standard · beginner

    2. 2

      Normalization (1NF to BCNF) and Denormalization (coming soon)

      Standard · beginner

    3. 3

      SQL Joins (coming soon)

      Standard · beginner

    4. 4

      Aggregation, Window Functions and CTEs (coming soon)

      Standard · intermediate

    5. 5

      SQL Indexing: B-Trees, Composite, Covering and Partial Indexes (coming soon)

      Flagship · intermediate

    6. 6

      Query Plans with EXPLAIN ANALYZE (coming soon)

      Flagship · intermediate

    7. 7

      ACID Transactions and Isolation Levels (coming soon)

      Flagship · intermediate

    8. 8

      MVCC: Multi-Version Concurrency Control (coming soon)

      Standard · advanced

    9. 9

      Locking: Optimistic vs Pessimistic and Deadlocks (coming soon)

      Standard · intermediate

    10. 10

      Spring @Transactional (coming soon)

      Standard · intermediate

    11. 11

      JPA and Hibernate: N+1, Lazy Loading and Batching (coming soon)

      Standard · intermediate

    12. 12

      Data Modeling, Schema Evolution and Zero-Downtime Migrations (coming soon)

      Standard · intermediate

    13. 13

      Table Partitioning (coming soon)

      Standard · intermediate

    14. 14

      SQL vs NoSQL: A Decision Framework (coming soon)

      Standard · intermediate

    All Backend System Design modules