Advanced SQL

Database Basics

SQL Query Basics

Using Functions

Grouping Data and Computing Aggregates

Using Subqueries

Using the CASE Clause in Interesting Ways

Advanced Query Techniques using Correlated Subqueries

Working with Multiple Tables

Window Functions for Analytics

Difficult Query Challenges