The Centre for Investigative Journalism
The Centre for Investigative Journalism
Menu

Data Journalism: SQL. An Introduction. Hands-on. [B+I]

Hands-on. Intermediate.

Take the next step after interviewing spreadsheets, and learn how to handle large datasets with SQL. SQL allows us to expand the scope of our data-driven work, to safely share data with others, and most importantly, to combine tables together through joining.

In this session you will learn how relational databases work, especially how to join datasets to identify data that exist in both or use joining to add information into a table. Attendees will be able to understand when to take the step from Excel to SQL, and how to use SQL to join datasets together in order to find new information.

To attend this session participants should have basic knowledge of working with spreadsheets.

Technical Requirements

Participants will have to bring their own laptops and download DB Browser SQLite before the session. It can be downloaded from https://sqlitebrowser.org/ for PCs and Macs.

Helena Bengtsson

Helena Bengtsson is the data journalism editor at Gota Media, a regional publishing company in the south of Sweden with 13 local titles. She previously worked as the data journalism editor at Sveriges Television, Sweden’s national television broadcaster, for 27 years and has also served as Editor, Data Projects of the Guardian UK between 2014-2017.
  • 28 June 2023 16.30–17.30
Location: PSH 314
Workshop
Intermediate
Data