Introduction to SQL Using Google BigQuery
3h 21mIntermediate2024-01-11
Authors
Danny Ma
Course details
As more and more companies adapt to cloud platforms—which are tailor-made for analytics and machine learning—many companies are also moving away from Amazon Web Services and trying alternative cloud vendors. Google Big Query has been gaining steam in the market in recent years, and provides some game-changing technology in the modern data landscape. In this course, instructor Danny Ma shows data professionals how to be productive and effective using GBQ and use the power of the cloud to analyze data at scale. If you have some SQL experience and want to learn what’s available on a modern cloud platform, join Danny in this course to see how BigQuery can help jumpstart your data career.
Skills covered
SQLIntroduction toDatabase AdministrationData EngineeringDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware Development
Concepts
Introduction
- Kick-start your BigQuery journey
- What you should know
- Introduction to Google BigQuery
Google BigQuery Setup
- Case study introduction
- Set up BigQuery sandbox
- Loading data into BigQuery
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
Data Aggregation
- GROUP BY clause
- CASE WHEN statements
- COUNTIF function
- PIVOT function
- Challenge - Financial analysis
- Solution - Financial analysis
Table Joins
- Introduction to table joins
- INNER JOIN
- LEFT JOIN
- Challenge - Wisdom Pet, quiz 2
- Solution - Wisdom Pet, quiz 2
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