🗄️ SQL for Data Science

This repository is a comprehensive collection of SQL concepts, MySQL queries, database operations, and Python-MySQL integration projects for Data Science.

It is designed to provide a structured learning path from SQL fundamentals to real-world database applications using MySQL and Python.

---

📚 Topics Covered

• Database Creation
• SELECT Statement
• WHERE Clause
• GROUP BY & ORDER BY
• HAVING Clause
• JOIN Operations
• UNION Operations
• String Functions
• Python & MySQL Integration
• CRUD Operations
• Real-world SQL Projects

---

🛠️ Technologies Used

• SQL
• MySQL
• Python
• MySQL Connector for Python
• Spyder IDE

---

📂 Repository Structure

SQL-for-Data-Science/
│
├── MySQL/
│   │
│   ├── 1_Parks_and_Rec_Create_db.sql
│   ├── 2_Select_Statement.sql
│   ├── 3_Where_Statement.sql
│   ├── 4_Group_By_+_Order_By.sql
│   ├── 5_Having_vs_Where.sql
│   ├── 6_Joins.sql
│   ├── 7_Unions.sql
│   ├── 8_String_Functions.sql
│   │
│   └── 9_Python_SQL_Integration/
│       │
│       └── Student_Registration_System/
│           ├── 1_connection.py
│           ├── 2_create_database.py
│           ├── 3_create_table.py
│           ├── 4_insert_sample_data.py
│           ├── 5_Student_registration.py
│           ├── 6_view_database.py
│           ├── Output_Screenshots/
│           └── README.md
│
├── Output_Screenshots/
├── README.md
├── requirements.txt
├── LICENSE
└── .gitignore

---

🚀 Projects Included

🎓 Student Registration System

A command-line application built using Python and MySQL that demonstrates complete database connectivity and CRUD operations.

Features:

• Connect Python with MySQL
• Create a database
• Create tables
• Insert records
• View stored records
• Update existing records
• Delete records
• Simple menu-driven interface

---

🎯 Learning Outcomes

By exploring this repository, you will learn:

• SQL fundamentals
• Writing SQL queries
• Creating and managing databases
• Data filtering and sorting
• Aggregate functions
• GROUP BY and HAVING
• JOIN and UNION operations
• String functions in SQL
• Connecting Python with MySQL
• Performing CRUD operations
• Building database-driven Python applications

---

📌 Requirements

Install the required package:

pip install mysql-connector-python

---

🤝 Contributing

Contributions, suggestions, and improvements are welcome.

If you'd like to improve this repository, feel free to fork it and submit a pull request.

---

📄 License

This project is licensed under the MIT License.

---

⭐ If you find this repository helpful, consider giving it a Star.