SQL With MySQL - Mam Shradha's Complete Course 🚀

This repository contains my complete SQL learning journey based on Shradha MAm(Apna college) SQL using MySQL course taught at #Apnacollege e-learning platform(youtube channel).
I have covered all the major SQL concepts, created notes, and solved various practice questions to strengthen my knowledge.

⚡ This is part of my Data Science & Ai, where I'm building strong foundations in databases and data querying.

---

📚 Topics Covered

✅ Basic SQL Syntax
✅ Data Types
✅ Creating Databases and Tables
✅ Inserting Data
✅ SELECT Statement
✅ WHERE Clause
✅ ORDER BY
✅ LIMIT
✅ Aggregate Functions (SUM, AVG, MIN, MAX, COUNT)
✅ GROUP BY
✅ HAVING Clause
✅ Aliases
✅ Logical Operators (AND, OR, NOT)
✅ BETWEEN, IN, LIKE, IS NULL
✅ UPDATE Statement
✅ DELETE Statement
✅ ALTER TABLE
✅ DROP and TRUNCATE
✅ JOINS (INNER, LEFT, RIGHT, FULL OUTER ,SELF AND EXCLUSIVE JOIN)
✅ Subqueries
✅ Views
✅ Indexing
✅ Constraints (PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE, CHECK)
✅ SQL Functions (String, Date, Numeric)
✅ SQL Safe Updates
✅ Practice Problem Sets
✅ Real-world Scenarios & Interview Questions

---

📁 What's Inside?

• Learning-SQL.sql → All concepts with examples
• Practice-Questions.sql → Practice problems and solutions
• SQL-Notes.pdf → Notes of entire course in PDF format

---

🎯 Purpose of this Repository

This repository is created as part of my Ai and data Science journey, where SQL plays a key role in:

• Handling and exploring structured data efficiently
• Writing powerful queries to answer real-world questions
• Strengthening database fundamentals for ML projects
• Preparing for internships and interviews

---

🛠 Tools Used

• MySQL Server
• MySQL Workbench
• Visual Studio Code (for editing .sql files)

🤝 Connect With Me

If this repo helped you or you want to connect, feel free to reach out!
LinkedIn: https://linkedin.com/in/theadeelahmed GitHub: https://github.com/theadeelahmed

---

⭐ Don’t forget to star the repository if you find it helpful!