INF 4401 – Introduction To Databases

The course INF 4401 – Introduction To Databases is a third-year cours in a business school (level Master 2) given at IMT-BS in the internation track. At the end of this course, the student will know what a database is, what the different kinds of databases are, how to work with relational databases and how to code using SQL. In details, a student will know how to:

• Describe data using the relational model.
• Use relational algebra to formally modelize a query on relational data.
• Code in SQL, with basic commands and aggregation.
• Modelize data using the entity-relationship model.
• Manipulate a RDBMS.
• Choose the adequate database kind among relational database and NoSQL alternatives

• Topic
  Content
  Key Notions
• 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