Introduction
Up for a code challenge?
()
1. SQL Fundamentals
Column selection
()
Filtering rows from data
()
Removing duplicate data
()
Sorting and grouping query results
()
2. SQL Joins
Inner joins
()
Outer and cross joins
()
Set theory for SQL joins
()
3. Writing Complex Queries
Using OVER and PARTITION BY statements
()
Filtering and subsetting data
()
Using CASE and WHEN statements
()
Calculating moving window average
()
4. Data Cleaning with SQL
Partitioning dates with the DATE_PART function
()
Text formatting and pattern matching
()
Using COALESCE to replace null values
()
Sorting with regular expressions
()
Ex_Files_SQL_Data_Sci_Code_Challenges.zip
(463 KB)