A marketplace app stores orders in PostgreSQL and its order-history page now takes several seconds to load. You find the slow queries, fix the schema and indexes, ship a safe migration and prove the data can be restored.
A database engineer designs, runs and tunes the databases a product depends on. You make data correct, fast to query, backed up and safe to change. In AI products that includes vector search and keeping it consistent with the main data.
Goal: Learn how data is stored and queried, write SQL, design a small schema and protect data with backups.
Before you start
Beginner · 7 weeks
Week 1: What a database is
Tables, rows, columns · Primary and foreign keys · Relational versus document stores in plain words · Vocabulary
Practice: Sketch a schema for a library on paper.
Practice: Sketch a schema for a library on paper.
Common pitfalls
Think first, then reveal
What is a primary key and a foreign key?
Think first, then reveal
Why use transactions?
Think first, then reveal
What does an index do?
Think first, then reveal
Why test restores?
Review the tables for sensible keys, relationships and data types, and note where the schema is fighting the app.
Deciding the tables, keys, relationships and column types that represent the business correctly.
Why this pick
A weak model makes every later query harder and lets inconsistent data in.
What the role must know
Beginner mistake
Core
Operations
Wider
Think first, then reveal
What is a primary key and a foreign key?
Think first, then reveal
Why use transactions?
Think first, then reveal
What does an index do?
Think first, then reveal
Why test restores?
Think first, then reveal
How do you find and fix a slow query?
Think first, then reveal
How do you add a column to a huge table safely?
Think first, then reveal
What are RPO and RTO?
Think first, then reveal
What is the trade-off in approximate vector indexes?
Think first, then reveal
When would you shard and when not?
Think first, then reveal
How do you pick a shard key?
Think first, then reveal
How do you honour a deletion request across derived data?
Think first, then reveal
How do you decide on active-active multi-region?
Build one, measure it and put it on your CV. Each has tools, setup commands and milestones.
CV, portfolio and interview loop checklist →