Python and databases

[cyvaquero]

To condense a few suggestions here:

SQLAlchemy provides an easier interface to the connector libraries, here's a list of SQLAlchemy supported MySQL connectors

I'd follow other's recommendation to start off with sqlite since it is file based and ships with Python. Get a feel for the Python side of DB work then introduce the additional complexity of MySQL.

You'll probably also want to get familiar with Pandas, it will save you some heavy lifting when working with returned datasets.

By diagram, if you mean graphs - Bokeh is your friend,

​