db_mySQL

Creating a database with MySQL and conecting with python

---

$~$

In this project we are going to create a database from scratch using MySQL workbench. In this case we have created a simple database that simulates a library database.

The script to generate the database is attached to this repository

$~$

Once the database is created, the next thing to do is to connect to the database using python. In this project we show how to do it.

$~$

finally we will make some simple queries, and the results will be passed to pandas dataframes.

$~$

Objectives:

---

• learn how to create relational databases

• learn how to connect to a relational database using python.

• Learn how to make queries to the database from python and transform the results into pandas dataframes.

---

Requirements:

• matplotlib==3.5.1
• mysql_connector_repackaged==0.3.1
• palettable==3.3.0
• pandas==1.4.1
• seaborn==0.11.0

$~$ it will also be necessary to run the .SQL script in MySQL workbench