Skip to content

README.md

Latest commit

 

History

History
74 lines (52 loc) · 1.33 KB

README.md

File metadata and controls

74 lines (52 loc) · 1.33 KB

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.