This short-course will take place in March 2025.

Participants must register via the following link: https://forms.gle/Km1LV3CDqNKpsJND6  
by February 26, 2025
 
Provisional schedule

4^th March 10 am – 12 noon: lecture 1 – ROOM G16
6^th March 10 am – 12 noon: lecture 2 – ROOM F29
11^th March 10 am – 12 noon: lecture 3 – ROOM H25
13^th March 10 am – 12 noon: lecture 4 – ROOM G16
14^th March 9 am – 1 pm: practical 1 (bring a laptop PC) – ROOM F29
18^st March 9 am – 1 pm: practical 2 (bring a laptop PC) – ROOM H25
20^th March 9 am – 1 pm: practical 3 (bring a laptop PC) – ROOM G16

Lectures and practicals will be held at the Department of Earth & Environmental Sciences, Via Ferrata, n. 1.
Details will be provided to registered PhD candidates ahead of the start of the course.

Course description
In this course, students will learn the basic concepts behind relational databases (relational algebra, entity-relationship models), the use of Database Management Systems, and principles of coding using Structured Query Language. The practical will focus on the development, population and interrogation of bespoke SQL databases designed to match data requirements for the specific PhD projects of the attendees. The use of SQL for querying georeferenced data in a GIS environment, and database manipulation in other programming platforms (e.g., R) will also be discussed.
 
Contact
luca.colombera@unipv.it