Web Books

Cover of How to Teach People SQL

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 

    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.