SQL Data Portfolio

A structured SQL portfolio demonstrating database design, relational modeling, querying, and data manipulation using MySQL.

Repository Structure

=======

🚀 SQL Data Portfolio

A professional SQL portfolio showcasing database design, relational modeling, querying techniques, and data manipulation using MySQL.

---

📂 Repository Structure

sql-data-portfolio/ │ ├── 📁 01_Basics ├── 📁 02_Constraints ├── 📁 03_Select_Queries ├── 📁 04_Data_Modification ├── 📁 05_Projects └── 📄 README.md

🛠 SQL Concepts Covered

🔹 Database Fundamentals

✔ CREATE DATABASE
✔ CREATE TABLE
✔ INSERT INTO
✔ SELECT Queries

🔹 Constraints & Relationships

✔ NOT NULL
✔ UNIQUE
✔ PRIMARY KEY
✔ FOREIGN KEY
✔ DEFAULT
✔ CHECK

🔹 Query Operations

✔ WHERE
✔ ORDER BY
✔ LIMIT
✔ Aggregate Functions
✔ GROUP BY
✔ HAVING

🔹 Data Manipulation

✔ UPDATE
✔ DELETE
✔ ALTER
✔ TRUNCATE
✔ CASCADE

🔹 Advanced SQL

✔ JOINs
✔ Subqueries
✔ Relational Database Design

---

📌 Featured Project

🏢 Company Database Management System

A relational database project implementing:

• Employee & department management
• Table relationships
• Data integrity constraints
• Query-based analysis

---

💻 Tech Stack

• SQL
• MySQL
• Git & GitHub

---

👩‍💻 Author

Varshini A S
Aspiring Data Analyst | SQL Enthusiast

🔗 GitHub: https://github.com/asvarshini