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, aGROUP BYand aROW_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.