SQL School Home
About Mode
Playbook
Product
About Mode
Data Sources
Customers
Company
Jobs
Blog
Resources
Sign in
SQL School Table of Contents
In Lesson Order |
By SQL Commands
The Basics
Introduction
Basic Concepts
Retrieving Data From the Database
Filtering Data and Making Simple Calculations
Using Multiple Filters at Once
Ordering Your Results
Intermediate
Summary Statistics: Using SQL to Replace Pivot Tables
Aggregating Within Categories
Counting the Unique Values in a Column
Using Conditional Logic to Define New Columns
Introduction to Joins
Inner Joins
Outer Joins
Full Joins and Appending Data
Join Tips and Tricks
Advanced
Data Types
Wrangling Messy Data
Subqueries
Window Functions
Making Queries Run Faster
Tutorial Conclusion
Common Problems
What This Section is All About
Pivoting From Rows to Columns
Pivoting From Columns to Rows