INF 4401 – Introduction To Databases

Portail informatique

Useful Links
Material
- CI1
  
  Introduction And Relational Algebra
  - Slides
    – 1h30
  - Relational Algebra Symbols
  - Exercices
    – 1h30
  - Databases and information systems
  - Types of Databases
  - Relational Algebra
- CI2
  
  SQL 1
  - Slides
    – 1h30
  - Exercices
    – 1h30
  - From relational algebra to SQL
  - SFW queries
  - Set operations
- CI3
  
  SQL 2
  - Slides
    – 1h30
  - Exercices
    – 1h30
  - Homework
  - Joins
  - Grouping and Aggregation
  - Order by and limit
- CI4
  
  Modelisation
  - Slides
    – 1h30
  - Exercices
    – 1h30
  - Entity-relationship diagram
  - Mapping to database schema
- CI5
  
  RDBMS
  - Slides
    – 1h30
  - Exercices
    – 1h30
  - Data description in SQL
  - Data updates in SQL
  - Constraints
  - Transactions
  - SQL injections
- CI6
  
  NoSQL Databases
  - Slides
    – 1h30
  - Exercices
    – 1h30
  - ACID
  - Ecosystem of NoSQL databases
  - Key-Value Storage
- CI7
  
  Review of Concepts
  - Slides
    – 1h30
  - Review of the concepts in the lecture
  - Solution homework
- CF1
  
  Final Exam

Modalités du contrôle 2021/2022

The grading of INF4401 will follow the criteria:

A final exam that will check the understanding of the key notions. The grade will be on 16.
A homework. The grade will be on two points.
Course attendance. The grade will be on 2 points.

Good luck!