Data engineering and SQL practice
Check how queries group, filter and combine records, then practice writing SQL against a small dataset with missing and repeated events.
Repository exercises
Search and filter this trackCheck the rows a query should return
Create a fixture where filtering before and after grouping yields different results.
Handle missing and awkward data
Include missing values, unexpected shapes and cases where a conversion changes the result.
Take-home projects
Paid plan required to start. Each workspace stays open for 24 hours.
Delivery metrics in SQL
Write a daily SQLite report that handles duplicate delivery scans, orders in flight and regions with zero shipments.
About 2 hoursmediumBike-share trips ETL pipeline
Generate messy trip exports, clean them with documented rules, and load an idempotent SQLite warehouse with a daily summary.
About 4 hoursmediumHousehold energy explorer (data visualisation)
A front-end-only dashboard over a year of half-hourly smart-meter data: zoomable time series, heat map, tariffs and honest gaps.
About 4 hoursmedium
Practice on SQLBolt
Join two tables in your browserStart with an inner join, then compare what the outer join lesson does with unmatched rows.