Are you an EPFL student looking for a semester project?
Work with us on data science and visualisation projects, and deploy your project as an app on top of Graph Search.
Database Management Systems: Fundamentals
This lecture covers the fundamentals of database management systems (DBMS), including the DBMS ecosystem, relational model, entity-relationship diagrams, storage options, data integrity, implementation challenges, durability, and the role of DBMS in modern applications. It also discusses different types of DBMS based on target workloads and data models, as well as the principles of relational model, primary keys, foreign keys, queries, and data manipulation languages. The lecture introduces relational calculus and algebra, explaining their role in retrieving and manipulating data in a relational database.