Relational databases for the natural sciences and SQL programming
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
4th March 10 am – 12 noon: lecture 1
6th March 10 am – 12 noon: lecture 2
11th March 10 am – 12 noon: lecture 3
13th March 10 am – 12 noon: lecture 4
14th March 9 am – 1 pm: practical 1 (bring a laptop PC)
18st March 9 am – 1 pm: practical 2 (bring a laptop PC)
20th March 9 am – 1 pm: practical 3 (bring a laptop PC)
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