Skip to main content
Moodle
English (en)
Deutsch (de)
English (en)
Français (fr)
You are currently using guest access (
Log in
)
SD202 Databases 2022-2023
Home
Courses
Formation Initiale
SD202-2022
General
Annonces
Annonces
Nouvelles diverses et annonces
Search forums
Search forums
(No announcements have been posted yet.)
Jump to...
Jump to...
Solutions to exercices
slides
SQL language
SQL advanced
SQL exercises
Lab session (only available from inside Télécom)
Solution of exercise 1 (only available from inside Télécom)
Solution of exercise 2 (only available from inside Télécom)
Schema design with Entity-Relationship Diagrams
Functional dependencies and normal forms
Recording of last year's class
Slides query optimization (extended version)
Lab on schema and query optimization
A possible solution to the lab
Final lab assignment
Final lab skeleton (to complete)
Python script for creating the schema in the DB (Windows / MacOS)
Final lab solution
October 2022 exam
October 2022 exam with some answers
October 2021 exam
October 2021 exam with some answers
November 2020 exam, by Maroua Bahri
July 2020 exam, by Maroua Bahri
June 2020 exam (in French), by Guillaume Claret
June 2020 exam (in French), answers, by Guillaume Claret
Solutions to exercices ►