SQL Medium-Difficulty Datacamp Problems

Master intermediate SQL concepts by solving challenging Datacamp problems, enhancing your data manipulation and analysis skills.

...

Advanced JOINs and Subqueries

Unit 1: Mastering Different JOIN Types

Unit 2: Subqueries: The Query Within

Unit 3: Conditional Logic with CASE WHEN

Aggregate Functions and Data Summarization

Unit 1: Aggregate Functions Deep Dive

Unit 2: Grouping and Filtering Data

Unit 3: String Manipulation in SQL

Window Functions and Common Table Expressions (CTEs)

Unit 1: Introduction to Window Functions

Unit 2: Advanced Window Function Applications

Unit 3: Introduction to Common Table Expressions (CTEs)

Unit 4: Combining CTEs and Window Functions

Data Manipulation and Transaction Control

Unit 1: Data Manipulation with SQL

Unit 2: Transaction Control

Unit 3: SQL Query Optimization