L2
Get into SQLSELECT, WHERE, data types, operators, NULL · 10 homework questions + NULL lab
L3
Combining Data in SQLJOIN, UNION · AdventureWorks and CRM Sales · 16 solved exercises
L4
Business metrics, CASE WHEN, order of executionGROUP BY, HAVING, conditional aggregation · classwork + 7 homework questions
L5
Subquery, CTE, window functions10 homework questions with CTE maps · window function lab
L6
Built-in functions and SQL optimisationReview of L1–5, CAST, COALESCE, dates, text · function playground