SQL for Journalists

What to do when Excel is not enough to crunch your data and hardcore coding is not your style? SQL is like Excel, but on steroids!

Module 1
This is the first of three workshops that will introduce you to the lingua franca of programming and a popular relational database. You’ll see what SQL does: create a database, import a spreadsheet, and learn about the main ‘select statements’.

Note: Familiarity with Excel is recommended for those wishing to attend.

​Module 2
You’ll learn about the power of the ‘golden query’ through the introduction of functions, filters and analysing data using code for reporting. You’ll also start joining tables.

Note: Familiarity with SQL ‘select statements’ is necessary, and with Excel recommended for those wishing to attend.

​Module 3
Building on SQL 1 and 2, you’ll make tables talk to each other, clean dirty data and update tables.

Note: Familiarity with SQL ‘select statements’ is necessary, and with Excel recommended for those wishing to attend.

*If you are a complete beginner, you should attend classes 1 to 3 as we will be building on knowledge and datasets from class to class. However, if you have experience in SQL you are free to join classes 2 and/or 3.