Ce Zhang
Data Modelling and Databases — twenty-three lectures from ETH Zürich, 2022.Data Modelling and Databases. Twenty-three lectures in English from ETH Zürich.
Data Modelling and Databases · 23 lectures
Lecture 1: Apollo, the Moon, and a Database
Lecture 2: Relational Model and Relational Algebra
Lecture 3: Relational Calculus, Other Query Languages
Lecture 4: SQL and Known Unknowns
Lecture 5. Views and Recursion
Lecture 6. SQL Hands-on 1 (Data Modelling and Databases 2022)
Lecture 8. Entity Relationship Models
Lecture 7. SQL Hands-on 2 (Data Modelling and Databases 2022)
Lecture 9. Logical Modelling (Data Modelling and Databases 2022)
Lecture 10. Integrity Constraints
Lecture 11. Functional Dependency
Lecture 12. Normal Form (Data Modelling and Databases 2022)
Lecture 13. Multi-value Dependency and More Normal Forms
Lecture 14. Exam Review 1/2 (Data Modelling and Databases 2022)
Lecture 15. Advanced Analytics in DB
Lecture 16. Database Systems (Data Modelling and Databases 2022)
Lecture 17. Buffer Management and Access Methods
Lecture 18. Access Methods and Operator Execution
Lecture 19. Query Optimization
Lecture 20. Transactions and ACID
Lecture 21. Isolation and Locking
Lecture 23. Recovery (Data Modelling and Databases 2022)
Lecture 22. Isolation beyond Locking.