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