Introduction to SQL Using Google BigQuery
Offered By: LinkedIn Learning
Course Description
Overview
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.
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
Related Courses
Datenmanagement mit SQLopenHPI Programming Cloud Services for Android Handheld Systems
Vanderbilt University via Coursera Getting and Cleaning Data
Johns Hopkins University via Coursera Ruby مدخل إلى برمجة مواقع الإنترنت باستخدام لغة
Rwaq (رواق) MongoDB for .NET Developers
MongoDB University