Company practice track
Snowflake-style query behavior and data correctness practice
Work through grouped queries, subqueries and rows whose data is missing or shaped differently than expected.
Repository exercises
Search and filter this trackRead the query a caller actually gets
Compare the generated query with the result you expect for a small table.
Handle missing values and edge shapes
Include a null, an empty value or an awkward dimension in the same fixture.
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 hoursmedium