Sign in
Projects
Import a source file
Destination corrections
Imported files
Saved queries
Query history
Working-copy snapshots
25 October–25 December 2026
Build as you learn
Use the same real datasets as your skills grow. This is a starting sequence you can change.
Weeks 1–2 · InspectSELECT, WHERE, ORDER BY, NULL and COUNT. Learn what each row represents.
Weeks 3–4 · StructureImport raw files, choose types, create clean tables and standardize destinations.
Weeks 5–6 · TransformJOIN, GROUP BY, CTEs, duplicate checks and reusable views.
Weeks 7–8 · DeliverSave repeatable queries, test data quality and export to your analysis tools.
Start with a familiar question
SELECT destination, COUNT(*) AS bookings FROM trips WHERE product = 'tripbey_plus' AND event_kind = 'financing' GROUP BY destination ORDER BY bookings DESC;
Data notes
TripBey financing is a booking record, not proof of a completed journey. Payments are separate events. Overdue balances require a confirmed snapshot date and should not be added across months. Source rows without stable identifiers remain flagged.