SQL_Practice_challenges

This repository contains SQL mini-projects and challenges completed while learning SQL concepts.
Each file represents a different business scenario demonstrating practical database operations.

---

📂 Projects Included

1. Online Bookstore

• Focus: Triggers, Transactions, and Rollbacks
• Features:
  • Trigger for order deletions
  • Stock management with TCL commands

2. MNC Database

• Focus: Joins, Views, Functions, Stored Procedures
• Features:
  • Employee–Department relationship
  • UNION vs UNION ALL
  • Custom UDF (FullName)
  • Stored Procedure for HR

3. E-commerce Database

• Focus: Sorting and Limiting Results
• Features:
  • Product table
  • ORDER BY and LIMIT for top-priced products

4. University Database

• Focus: Joins, DISTINCT, WHERE, BETWEEN, NULL operations
• Features:
  • Student–Course relationships
  • Multiple join types

5. City Hospital DataBase

• Focus: Table modification and schema operations
• Features:
  • ALTER, RENAME, TRUNCATE, DROP

6. Sales Database

Focus: Aggregate functions
Features:

• SUM, COUNT, AVG, MIN, MAX
• Rounding averages
• Revenue summarization

---

🛠️ Tech Stack

• MySQL Workbench 8.0 CE
• SQL Syntax: DDL, DML, DCL, TCL

---