Learn SQL fundamentals for analytics and query large datasets with Google BigQuery.
6 lessons
Stephanie — Lead Data Scientist @JULO
Ex. GOJEK, UNILEVER.
Work through each lesson in order or jump to a topic you need.
Foundations & core querying
60 min
Get started with core database concepts and how BigQuery works as a cloud data warehouse.
Learn SELECT, WHERE, ORDER BY, and LIMIT to retrieve and filter data accurately.
Analytics SQL
Use GROUP BY with aggregate functions to summarize metrics and answer business questions.
Break complex SQL into manageable parts with subqueries and common table expressions (CTE).
Apply analytic functions for ranking, running totals, and partition-based calculations.
Capstone project
Build an end-to-end SQL analysis project in BigQuery from raw data to actionable insight.