SQL Assignments

This repository contains SQL assignments completed using the AdventureWorks database.

Files

• adnan_1.ipynb - Basic SQL queries covering SELECT statements, filtering with WHERE and LIKE, date functions, and sorting
• Adnan_2.ipynb - Intermediate SQL with JOIN operations, GROUP BY, HAVING clauses, and aggregate functions
• adnan_3.ipynb - Advanced SQL featuring CASE statements, window functions (RANK, NTILE), and ROLLUP operations
• adnan_4.ipynb - Data warehouse queries using dimensional modeling with fact and dimension tables, pivoting, and complex aggregations

Database

All assignments use the Microsoft AdventureWorks sample database (AdventureWorks2014 and ADW data warehouse).

Topics Covered

• Basic SELECT statements and filtering
• JOIN operations (INNER JOIN)
• Aggregate functions and grouping
• Date and string functions
• Window functions and ranking
• CASE statements and conditional logic
• ROLLUP and pivot operations
• Data warehouse dimensional queries