Data Wrangling with SQL

Table of Contents

1. Database Introduction
2. Data Profiling and Preparation before Data Wrangling
3. Data Wrangling on String Data Types
4. Data Wrangling on the DATE Data Type
5. Handling NULL values
6. Pivoting Data Using SQL
7. Subqueries and CTEs
8. Aggregate Functions
9. SQL Window Functions
10. Optimizing Query Performance
11. Descriptive Statistics with SQL
12. Time Series with SQL
13. Outlier Detection