INF725

Slides:

• Introduction, Databases, Relational Model

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

• SQL

  • 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 Normalization

  • 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

• TP1: SQLZoo

• TP2:

  • Notebook. Submission

• TP3:

  • Notebook. Submission

• TP4:

  • Notebook. Submission

Exam:

Course materials (on papers ONLY) are authorized.