Espace du module Bases de Données Avancées (BDD) : cours, TD/TP, ressources et évaluations…
Silberschatz, Korth, Sudarshan — Database System Concepts (McGraw-Hill, 2019)
International reference on DBMS architecture and relational theory.
Connolly, Begg — Database Systems (Pearson, 2014)
Pedagogical progression from data modeling to implementation.
Meier — Introduction pratique aux bases de données relationnelles (Springer, 2005)
Ouvrage clair et progressif, adapté aux premiers cours de modélisation et de SQL.
Elmasri, Navathe — Fundamentals of Database Systems (7e, 2016)
Comprehensive academic coverage of relational theory and design principles.
Gardarin — Bases de données (Eyrolles, 2003)
Classique francophone décrivant l’architecture interne des SGBD.
Open-source RDBMS compliant with SQL standard...
Open-source NoSQL database using JSON/BSON...
This first chapter introduces modern DBMS foundations...
Takeaway: Model and architecture choices drive reliability and performance.
Before the next lecture: Re-read the PDF and note 2–3 questions.
This chapter deepens SQL through two complementary parts: a declarative section focused on analytical queries, and a procedural section introducing SQL/PSM programming. The goal is to master a complete SQL — combining analysis, business logic, and ISO standard compliance.
Focus on advanced declarative SQL: sorting, joins, subqueries, aggregates, windows, and views.
SQL programming (SQL/PSM, blocks, variables, control flow, exceptions, procedures, functions, cursors, triggers).
Main objectives:
Astuce : Conservez un script reset.sql pour réinitialiser le schéma.