SQL DQL Portfolio – AdventureWorks2019

This repository contains my SQL practice from the Relational Models course, using the AdventureWorks2019 database.
The exercises cover a wide range of SQL topics, progressively organized into practical assignments.

---

📚 Contents

• Practice 1 – Basic Functions
  Introductory queries with filtering, aggregation, and scalar functions.

• Practice 2 – JOINS
  Inner, left, right, and full joins across different tables.

• Practice 3 – Subqueries
  Nested queries, correlated subqueries, and query optimization.

• Practice 4 – Common Table Expressions (CTEs)
  Use of CTEs for modular and readable query design.

• Practice 5 – Window Functions
  Ranking, partitioning, and advanced analytics with window functions.

• Additional Topics

  • Temporal data
  • Spatial data
  • Grouping sets, rollup, and cube operators
  • Case expressions and conditional logic

---

🛠️ Tech Stack

• Database: SQL Server (AdventureWorks2019)
• Language: SQL (DQL, DML)
• Focus: Data querying, relational models, and analytical queries

---

🎯 Purpose

This repository serves both as documentation of the Relational Models course and as a portfolio of SQL skills, highlighting practical experience with real-world database structures.