Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Introduction to SQL Using Google BigQuery

via LinkedIn Learning

Go to class Write review
Scrimba Ad

Our career paths help you become job ready faster

Learn More → Coursera Ad

Gain a Splash of New Skills - Coursera+ Annual Just ₹7,999

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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

Reviews

4.8 rating at LinkedIn Learning based on 85 ratings

Start your review of Introduction to SQL Using Google BigQuery

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.