SQL Practice Repository

This repository is created as part of my hands-on learning journey to strengthen database fundamentals, query writing, and data manipulation skills.

📌 What This Repository Contains

This repository includes SQL scripts focused on:

📐 Data Definition Language (DDL)

• CREATE
• ALTER
• DROP
• TRUNCATE
• Table constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL)

🧾 Data Manipulation Language (DML)

• INSERT
• UPDATE
• DELETE
• SELECT

🔍 Querying & Filtering

• WHERE
• ORDER BY
• DISTINCT
• LIMIT
• LIKE
• BETWEEN
• IN

📊 Aggregation & Grouping

• COUNT
• SUM
• AVG
• MIN
• MAX
• GROUP BY
• HAVING

🔗 Joins & Relationships

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL JOIN

⚙️ Subqueries & Nested Queries

• Scalar subqueries
• Correlated subqueries

🎯 Purpose of This Repository

• Practice SQL concepts in a structured way
• Build strong fundamentals for:
• Backend Development

🚀 How to Use

1. Clone the repository:

   git clone https://github.com/hiitarun1/SQL.git
   

Open files in any SQL editor (MySQL Workbench, pgAdmin, DBeaver, etc.)

Execute scripts step by step to understand database behavior

🤝 Contributions

This is a personal learning repository, but suggestions and improvements are welcome. Feel free to fork or raise an issue.