Web Books

How to Teach People SQL

Written by: Matt David
Reviewed by: Blake Barnhill

So you want your company to learn SQL? This book will help you empathize with people learning SQL for the first time. It focuses on the areas where most people get stuck or give up. The book then gives visuals and animations to help people build mental models of the abstract processes behind SQL queries.

  • Introduction

    Introduction about why teaching SQL requires understanding of the audience who is less adept at dealing with abstract ideas

  • Why Databases?

    Databases are better for managing data than spreadsheets when you consider size, accuracy, and security

  • Accessing Data

    Accessing data requires permission to the database, asking questions in SQL, and knowing how to explore a schema.

    JOINs

  • SQL Join Types Explained Visually

    Data within a database exists across multiple tables, JOINs allow you to combine datasets into new tables for analysis. Learn more.

  • Inner Join - Animated

    Visualize how SQL is joining two tables using an Inner JOIN. See animated visualizations of the data being INNER joined in SQL. Learn more.

  • Left & Right Join - Animated

    Visualize how SQL is joining two tables using a Left JOIN and a Right JOIN. See animated visualizations of the data being LEFT and RIGHT joined in SQL. Learn more.

  • Full Outer Join - Animated

    Visualize how SQL is joining two tables using a Full Outer JOIN. See animated visualizations of the data being FULL OUTER joined in SQL. Learn more.

  • Union - Animated

    Visualize how SQL is joining two tables using a Union All join. See animated visualizations of the data being Unioned in SQL. Learn more.

  • Cross Join - Animated

    Visualize how SQL is joining two tables using a Cross Join. See animated visualizations of the data being CROSS JOINed in SQL. Learn more.

    Debugging

  • Syntax Errors

    Learn the most common reasons for SQL errors due to syntax. Spelling errors, Quotation marks, Capitalization, Data Types, and more.

  • 0 Rows Returned

    Learn the most common reasons you will get 0 rows returned from your SQL query. See how JOINs and over filtering may be the problem.

    Advanced

  • How Aggregations Work

    Visualize how SQL aggregates data by viewing examples of COUNT, AVG, and SUM. See animations showing each step of the SQL query.

  • How Subqueries Work

    Visualize how subqueries work in SQL by seeing the intermediate table that is created during the process. See animations showing each step of the SQL query.

  • How CASE WHEN Works

    CASE WHEN is a SQL function that works a lot like IF THEN in other programming languages. Learn to use CASE WHEN in SQL.

  • How Window Functions Work

    Learn how window functions work by looking at gifs that show the process in slow motion. See every step in SQL animated in slow motion. Learn more.

    Appendix

  • Difference between WHERE and ON in SQL

    Understand how filtering and joining can be done in both the ON and WHERE clauses in SQL. Choose the best strategy for JOINing data in SQL.

  • How to Find Outliers with SQL

    Find Outliers quickly with SQL. Detect outliers using simple ORDER BY techniques and using inter quartile range. Learn more.

  • How Regex in SQL Works

    Learn how Regex works in SQL and how to use it in your queries. See the Regex process visualized in gifs. Learn more.