Industry
e-commerce
Skills
data-wrangling
Tools
sql
Learning Objectives
Demonstrate use of JOIN, GROUP BY, and WHERE clause to ensure accurate filtering and calculations.
Demonstrate knowledge of common table expressions (CTEs) to structure and simplify complex queries.
Perform pivot operations to summarize and organize the data
Overview
Prerequisites
- Knowledge of basic SQL concepts like SELECT, WHERE, GROUP BY, HAVING, ORDER BY, and JOIN.
- Understand common SQL functions like `COUNT`, `SUM`, and `DATEDIFF`.
- Know the purpose and use of joins (e.g., INNER JOIN, LEFT JOIN).
- Knowledge of pivoting in SQL.