Welcome to the SQL Projects repository! This collection showcases various SQL projects designed to practice and demonstrate data manipulation, analysis, and reporting using structured query language (SQL).
- Hands-on SQL queries across real-world datasets
- Problem-solving through subqueries, joins, CTEs, and window functions
- Data cleaning and transformation tasks
- Exploratory Data Analysis (EDA) using SQL
- Mini case studies & business scenarios
- SELECT, WHERE, GROUP BY, ORDER BY
- JOIN operations (INNER, LEFT, RIGHT, FULL OUTER)
- Subqueries & Common Table Expressions (CTEs)
- Aggregation and filtering
- Window functions (RANK, ROW_NUMBER, etc.)
- Working with time and date functions
- Creating and modifying tables