SQL Exercises Dump Repo

Personal collection of SQL queries and scripts. This repository serves as a scratchpad for data exploration and analysis.

Core Focus

• Relational Mapping: Utilizing INNER, LEFT, and FULL JOINs to integrate complex data entities.
• Aggregations & Analysis: Translating business questions into actionable insights using GROUP BY, HAVING, and summary functions.
• Data Hygiene: Ensuring data quality by identifying and handling NULL values and applying standard formatting.
• Schema Navigation: Working with AdventureWorks and film databases to model real-world analytical workflows.

Technical Details

Environment:

Queries are developed in SQL Server Management Studio (SSMS) using T-SQL.

Organization:

Each project folder contains:

• own scripts/ directory
• database diagram (ERD)
• documentation for context (data dictionary and README.md).

Structure

Structure

Repo	Focus	Description
AdventureWorks	B2C Analytics	Sales analytics, customer demographics, and regional order distributions.
LosFilm	Rental Operations	Movie inventory management, rental lifecycle, and late-fee auditing.