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
- 28 June 2023 16.30–17.30