
SQL Coding Practice: 320+ Exercises and Interview Challenges
Udemy ยท English
About this course
- Language
- English
- Category
- Provider
- Udemy
- Data updated
Reading SQL and writing SQL are different skills. You can follow every step of a tutorial, nod along to a JOIN explanation, and still sit in front of an empty editor in a placement test with no idea where to start. The only fix is writing queries, a lot of them, and finding out straight away whether each one is right. That's the whole design of this course. It has 321 coding exercises, organized into 13 levels, and you write every query yourself in the editor built into the course. Each exercise checks your output when you run it. Wrong rows, a missing column or a sort in the wrong direction shows up immediately, so you fix it and run it again. Five short lectures at the start cover how to think before you write a query, the mistakes almost everyone makes, and how to use the course for interview preparation. After that, it's practice. How the levels buildThe first three levels are about getting comfortable. Level 1 has 50 exercises on SELECT, column aliases, DISTINCT and LIMIT, built around a product catalog for an electronics retailer, plus customer, supplier and employee directories. Filtering comes next in Level 2: price ranges, brand lists, LIKE patterns such as names that start with Galaxy or contain Air, and finding customers with no email or phone number. It ends with filtering problems from banking, hospitals, airlines, shipping and hotels, so the same WHERE logic shows up on unfamiliar tables. Sorting and single-row functions fill Level 3: cleaning imported supplier names, building employee initials, stripping hyphens from phone numbers, rounding a loan EMI and working out how many delivery trucks an order needs. Levels 4 to 6 move into reporting. You'll write aggregate queries for KPI summaries, then GROUP BY by department, region and category, then HAVING clauses that stack conditions, such as departments with more than two people and an average above a threshold, or suppliers above a purchase total or with more than two orders. These are thโฆ











