Prerequisites

Learners should have completed introductory lessons on:

• The Unix Shell
• Programming with Python
• SQL (creating tables, inserting data, aggregation, joins)

Software

For this course you will need the UNIX shell, plus SQLite3 on the command line.

If you are running Linux, you may already have SQLite3 installed, otherwise you should be able to get it from your package manager (on Debian/Ubuntu, you can use the command apt install sqlite3).

Files

Please download the files we’ll be using: mpTwitterAndBiblio.zip

Shell and Python

The second part of the lesson requires the Python programming language (Version 3.5 or greater) and access to a command-line interface (shell) on your computer. Please refer to the Software Carpentry setup instructions for the Bash shell and Python if you need guidance.