Aperçu des sections

  • Généralités

  • September 9: Introduction

  • September 16: SQL

  • September 28: SQL lab

    For your first lab session, you will learn about the SQL language by writing some queries on two exercises.
  • October 5: Schema design, normalization, advanced SQL topics

  • POSTPONED: Query evaluation and query optimization

  • October 14: Lab on schema design and query optimization

    This lab requires that you have access to the database. These logins will be distributed at the beginning of the lab. If you are working from home send an email to Louis Jachiet to get a login and password.

  • October 21: Final lab

  • October 28: Exam

    The exam for the SD202 class, which constitutes 100% of your final grade, will take place on Friday, October 28, from 13:30 to 15:30. It will cover all material that we covered together in classes and lab sessions. The exam will be in English. You can choose to answer the questions in English or in French, as you prefer.

    You are allowed three A4 paper sheets (i.e., 6 pages, one on each side) with personal notes of your choice (handwritten or otherwise). Any other material or document is forbidden.

    The exam is strictly personal: any communication or influence between students, or use of outside help, is prohibited. No electronic devices such as calculators, computers, or mobile phones, are permitted. Any violation of the rules may result in a grade of 0 and/or disciplinary action.

    Here are some example exams from the previous years; some of them are in French. Please note that the format of the class has changed from 2021-2022 onwards. Some notions (e.g., relational algebra, 3NF) were only covered in 2020-2021 and before, so will no longer be required. Further, the exam modalities are the ones indicated above and not the ones indicated on these old exams.