Serious SQL

Your complete SQL learning experience

Learn the fundamentals of SQL data analysis. Solve realistic end-to-end case studies and challenging data projects from the following domains:

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

    Topics Covered

    Cover many core SQL skills and techniques required for data analysis from beginner to advanced levels:

  • 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

    This course consists of detailed technical coding tutorials, a step-by-step setup guide, recorded live training videos and access to the datasets for all case studies.

    Focus on learning fundamental SQL skills and understanding data at a deep level using PostgreSQL 16. Gain hands-on practical experience so you can feel confident solving challenging data problems in any database environment.

    Get access to our members only Discord community for further support.

    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

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

    Serious SQL

    Course Curriculum

    • 01

      Introduction

      • Welcome to Serious SQL (Video)

      • Welcome to Serious SQL

      • Course Outline

      • SQL Environment Setup
    • 02

      Data Exploration

      • Select & Sort Data (Video)

      • Select & Sort Data

      • Record Counts & Distinct Values (Video)

      • Record Counts & Distinct Values

      • Identifying Duplicate Records (Video)

      • Identifying Duplicate Records

      • Summary Statistics (Video)

      • Summary Statistics

      • Distribution Functions (Video)

      • Distribution Functions

      • Summary (Video)

      • Summary

      • Health Analytics Mini Case Study (Video)

      • Health Analytics Mini Case Study

      • Case Study Quiz
    • 03

      Marketing Analytics Case Study

      • Case Study Introduction (Video)

      • Case Study Introduction

      • Case Study Overview (Video)

      • Case Study Overview

      • Understanding the Data (Video)

      • Understanding the Data

      • SQL Reverse Engineering (Video)

      • SQL Reverse Engineering

      • Introduction to Table Joins (Video)

      • Introduction to Table Joins

      • Joining Multiple Tables (Video)

      • Joining Multiple Tables

      • SQL Problem Solving (Video)

      • SQL Problem Solving

      • Window Functions (Video)

      • Window Functions

      • Final SQL Scripting Solution (Video)

      • Final SQL Scripting Solution

      • Marketing Analytics Quiz

      • Optional Window Functions Quiz
    • 04

      People Analytics Case Study

      • Case Study Overview (Video)

      • Case Study Overview

      • Understanding the Data (Video)

      • Understanding the Data

      • Creating Reusable Data Assets (Video)

      • Creating Reusable Data Assets

      • Snapshot and Historic Data (Video)

      • Snapshot and Historic Data

      • Final Case Study Solution (Video)

      • Final Case Study Solution

      • Quiz 1: Current Employee Analysis

      • Quiz 2: Employee Churn

      • Quiz 3: Management Analysis
    • 05

      Additional SQL Techniques

      • String Transformations (Video)

      • String Transformations

      • Date & Time Conversions
    • 06

      Serious SQL Live Training

      • Week 1

      • Week 2

      • Week 3

      • Week 4

      • Week 5

      • Week 6

      • Week 7

      • Week 8

      • Week 9

      • Week 10
    • 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