Learn to write real SQL queries used daily by data analysts - from basic SELECTs to joins, aggregations, and window functions.
What you will learn
- Write SELECT queries with filtering and sorting
- Join multiple tables correctly
- Use aggregate functions and GROUP BY
- Write window functions for advanced analysis
Requirements
- No prior SQL experience required
- A free database tool (setup guide included)
- Certificate on completion
FAQ
A free, beginner-friendly SQL database with setup instructions provided in lesson one.
No, the setup guide takes about 10 minutes.
It covers the SQL skills most commonly tested in analyst interviews.
- SELECT, WHERE & ORDER BY
- Filtering with multiple conditionsLocked
- Working with NULL valuesLocked
- Inner and outer joinsLocked
- SubqueriesLocked
- Aggregate functions and GROUP BYLocked
- Window functionsLocked
- Common table expressionsLocked
- Real analyst query challengesLocked
Leslie Alexander
Data Analyst
Leslie Alexander has spent 8 years turning messy spreadsheets into decisions for retail and finance teams, and teaches analytics the way she wishes she'd learned it.
Reviews
5.0
1 Review
Youssef Amrani
★★★★★5 days ago
Window functions finally clicked after years of avoiding them.
