Start here

Pick the path that sounds like you. Each one mixes reading with shipping, because reading alone doesn't stick.

New to data
Start at the bit

You know a little Python or SQL and want to understand what happens underneath.

  1. Read: Rows, pages and files
  2. Read: SELECT is a scan
  3. Ship: Daily orders including zero days
  4. Ship: Revenue by category
Working with data
Fill the gaps

You write SQL and Python at work. You want the patterns interviews and real pipelines lean on.

  1. Read: Window functions without the magic
  2. Ship: First-response SLA by channel
  3. Ship: Daily open ticket backlog
  4. Read: Generators stream, they don't load
Interview prep
Go straight to hard

You want timed-feeling, realistic problems: sessionisation, SCDs, log replay, vector search.

  1. Ship: Recover a log with a torn final record
  2. Ship: Point-in-time price lookup
  3. Ship: Split a CSV line with quoted fields
  4. Ship: Top-k by cosine similarity