Start with Serious SQL

Now powered by Google BigQuery!

Learn SQL by doing! Solve multiple realistic end to end case studies and challenging data analytics projects from the following domains:

  • Health analytics
  • Marketing analytics
  • People analytics
  • Financial markets
  • Fast moving consumer goods
  • Digital marketing

    Serious SQL is fully complete and all videos and tutorial content can be accessed on demand.

    Access to mentors from the Data With Danny team and further SQL support is available to all students on our private Discord community.

    Topics Covered

    Cover many core SQL skills and techniques required for data analysis from beginner to advanced levels using the Google BigQuery platform:

  • Where filters and ordering data
  • Group by aggregates
  • Identifying and dealing with duplicate data
  • Common table expressions and subqueries
  • Summary statistics
  • Exploratory data analysis
  • Complex table joins
  • Entity relationship diagrams
  • SQL reverse engineering
  • Data problem solving techniques
  • Window functions
  • Case When Statements
  • Recursive CTEs
  • Cumulative aggregates
  • Simple, weighted and exponential moving metrics
  • Historical vs Snapshot data analysis techniques
  • Temp tables and views
  • String transformations
  • Regular Expressions
  • Datetime manipulation

    Additional Bonus Content

  • Gain familiarity with popular programming tools such as Docker, Markdown, GitHub and the command line interface (CLI)
  • Access to all 8 Week SQL Challenge case studies with further explanations and debugging exercises

    Private Student Community

    Get access to our members only Discord for technical support and participate in valuable community initiatives including:

  • Study groups
  • Regular Q&A town hall broadcasts
  • SQL interview exercises
  • Resume reviews
  • Mock interviews
  • 1:1 mentoring opportunities

    Course Setup

    Get up and running on Google BigQuery in under 5 minutes so you can learn SQL fast!

    For further $20 student discount please reach out directly to [email protected] using your student email or share your student details for verification!
  • Serious SQL

    Course Curriculum

    • 01

      Introduction

      • Welcome to Serious SQL

      • Course Outline

      • BigQuery Environment Setup

    • 02

      Data Exploration

      • Select & Sort Data

      • Record Counts & Distinct Values

      • Identifying Duplicate Records

      • Summary Statistics

      • Distribution Functions

      • Summary

      • Health Analytics Mini Case Study

      • Case Study Quiz

    • 03

      Marketing Analytics Case Study

      • 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

    • 04

      People Analytics Case Study

      • 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

    • 05

      Additional SQL Techniques

      • String Transformations

      • Date & Time Conversions

    • 06

      Serious SQL Live Training

      • 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

    • 07

      8 Week SQL Challenge

      • 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

    • 08

      Bonus Content

      • Linux Command Line Crash Course

      • GitHub Crash Course