21 Jun Introduction to databases for young Researchers
- 15/12/2021 - 17/12/2021
9:00 am - 12:00 pm
statistics course | level: beginner |
for questions related to this event, contact firstname.lastname@example.org
affiliation: Ghent University
This course provides an introduction to database systems, with an emphasis on relational databases.
The goal of the course is that you are able to (i) read and interpret the structure of a relational database and (ii) interact with it via SQL.
When compared to file-based data storage (e.g., Excel), relational database systems provide many benefits.
They offer many ways to enforce data quality constraints, they allow for complicated structured storage and they enable the answering of potentially very complicated questions.
The duration of the course is two days: one day of theoretical lectures and one day of practical sessions on the Standard Query Language (SQL).
The practical sessions will be spread over two consecutive days, each time in the morning.
This way, afternoons can be spent on self-training.
On the first day, the theoretical foundations of databases in general will be introduced.
We will then dive into the relational model and discuss the relational algebra that acts on this model.
This relational algebra provides the foundations for query languages and is a step-up to SQL.
We will then revise the most important constructs of SQL, which will grant you the ability to resolve rather complicated questions against a relational database.
The lecture will also introduce the important concept of an integrity constraint and we will study some important examples like functional dependencies and inclusion dependencies.
The second day will be spread over two consecutive days and will involve practical sessions where SQL will be the core topic.
To do so, we will use an online platform (Q'exr) that involves different series of questions, each focusing on a specific part of the SQL language.
We will gradually go over all important parts of SQL such as joining, grouping, aggregate functions, filters, window functions, set operators and so on.
The platform allows self-training, so skills can be further trained after the course
PricesPhD's and postdocs of a Flemish university: free
Other academics: €90
Non-profit/Social sector: €150
Private sector: €300