Dataharvest 2024 - the European Investigative Journalism Conference

Take the next step after dealing with spreadsheets, and learn how to handle large datasets with SQL. Using SQL makes it possible to handle large amounts of data, to safely share data with others, and most importantly, to combine tables together by joining. In this session you will learn how to join tables to find data that exists in both tables or use joining to add information into a table. By attending these sessions the participants will be able to understand when to take the step from Excel to databases and SQL, and how to use SQL to join datasets together in order to find new information. To attend this session the participants should have basic knowledge of working with spreadsheets. All the software necessary will be pre-installed on the school computers. Participants who want to bring their own laptop will need: DB Browser SQLite which can be downloaded from https://sqlitebrowser.org/ for PCs and Macs.