SQL Practice Repository

Welcome to the 01.SQL repository! This repository is designed for SQL enthusiasts, data engineers, and analysts who want to practice and improve their SQL skills using real-world scenarios and datasets.

---

📌 Purpose

The goal of this repository is to provide:

• A structured set of SQL practice exercises from beginner to advanced.
• Hands-on practice with realistic datasets like AdventureWorks 2022.
• Exposure to complex queries, joins, subqueries, stored procedures, indexing, and optimization.
• A reference for common data engineering SQL tasks.

---

🗂 Repository Structure

01.SQL/
├── CTEs/
│   ├── Questions/
│   └── Solutions/
│       ├── 1. Beginner Level/
│       └── 2. Intermediate Level/
│       └── 3. Intermediate Level/
│       └── 4. Expert Level - Data Engineering/

├── StoredProcedures/
│   ├── Questions/
│   └── Solutions/
│       ├── 1. Beginner Level/
│       └── 2. Intermediate Level/
├──UserDefinedFunctions/
│   ├── Questions/
│   └── Solutions/
│       ├── 1. Beginner Level/
│       └── 2. Intermediate Level/
│       └── 3. Advanced Level/
├──WindowFunctions/
│   ├── Questions/
│   └── Solutions/
│       ├── 1. Beginner Level/
│       └── 2. Intermediate Level/
│       └── 3. Intermediate Level/
│       └── 4. Expert Level - Data Engineering/

🛠 Prerequisites

To practice the exercises in this repository, you need:

• MS SQL Server (any edition, preferably 2019 or later)
• SQL Server Management Studio (SSMS) or any SQL client
• AdventureWorks2022 database (or any sample database you prefer)

You can download AdventureWorks from the official Microsoft site: AdventureWorks Sample Databases

---

🚀 How to Use

1. Clone the repository:

git clone https://github.com/anshuldass/01.SQL.git
cd 01.SQL