SQL Practice Lab

This repository contains a curated set of SQL practice scripts to strengthen your understanding of relational databases and query writing. It includes schema definitions, data manipulation operations, and analytical queries using SQL concepts such as SELECT, JOIN, GROUP BY, CASE, and more.

---

Folder Structure

• Schema/ — Table creation and schema modification scripts
• Data/ — Insert, update, and delete operations
• Queries/ — Practice queries including joins, aggregations, subqueries, and filtering

---

Topics Covered

• Database schema design and normalization
• Data manipulation (INSERT, UPDATE, DELETE)
• Querying with SELECT
• Joining multiple tables
• Aggregation and grouping
• Subqueries and nested queries
• Conditional logic using CASE
• Sorting, filtering, and limiting results

---

Getting Started

To run these scripts locally:

1. Use any MySQL-compatible environment (MySQL CLI, Workbench, or DBeaver).
2. Run the files in the following order:
   • schema/tables_setup.sql
   • data/insert_data.sql
   • Explore queries in the Queries/ folder

---

---

Visual Output : Terminal Screenshots

Author

Hridya Umesh
GitHub Profile

---