This is Serious SQL
Start your guided data apprenticeship today
Now powered by Google BigQuery!
Course Curriculum
Welcome to Serious SQL
Course Outline
BigQuery Environment Setup
Select & Sort Data
Record Counts & Distinct Values
Identifying Duplicate Records
Summary Statistics
Distribution Functions
Summary
Health Analytics Mini Case Study
Case Study Quiz
Case Study Introduction
Case Study Overview
Understanding the Data
SQL Reverse Engineering
Introduction to Table Joins
Joining Multiple Tables
SQL Problem Solving
Window Functions
Final SQL Scripting Solution
Marketing Analytics Quiz
Optional Window Functions Quiz
Case Study Overview
Understanding the Data
Creating Reusable Data Assets
Snapshot and Historic Data
Final Case Study Solution
Quiz 1: Current Employee Analysis
Quiz 2: Employee Churn
Quiz 3: Management Analysis
String Transformations
Date & Time Conversions
Week 1 - November 20th 2021
Week 2 - November 27th 2021
Week 3 - December 4th 2021
Week 4 - December 11th 2021
Week 5 - January 29th 2022
Week 6 - February 5th 2022
Week 7 - February 12th 2022
Week 8 - February 26th 2022
Week 9 - March 5th 2022
Week 10 - March 20th 2022
Case Study #1 - Danny's Diner
Case Study #2 - Pizza Runner
Case Study #3 - Foodie-Fi
Case Study #4 - Data Bank
Case Study #5 - Data Mart
Case Study #6 - Clique Bait
Case Study #7 - Balanced Tree
Case Study #8 - Fresh Segments
Linux Command Line Crash Course
GitHub Crash Course