Databases

Bachelor of Technology (BUT) in Computer Science – 1st Year

Introduction to Databases (2021-2022, 2023-2024)

In this first database module, students learn how to design a relational database from a specification using the MERISE method: Conceptual Data Model (CDM), Logical Data Model (LDM), relational model, introduction to normalization …

The basic concepts of SQL are studied: creation of tables with constraints, INSERT, UPDATE, DELETE and simple SELECT.

We use the database management system PostgreSQL.

This module is related to Project 1.04 where students must design and implement an inventory and sales management database for the business (real or fictitious) of their choice.

Exploitation of a Database (2021-2024)

This second module allows to consolidate the SQL notions seen in the previous semester and to study more complex SELECT queries (aggregation, subqueries…). First notions of PL/pgSQL, the procedural language of PostgreSQL are also seen.

The basics of PostgreSQL database administration are studied: roles, rights, …

In connection with the statistics module, students discover data visualization with the Python library Pandas.

This module is related to Project 2.04 where students have to study and propose graphs to visualize open data of their choice.

Bachelor of Technology (BUT) in Computer Science – 2nd Year

SQL in a Programming Language (2022-2024)

The students continue to learn PL/pgSQL. Some more advanced notions are studied: views, triggers, …

How to manage concurrent accesses to a database and the associated notions (transactions, ACID properties, locks, …) are also seen.

This module also allows to discover the optimization of SQL queries and the indexes.

Quality and beyond Relational (2022-2024)

This module is composed of two parts. In the first part, students study all the main steps for designing a relational database: CDM, LDM, normalization, and schema optimization using denormalization techniques.

In the second part, students are introduced to non-relational databases, discovering the main paradigms of NoSQL and studying the document-oriented database management system MongoDB.

Technical Degree (DUT) in Computer Science – 1st Year

Introduction to Databases (2019-2021)

Similar to the module wit the same name now realized in BUT. The main difference is that we were working with the Oracle database management system.

Technical Degree (DUT) in Computer Science – 2nd Year

Advanced Databases (2021-2022)

Last database module of the old DUT program, this module covers all the notions related to relational databases: database design (MCD, MLD, …), schema quality (normal forms), SQL, PL/SQL, optimization, users and rights management, concurrent accesses.