SQL Queries Lab

A personal collection of SQL queries, relational database models, and data analysis projects. This repository serves as a hands-on environment for exploring complex SQL concepts and business logic.

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 - data dictionary and README.md

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.