Practice · six topics · runs in your browser
Master problem-solving patterns through practice
SQL & Querying
01
Foundations
02
Summarising Data
03
Combining Data
04
Real-World Data
05
Analytical & Sequence
06
Advanced SQL
Programming for Data (Python)
01
Python fundamentals
02
pandas
03
Cleaning & validation
04
Streams & orchestration
Scenarios
Data Modeling & Storage Design
Questions
- Multiple choice
- Spot the bug
- Predict the behaviour
- Pick the better design
Keys & grainBeing written
Normalised & dimensional modelsBeing written
Slowly-changing dimensionsBeing written
File & table formatsBeing written
Partitioning & clusteringBeing written
Schema evolution & contractsBeing written
Scenarios
Snowflake5 scenarios
Redshift5 scenarios
Iceberg5 scenarios
dbt5 scenarios
Distributed Data Processing
Questions
- Multiple choice
- Spot the bug
- Predict the behaviour
- Pick the better design
Partitioning & shufflesBeing written
SkewBeing written
State & checkpointsBeing written
Event time & watermarksBeing written
Delivery guaranteesBeing written
Scenarios
Spark5 scenarios
Flink5 scenarios
Kafka5 scenarios
Pipeline Orchestration & Reliability
Questions
- Multiple choice
- Spot the bug
- Predict the behaviour
- Pick the better design
Idempotency & retriesBeing written
BackfillsBeing written
Dependencies & schedulingBeing written
Observability & SLAsBeing written
Failure isolationBeing written
Scenarios
Airflow5 scenarios
System & Scenario Judgment
Questions
- Multiple choice
- Spot the bug
- Predict the behaviour
- Pick the better design
Framing an unclear askBeing written
Naming the trade-offsBeing written
Debugging a live incidentBeing written
Cost & capacity estimatesBeing written