Ensimag Rubrique Formation 2022

Data Base Foundation - WMM42E0

  • Volumes horaires

    • CM 18.0
    • TD 18.0
    • TP 4.5

    Crédits ECTS

    Crédits ECTS 3.0


Databases today are essential to every business, corporation and many scientific investigations. They are behind major popular systems as Google or Amazon, they store important data of many kind of companies and they are even key components in research on physics, biology, health and several other fields. Database Management Systems (DBMS) are powerful, but complex, systems for creating and managing large amounts of data efficiently and allowing it to persist over the time. In this course, we shall learn the foundations of DBMS and most important aspects to design and to use relational databases.

Contact Cyril LABBE


The theoretic part covers the following topics: DBMS functionalities, overview of the most common data models, the relational approach (algebra, SQL, normalization, etc.) , transactional support and database design. We study database schema design using the entity-relation model and introduce an algorithm to translate such an abstraction to a normalized relational schema. The pragmatic part of the course is intended to familiarize students with the use of the Standard Query Language, SQL. We also introduce JDBC, the Java API to access
relational databases.


Contrôle des connaissances

L'examen existe uniquement en anglais 

S1 = HomeWork 1/3 + Written exam session 1 2/3
S2 = HomeWork 1/3 + Written exam session 2 2/3 (no catch-up for the homework part)

Session1 = HomeWork 1/3 + Written exam session1 2/3
Session2 = HomeWork 1/3 + Written exam session2 2/3 (no catch-up for the homework part)

Informations complémentaires

Le cours est donné uniquement en anglais EN

Cursus ingénieur->MoSIG->MOSIG - Semester 2
Equipe->Bases de données-Systèmes d'information et connaissance