▦ Mastery Map
Rolling mastery per topic — drives which new cards surface next.
Select & FilterSELECT, DISTINCT, WHERE, IN, BETWEEN, LIKE, NULL
0%0/51 seen
Sort & LimitORDER BY, TOP/LIMIT, OFFSET/FETCH
0%0/77 seen
JoinsINNER/LEFT/RIGHT/FULL, self-join, anti/semi
0%0/58 seen
AggregationGROUP BY, COUNT/SUM/AVG, HAVING, DISTINCT
0%0/54 seen
Case & ConditionalCASE, IIF, COALESCE/ISNULL, NULLIF
0%0/75 seen
Window FunctionsROW_NUMBER, RANK, LAG/LEAD, running totals
0%0/97 seen
CTEs & SubqueriesWITH, correlated subqueries, EXISTS, recursive
0%0/95 seen
Date & TimeDATEPART/DATEADD/DATEDIFF, period grouping
0%0/70 seen
String & TextLEN/LEFT/SUBSTRING/CHARINDEX, STRING_AGG
0%0/79 seen
Pivot & Reshapeconditional aggregation, PIVOT/UNPIVOT, long↔wide
0%0/81 seen
Set Ops & CleaningUNION/INTERSECT/EXCEPT, dedup, data quality
0%0/77 seen