SD202 - Créneau D

Slides:

• • Introduction, Databases, Relational Model

    • 1. • MOOC Videos: Introduction to Databases, The Relational Model, Querying Relational Databases, Relational Algebra I and Relational Algebra II.

• • SQL

    • 1. • MOOC Videos: Introduction to SQL, Basic Select Statement, Table Variables, and Set Operators, Subqueries in Where Clause, Subqueries in From and Select Clauses, The Join Family of Operators, Aggregation, Null Values, Data Modification Statements.

• Functional Dependencies and Normal Forms

  • • MOOC Videos: Motivation and overview, Functional Dependencies, Boyce-Codd Normal Form.

• Views

  • • MOOC Videos:  Defining and Using Views, View Modifications Introduction, View Modifications using Triggers, Automatic View Modifications, Materialized Views.

• Entity-Relationship Model

  • •  MOOC Videos:  Entity-Relationship Diagrams.

Labs:

• Install Jupyter: Instructions

• Virtual environment – virtualenv-script.sh

• Or use Colab extension

• TP1 (24/05/2022)

  • Notebook

  • SQL-Zoo 

• TP2 (07/06/2022)

  • Notebook

  • Database: wine.db 

  • Submission (deadline: 13/06/2022 at 11:59pm)

• TP3 (14/06/2022)

  • Notebook

  • Submission (deadline: 20/06/2022 at 11:59pm)

Announcements:

• Posted additional information about the deadline of the labs (2 and 3) and how to submit them.

• 13/06: example exams from previous years will be added later this week.

• 15/06: exams:

  • The exam is strictly personal: any communication or influence between students, or use of outside help, is prohibited. 

  • Course materials on papers only are authorized. 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.