Overview: Data is stored less and less in files as the amount of data grows more and more these days. Databases, however, can handle large and complex data sets well – either on your computer or in the cloud. Databases include powerful tools to store, search and analyze data sets. In this workshop you will learn how to use one of the most used databases: PostGreSQL.

At the end of the workshop, you will be able to:
•    understand the concept of relational databases
•    import data into a PostGreSQL database
•    query and sort data
•    select subsets of data 
•    treat duplicate entries
•    handle missing information
•    calculate aggregate summaries
•    combine data from different tables
•    familiarize yourself with basic database management

Prerequisites: Having PostgreSQL 17 installed on your computer. The instructor will send you information on how to do so for Mac OS, Windows and Linux. Please make sure to bring your laptop and charger.

Instructor: Dr. Tim Elrick, Faculty Lecturer in the Faculty of Science.