Skip to content

Latest commit

 

History

History
43 lines (28 loc) · 1.33 KB

README.md

File metadata and controls

43 lines (28 loc) · 1.33 KB

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.