Free course · Programming
Advanced SQL
Joins, windows and the queries that actually answer the question.
5lessons
10quiz questions
5exercises
What you'll be able to do
- Combine tables without producing wrong numbers.
- Learn the most useful thing after joins.
- Write complex queries somebody can read.
- Diagnose and fix slow queries.
- Write SQL that can be relied on.
Course content
- 1 Joins, properly Combine tables without producing wrong numbers.
- 2 Window functions Learn the most useful thing after joins. Sign in to open
- 3 CTEs, subqueries and structure Write complex queries somebody can read. Sign in to open
- 4 Making queries fast Diagnose and fix slow queries. Sign in to open
- 5 Queries in production Write SQL that can be relied on. Sign in to open