Databases (2016–2017)

Course material for Databases, jointly taught at ENS and ENS Paris-Saclay.

Course material

  1. Course introduction
  2. Introduction à la gestion de données (Lab, solution)
  3. Logical aspects (slides by Serge Abiteboul)
  4. Requêtes récursives (Lab)
  5. Complexité des langages de requête (TD)
  6. Contraintes & poursuite (TD)
  7. Schema design: Entity–Relationship model (adapted from the Database System Concepts textbook) and normalization theory (adapted from material by AnHai Doan) (TD)
  8. Analyse statique de requêtes (TD)
  9. Vues, provenance, déclencheurs (Lab)
  10. Query processing and optimization (adapted from the Database System Concepts textbook) (Lab, schema)
  11. Storage and indexing (adapted from the Database System Concepts textbook) (TD)
  12. Concurrency and transactions, distributed data management (Serge Abiteboul)
  13. Sécurité des applications Web

References