Start With Serious SQL

Start by building a strong data foundation

Learn SQL best practices as you solve business problems using data from various domains including healthcare, marketing and people analytics.

Develop your SQL skills and complete challenging case studies in a realistic SQL environment and learn how to start your very own project portfolio using GitHub Pages.

All-inclusive lifetime access covers:
  • All course content and case studies with quizzes
  • Growing library of SQL portfolio projects
  • Example SQL interview questions
  • GitHub quick start guide
  • Linux Command Line Interface crash course
  • Personal branding tips and tricks
  • Exclusive career mentoring opportunities

    If you have any issues with payments via PayPal or Stripe - please click here for an alternative GooglePay option!

    For student pricing or any further questions please reach out directly to [email protected]
    • Buy Now $29

    Serious SQL

    Course Curriculum

    • 01

      Introduction

      • Welcome to Serious SQL

      • Course Outline

      • Docker Installation

      • SQL 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

      • [Coming Soon!] Date & Time Conversions

      • [Coming Soon!] Table Indexes & Optimization

      • [Coming Soon!] Data Types & Loading External Data
    • 06

      8 Week SQL Challenge

      • Case Study #1 - Danny's Diner
    • 07

      Bonus Content

      • [Coming Soon!] SQL Interview Questions

      • [Coming Soon!] SQL Case Study Assessments

      • [Coming Soon!] SQL Portfolio Projects

      • Linux Command Line Crash Course

      • GitHub Crash Course

      • [Coming Soon!] Personal Branding Tips