Professor: Luca Colombera

This short-course will take place in November-December 2026

Participants must register via the following link: registration form by 16^th November 2026

Provisional schedule
30^th November 3 pm – 5 pm: lecture 1
2^nd December 3 pm – 5 pm: lecture 2 (bring a laptop PC)
4^th December 3 pm – 5 pm: lecture 3 (bring a laptop PC)
7^th December 3 pm – 5 pm: lecture 4 (bring a laptop PC)
9^th December 2 pm – 6 pm: practical 1 (bring a laptop PC)
11^th December 2 pm – 6 pm: practical 2 (bring a laptop PC)
14^th December 2 pm – 6 pm: practical 3 (bring a laptop PC)

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

Course description
In this short-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 treated.
 
Contact luca.colombera@unipv.it