Engineering Atlasby Abhishek Goyal
Course contents

Module 05

Database fundamentals

Choosing and scaling the data layer: transactions, SQL vs NoSQL, indexes, sharding, replication and the structures underneath.

Premium3 free lessons3 topics13 pages4 ready

By the end of this module you can

  • Pick a database type with a reason
  • Explain how an index speeds up a query
  • Shard and replicate without losing data

Choosing a database

Models, guarantees and types.

  1. ACID transactionsLessonPremiumSoon
  2. SQL vs NoSQLLessonPremiumSoon
  3. Database typesLessonPremiumSoon
  4. Database architecturesLessonPremiumSoon

Indexing and scaling

Making it fast and making it big.

  1. Database indexesLessonPremiumSoon
  2. Bloom filtersLessonPremiumSoon
  3. Database shardingLessonPremiumSoon
  4. Data replicationLessonPremiumSoon
  5. Database scalingLessonPremiumSoon

Deep dives

Long reads behind this module.

  1. Databases for system design interviewsDeep dive article · ~85 min readPremium
  2. Reads and writes: how databases store and fetch dataDeep dive article · ~24 min readFree
  3. How search engines workDeep dive article · ~25 min readFree
  4. Concurrency controlDeep dive article · ~14 min readFree