Hands-on SQL tutorial

by Dr Alkistis Pourtsidou (Queen Mary University of London)

Wednesday 23 Jan 2019, 16:30 → 17:30 GB

Universe

SQL (Structured Query Language) is used widely in academia and industry to query databases (e.g. to retrieve and manipulate data). This hands-on lecture will introduce the language and work on a “commercial” dataset using the SQLite database engine that comes for free with Python, as well as the Pandas data analysis library. The tutorial, in the form of a Jupyter notebook, is available here: https://github.com/Alkistis/DSI/blob/master/SQL-tutorial-DSI.ipynb Note: if you cannot view it directly via the above link, please go to https://nbviewer.jupyter.org/ and enter the link there.