Introduction to database systems, covering conceptual modeling, relational theory, SQL, and modern data architectures including NoSQL systems.
Structure: Fundamentals → Conceptual Model → Relational Model → Practice → Evaluation
Level: Undergraduate / Graduate
Overview of database systems, data organization, and fundamental concepts.
Access materialsEntity–relationship models and high-level database design principles.
Access materialsPractical exercises on entity–association modeling and schema design.
Access materialsCore concepts of relational databases, tables, keys, and integrity constraints.
Access materialsFormal query language for relational databases and theoretical foundations.
Access materialsExtended relational theory and deeper understanding of schema structures.
Access materialsNormal forms and techniques to design efficient and consistent databases.
Access materialsIntroduction to non-relational databases and modern data storage paradigms.
Access materialsHands-on exercises to get started with database systems.
Access materialsPractice problems to master relational algebra queries.
Access materialsIntroduction to databases using SQLite and Python programming.
Access materialsApplication of databases in biological data analysis using Python.
Access materials