YoVDO

Introduction to SQL Using Google BigQuery

Offered By: LinkedIn Learning

Tags

Data Analysis Courses Data Visualization Courses SQL Courses Database Management Courses Data Aggregation Courses Data Exploration Courses Table Joins Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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
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

Taught by

Danny Ma

Related Courses

Datenmanagement mit SQL
openHPI
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