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

      1. Welcome to Serious SQL (Video)

      2. Welcome to Serious SQL

      3. Course Outline

      4. SQL Environment Setup

      1. Select & Sort Data (Video)

      2. Select & Sort Data

      3. Record Counts & Distinct Values (Video)

      4. Record Counts & Distinct Values

      5. Identifying Duplicate Records (Video)

      6. Identifying Duplicate Records

      7. Summary Statistics (Video)

      8. Summary Statistics

      9. Distribution Functions (Video)

      10. Distribution Functions

      11. Summary (Video)

      12. Summary

      13. Health Analytics Mini Case Study (Video)

      14. Health Analytics Mini Case Study

      15. Case Study Quiz

      1. Case Study Introduction (Video)

      2. Case Study Introduction

      3. Case Study Overview (Video)

      4. Case Study Overview

      5. Understanding the Data (Video)

      6. Understanding the Data

      7. SQL Reverse Engineering (Video)

      8. SQL Reverse Engineering

      9. Introduction to Table Joins (Video)

      10. Introduction to Table Joins

      11. Joining Multiple Tables (Video)

      12. Joining Multiple Tables

      13. SQL Problem Solving (Video)

      14. SQL Problem Solving

      15. Window Functions (Video)

      16. Window Functions

      17. Final SQL Scripting Solution (Video)

      18. Final SQL Scripting Solution

      19. Marketing Analytics Quiz

      20. Optional Window Functions Quiz

      1. Case Study Overview (Video)

      2. Case Study Overview

      3. Understanding the Data (Video)

      4. Understanding the Data

      5. Creating Reusable Data Assets (Video)

      6. Creating Reusable Data Assets

      7. Snapshot and Historic Data (Video)

      8. Snapshot and Historic Data

      9. Final Case Study Solution (Video)

      10. Final Case Study Solution

      11. Quiz 1: Current Employee Analysis

      12. Quiz 2: Employee Churn

      13. Quiz 3: Management Analysis

      1. String Transformations (Video)

      2. String Transformations

      3. Date & Time Conversions

      1. Week 1

      2. Week 2

      3. Week 3

      4. Week 4

      5. Week 5

      6. Week 6

      7. Week 7

      8. Week 8

      9. Week 9

      10. Week 10

    About this course

    • $49.00
    • 75 lessons
    • 19 hours of video content