This course helps data professionals who can perform simple SQL queries at a small scale to perform those same queries at scale with Google Big Query.
Overview
Syllabus
Introduction
- Kick-start your BigQuery journey
- What you should know
- Introduction to Google BigQuery
- Case study introduction
- Set up BigQuery sandbox
- Loading data into BigQuery
- SELECT statement
- ORDER BY clause
- WHERE clause conditional logic
- WHERE clause BETWEEN and IN
- Fuzzy string matching
- COUNT function
- Calculation functions
- Challenge: Wisdom Pet, quiz 1
- Solution: Wisdom Pet, quiz 1
- GROUP BY clause
- CASE WHEN statements
- COUNTIF function
- PIVOT function
- Challenge: Financial analysis
- Solution: Financial analysis
- Introduction to table joins
- INNER JOIN
- LEFT JOIN
- Challenge: Wisdom Pet, quiz 2
- Solution: Wisdom Pet, quiz 2
- Introduction to window functions
- Ranking functions
- Cumulative metrics
- Moving averages
- Challenge: Wisdom Pet, quiz 3
- Solution: Wisdom Pet, quiz 3
- Next steps
Taught by
Danny Ma
