Espace du module Bases de Données Avancées (BDD) : cours, TD/TP, ressources et évaluations…
The Advanced Databases (BDD) module, offered in Master AI and Master RSD...
فيديو تحفيزي وتعليمي يشرح أفضل طرق الدراسة والتذكّر الفعّال باستخدام تقنيات ذهنية تساعدك على التعلم بذكاء لا بمجهود زائد.
International reference on DBMS architecture and relational theory.
Pedagogical progression from data modeling to implementation.
Ouvrage clair et progressif, adapté aux premiers cours de modélisation et de SQL.
Comprehensive academic coverage of relational theory and design principles.
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).
Integrity constraints (structural and non-structural), their expression in SQL, and triggers.
Main objectives:
