An introduction to databases for young researchers

An introduction to databases for young researchers

  • Day 1
    16/12/2020
    9:00 am - 5:00 pm
  • Day 2
    17/12/2020
    9:00 am - 12:00 pm
  • Day 3
    18/12/2020
    9:00 am - 12:00 pm

Course details

statistics course | level: beginner | register now
for questions related to this event, contact ugent@flames-statistics.com
affiliation: Ghent University


Abstract

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.


Prerequisites

None


Background readings


Fee

PhDs and postdocs of a Flemish university: 0 €
Other academics: 120 €
Non-profit/Social sector: 200 €
Private sector: 400 €


Venue

Ghent University
More information will follow.


Instructor

Antoon Bronselaer


Sign up (price ticket depends on affiliation)

You will receive payment details later from the organiser by email.