Python & SQL Query Project

Project Overview

This project demonstrates how to execute SQL queries (basic, intermediate, and advanced) in Python to interact with a MySQL database. The project also includes visualizations of the retrieved data wherever applicable.

Features

• Execute basic, intermediate, and advanced SQL queries in Python
• Fetch data from a MySQL database
• Visualize data using Python libraries

Requirements

• Python 3.x
• MySQL Server
• MySQL Connector for Python (mysql-connector-python)
• Visualization Libraries (Matplotlib, Seaborn, etc.)

Installation

1. Clone the repository:

   https://github.com/Amank04/Python_-_SQL.git
   

2. Install the required Python packages:

   pip install -r requirements.txt

3. Set up the MySQL database:

• Update MySQL connection details in the script (host, user, password, database).

Usage

1. Run the Python script:

python 01_Basics.ipynb

python 02_Intermediate.ipynb

python 01_Advanced.ipynb

2. View query results and visualizations as per the script.

Contributing

• Contributions are welcome! Feel free to open an issue or submit a pull request.