Relational databases for the natural sciences and SQL programming

This short-course will take place in March 2024, at the Dept. of Earth and Environmental Sciences.

Participants must register via the following link: registration form link
Please record your interest in attending the course by 26^th February.

Provisional schedule
4^th March 10 am – 12 noon: lecture 1 AULA F29
7^th March 10 am – 12 noon: lecture 2 AULA F29
12^th March 10 am – 12 noon: lecture 3 AULA G16
14^th March 10 am – 12 noon: lecture 4 AULA F29
20^th March 9 am – 1 pm: practical 1 (bring a laptop PC) AULA H26
21^st March 9 am – 1 pm: practical 2 (bring a laptop PC) AULA F29
25^th March 9 am – 1 pm: practical 3 (bring a laptop PC) AULA F29

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