Course Roadmap
Last Updated: May 12, 2026
1 min read
0%complete
15 sections136 chapters
The SELECT StatementExercise - SELECT StatementExercise - Filtering with WHEREExercise - BETWEEN and INExercise - LIKE and Pattern MatchingExercise - NULL Handling and COALESCEExercise - CASE WHEN ExpressionsExercise - Sorting and PaginationExercise - DISTINCTExercise - Scalar FunctionsExercise - Date and TimeExercise - Table and Column Aliases
High
Filtering with WHERE
High
BETWEEN and IN
Medium
LIKE and Pattern Matching
Medium
NULL Handling and COALESCE
High
CASE WHEN Expressions
High
Sorting and Pagination
High
DISTINCT
High
Scalar Functions: Strings, Numbers, Dates
Medium
Date and Time
High
Table and Column Aliases
Medium
Aggregate Functions: COUNT, SUM, AVGExercise - COUNT, SUM, AVGExercise - MIN, MAX, and Extreme ValuesExercise - GROUP BY and HAVINGExercise - Advanced GroupingExercise - String and Conditional Aggregation
High
MIN, MAX, and Finding Rows with Extreme Values
High
GROUP BY and HAVING
High
Advanced Grouping: ROLLUP, CUBE, GROUPING SETS
Low
String and Conditional Aggregation
High
Introduction to JoinsINNER JOINExercise - INNER JOINExercise - LEFT JOINExercise - RIGHT JOINExercise - FULL OUTER JOINExercise - CROSS JOINExercise - SELF JOINExercise - LATERAL JOIN and Patterns
High
High
LEFT JOIN
High
RIGHT JOIN
Medium
FULL OUTER JOIN
Medium
CROSS JOIN
Low
SELF JOIN
High
LATERAL JOIN and Join Interview Patterns
Medium