Databases: Modeling and Theory – Free course

This course delves into the foundational principles and design aspects of databases, and it can be taken either before or after other courses in the Databases series.In the Relational Algebra section, students will learn about the algebraic query language that serves as the formal foundation for SQL.The Relational Design Theory section offers an in-depth exploration of dependency theory and normal forms in relational databases, providing a well-established theoretical framework for creating robust relational database schemas.The Unified Modeling Language section introduces the data-modeling component of UML and explains how UML diagrams can be translated into relational database schemas.