
SQL Practice for Data Analysts: 160 Coding Exercises
Udemy ยท English
About this course
- Language
- English
- Category
- Provider
- Udemy
- Data updated
Most people who say they're learning SQL are really watching someone else write it. The video makes sense, the query looks obvious, and then a blank editor and a real question show up: which customers ordered last quarter but not this one? That's where it falls apart, and it's the exact moment an analyst job or a technical round puts in front of you. This course is built around that moment. It's practice first. You write the queries yourself, inside the coding exercise editor in the course, run them against prepared datasets and get a pass or fail result straight away. If a query returns the wrong rows, you see it immediately, fix it, and run it again. There's no setup, no database to install and no copying code from a video. The exercises come in three tiers, and each tier uses a different business dataset, so you're applying the same logic to new tables rather than memorizing one schema. Beginner, 50 exercises: SELECT, WHERE, ORDER BY, GROUP BY, aggregate functions and your first joins. Intermediate, 50 exercises: multi-table joins, subqueries, CASE statements, window functions, and date and string handling. Advanced, 50 exercises: CTEs, more complex window functions, nested subqueries, query optimization and the kind of open business problems analysts get every week. The beginner tier is where speed comes from. Filtering, sorting and grouping sound simple until you're asked for the top five product categories by revenue, excluding returns, for one region. Doing fifty of these builds the reflexes that the harder tiers rely on, so you stop thinking about syntax and start thinking about the question. Fifty exercises per tier also means you meet each idea in many shapes. You won't write one GROUP BY and move on. You'll group by date parts, by computed categories, with HAVING filters and inside subqueries, until it stops feeling like a separate topic. The intermediate tier is where most people get stuck in real work. Joins return dupliโฆ











