Workshop: Introduction to PostGreSQL In-Person / Online
翱惫别谤惫颈别飞:听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.
滨苍蝉迟谤耻肠迟辞谤:听Dr. Tim Elrick, Faculty Lecturer in the Faculty of Science.
Registration:
