ITI Alexandria – SQL Tasks & Solutions

This repository contains a complete collection of SQL labs and solutions completed during the Databases course at ITI Alexandria using Microsoft SQL Server.

📁 Folder Structure

• labs/: Contains 8 lab folders, each representing a separate lab session with SQL tasks and my own answers to each task.
• databases/: Contains .bak backup files for the databases used in each lab, so you can restore them locally on Microsoft SQL Server.

---

🧠 Topics Covered

The labs cover a wide range of topics, progressing from beginner to advanced levels:

📌 Database Fundamentals

• Database Design
• ERD (Entity-Relationship Diagram)
• Database Mapping
• Schema Design

🛠️ SQL Basics

• CREATE, SELECT
• WHERE, LIKE, TOP
• CONSTRAINTS, RULES
• Data Types

🔗 Joins & Queries

• JOIN (INNER, LEFT, RIGHT, FULL)
• GROUP BY, HAVING, Aggregation Functions
• Subqueries
• UNION

🧾 Advanced SQL Features

• SELECT INTO
• Ranking Functions (RANK, DENSE_RANK, ROW_NUMBER)
• MERGE
• Variables, Conditions, Loops

🧰 Database Programming

• Functions (Scalar & Table-Valued)
• Parameters
• Indexes
• Views
• Cursors
• Stored Procedures
• Triggers

---

🔄 How to Use

1. Clone the repository.
2. Restore the databases using the backup files in the databases/ folder.
3. Browse through the labs/ folder to view the SQL tasks and corresponding answers.
4. Run the SQL scripts in Microsoft SQL Server Management Studio (SSMS).

---

⚙️ Tools Used

• Microsoft SQL Server
• SSMS (SQL Server Management Studio)

---

📚 Purpose

This project showcases my learning journey and practical experience with SQL through a structured series of labs at ITI Alexandria. It can serve as a helpful resource for anyone looking to understand SQL through progressively challenging tasks.