IT Academy - Data Science with Python

S17 T02: SQL Database

Description

• Create database with MySQL.

Level 1

• Exercise 1

  • Create a simple relational database using MySQL (https://www.mysql.com/) and connect it to Python

Level 2

• Exercise 2:
  • Show that you can upload some simple queries to a Pandas Dataframe.

Level 3

• Exercise 3:
  • Generate a graph that summarizes the data.

Targets

• Build a simple relational database with MySQL
• Make simple queries with Pandas and make graphics.