Learn SQL — from SELECT to window functions.

Strive builds a SQL course aimed at your work: analytics, product, engineering, or just learning the language of data. Lessons render real query examples, and a daily recall queue cements the syntax and the joins.

What you’ll learn

• Read and write SELECT, JOIN, GROUP BY, and HAVING with confidence.
• Aggregate, filter, and pivot data without leaving the database.
• Use window functions to rank, partition, and accumulate.
• Reason about indexes and why a query is slow.
• Avoid the common foot-guns: NULL handling, implicit casts, duplicate joins.
• Translate a business question into a query that answers it.

A typical Strive course on SQL

1. SELECT, FROM, WHERE — the literal building blocks4 lessons
2. Joins, set operations, and shape changes5 lessons
3. Aggregations, GROUP BY, and HAVING4 lessons
4. Window functions — rank, partition, lead/lag4 lessons
5. NULLs, casts, and the foot-guns3 lessons
6. Reading EXPLAIN — why is this slow?3 lessons

Demonstration outline — your course is generated around your answers, so module count, depth, and difficulty will differ from this. Across the 6 modules above there are 23 lessons.

Frequently asked