SQL Scholar
Course
About
Previous
For the Haters
RECURSIVE
Next
Set-Aggregate Functions
1
Introduction to SQL
4 modules
What Is SQL?
Your First Query
The Relational Model
Language Structure
2
Basic Syntax
11 modules
SELECT FROM
Use an Alias
Computed Columns
Compute the Hypotenuse
SELECT
WHERE
Palindromes
Operators
More Operators
Car Shopping
Formatting
3
Working With Data
9 modules
NULL
Feeling Lazy
CASE
Sale Prices
Subscribers
ORDER BY
LIMIT
OFFSET
Shop the Sales
4
Multiple Tables
11 modules
JOIN
Get Tweets
Visitor Info
More Join Types
Global Entry
Multiple Joins
Speedy Check-In
Junction Tables
Tweeter Feed
UNION
Group Chat
5
Aggregation
14 modules
GROUP BY
Group by Department
Pages Visited
Implicit Aggregation
Multi-Level Groups
HAVING
Eager Founders
DISTINCT
Diverse Skills
Group Computed Columns
Slugging Average
FILTER
Batting Average
GROUPING SETS
6
Subqueries
12 modules
Table Expressions
Friend Count
Tweeter Features
Common Table Expressions
Value Expressions
Test Scores
Correlated Subqueries
Shortest Tweet
Hottest Tweet
WHERE IN
JOIN LATERAL
Latest Tweets
7
Window Functions
9 modules
What Are Windows?
Curving Grades 1
PARTITION BY
Curving Grades 2
Aggregating Windows
Calculate Median
Frames
Daily ER Visits
Realtime ER Visits
8
Other
3 modules
For the Haters
RECURSIVE
Set-Aggregate Functions
9
Denormalization
3 modules
Arrays
CROSS JOIN
JSON
10
Bonus Challenges
3 modules
Matrix Multiply
Sleep Science
Anagrams
