SQL Data Science Code Challenges

Test your SQL skills with these code challenges.

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