Overview
-
Test your SQL skills with these code challenges.
Syllabus
-
Introduction
- Up for a code challenge?
- Column selection
- Filtering rows from data
- Removing duplicate data
- Sorting and grouping query results
- Inner joins
- Outer and cross joins
- Set theory for SQL joins
- Using OVER and PARTITION BY statements
- Filtering and subsetting data
- Using CASE and WHEN statements
- Calculating moving window average
- Partitioning dates with the DATE_PART function
- Text formatting and pattern matching
- Using COALESCE to replace null values
- Sorting with regular expressions
