Category

🗄️ Databases

Modeling, indexing, storage engines, scaling and caching.

Fundamentals

01Relational vs NoSQL 02SQL Basics 03Transactions and ACID 04Database Migrations

Modeling

01Normalization and Denormalization 02Schema Design and Data Modeling 03Relationships 04Primary and Foreign Key Constraints 05JSON in SQL and NoSQL

Indexing & Storage

01Database Indexes 02B-Tree 03LSM Trees and SSTables 04Query Optimization 05N+1 Query Problem

Caching

01Redis 02Memcached 03Redis vs Memcached 04Caching Strategies 05Cache Invalidation 06Cache-Aside, Write-Through, Write-Behind 07TTL (Time to Live) 08Distributed Caching

Scaling

01Database Partitioning 02Replication 03Sharding 04Regional Partitioning