Introduction to SQL Using Google BigQuery

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.

Introduction

• Kick-start your BigQuery journey
• What you should know
• Introduction to Google BigQuery

1. Google BigQuery Setup

• Case study introduction
• Set up BigQuery sandbox
• Loading data into BigQuery

2. Data Exploration

• 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

3. Data Aggregation

• GROUP BY clause
• CASE WHEN statements
• COUNTIF function
• PIVOT function
• Challenge: Financial analysis
• Solution: Financial analysis

4. Table Joins

• Introduction to table joins
• INNER JOIN
• LEFT JOIN
• Challenge: Wisdom Pet, quiz 2
• Solution: Wisdom Pet, quiz 2

5. Window Functions

• Introduction to window functions
• Ranking functions
• Cumulative metrics
• Moving averages
• Challenge: Wisdom Pet, quiz 3
• Solution: Wisdom Pet, quiz 3

Conclusion

• Next steps