Learn SQL for Data Analysis with Google Big Query

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Setting up your Sandbox Account

Lecture 3: EXERCISE – Sandbox Account

Lecture 4: Add your first Dataset

Lecture 5: EXERCISE – Your First Data Set

Lecture 6: Explore Tables & Column Data Types

Lecture 7: EXERCISE – Data Types

Lecture 8: Exploring Tables

Chapter 2: Retrieve the data you need with the SELECT Statement

Lecture 1: SELECT with single & multiple columns

Lecture 2: EXERCISE – Selecting Single & Multiple Columns

Lecture 3: SELECT with EXCEPT

Lecture 4: EXCERCISE – SELECT with EXCEPT

Lecture 5: Query History & Saving Queries – Find your queries again

Lecture 6: EXERCISE – Query History & Saving Queries

Chapter 3: Filter the data you need with the WHERE Statement

Lecture 1: WHERE statement with Integers

Lecture 2: EXERCISE – Where statement with integers

Lecture 3: ORDER BY to order your results

Lecture 4: EXERCISE – ORDER BY

Lecture 5: WHERE statement with Dates

Lecture 6: EXERCISE – WHERE statement with Dates

Lecture 7: WHERE statement with boolean values (True/False)

Lecture 8: EXERCISE – WHERE with boolean values

Lecture 9: AND – to combine your filters

Lecture 10: EXERCISE – using AND

Lecture 11: OR – to combine your filters

Lecture 12: EXERCISE – OR

Lecture 13: BETWEEN – to combine your filters

Lecture 14: EXERCISE – BETWEEN

Lecture 15: IN – to filter on multiple values

Lecture 16: EXERCISE – IN

Lecture 17: WHERE statement with strings (text)

Lecture 18: EXERCISE – WHERE with text

Lecture 19: LIKE – filter for strings

Lecture 20: EXERCISE – LIKE

Lecture 21: WHERE statement with strings – handling case sensitivity

Lecture 22: NULL

Lecture 23: NOT – filter

Lecture 24: WHERE – Summary

Chapter 4: Calculate more metrics with Aggregate Analytical Functions

Lecture 1: COUNT() – to count number or rows or values

Lecture 2: COUNT() with DISTINCT

Lecture 3: SUM() AND AVG() – To calculate the sum and average

Lecture 4: MIN() and MAX()

Lecture 5: VAR() & STD_DEV()

Chapter 5: GROUP BY

Lecture 1: GROUP BY statement

Lecture 2: GROUP BY & ORDER BY

Lecture 3: GROUP BY multiple columns

Lecture 4: GROUP BY & ORDER BY 1,2,3

Lecture 5: HAVING & GROUP BY

Chapter 6: JOIN tables together

Lecture 1: JOINING tables

Lecture 2: Aliasing Tables

Lecture 3: LEFT JOIN

Chapter 7: Create new Columns with Single Line Functions

Lecture 1: IF() Function

Lecture 2: CASE function

Chapter 8: EXPORT your data

Lecture 1: Exporting to Google Drive or .csv

Lecture 2: Export to Google Data Studio