This series of materials is designed to facilitate a three day workshop where students learn the very basics of SQL and Python. At the end of the workshop students will combine the two languages in order query data from SQL then use Python to make charts and perform some basic statistical analysis in Python.
The workshop is fast paced, as such there will be much left to learn about SQL and Python. This is very much a class that gives students "enough knowledge to be dangerous," rather than a complete treatment of the fundamentals of each language.
Anything not labeled an exercise or solution is meant to be introduced as a walkthrough with the instructor, with students generally following along on their own machines. Exercises are meant for individual or small group work.
The minimal and simplest way to do this is:
pip install pandas numpy sqlalchemy psycopg2-binary jupyter matplotlib
Time permitting or depending on the students familiarity with the relevant topics, you may wish for them to create virtual environments. A walkthrough on creating a virtual environment using Python 3.4+'s venv package is included in section 03-python-and-sql