knaxuslearn · build · ship

Roadmaps / Data / Week 0: Prerequisites

Read first

Week 0: Prerequisites

Ten hours. Skip any item you can already do.

  • SQL: write a query with a JOIN, a GROUP BY and a ROW_NUMBER() window function.
  • Python: read a CSV with a library, filter rows and write a JSON file.
  • Tools: start Postgres and Kafka in Docker and connect to each.
  • Git: commit, branch, merge and resolve one conflict.
  • Files: open a CSV and a Parquet file in DuckDB and compare their sizes.