Data Engineering beginner ⏱ 5–7 hours
BigQuery: Google Cloud Data Warehouse
Get hands-on with BigQuery — Google's serverless data warehouse. Load data, run analytical queries, and understand cost management.
BigQueryGoogle CloudSQLData Warehouse
View project on GitHub
What you’ll build
A BigQuery project with real datasets loaded from GCS, analytical queries optimized for cost and performance, and an understanding of BigQuery’s unique architecture (slot-based compute, columnar storage, partitioning).
Skills you’ll practice
- BigQuery dataset and table management
- Loading data from Google Cloud Storage
- Writing performant SQL: partitioning, clustering, materialized views
- Understanding BigQuery pricing and query cost estimation
The full project guide is for members
Join Surfalytics to unlock every step of this project, all other projects, the full course, and the private community.
7-day free trial · Cancel any time