Navigation

19D111PBP - Databases System Design

Course specification
Course title Databases System Design
Acronym 19D111PBP
Study programme Electrical Engineering and Computing
Module Software Engineering
Type of study doctoral studies
Lecturer (for classes)
Lecturer/Associate (for practice)
    Lecturer/Associate (for OTC)
      ESPB 9.0 Status elective
      Condition
      The goal Master the knowledge of designing modern complex databases. Relational and non-relational databases. Complex pipelines of big data streams.
      The outcome Students will master the necessary knowledge to implement and manage the development of complex database projects. They will be able to discuss system features with arguments, select appropriate project templates, make quality decisions in the development process, and evaluate the results obtained.
      Contents
      Contents of lectures Complete development cycle of complex DB systems (planning, analysis, design, implementation, maintenance), life cycle, physical design, integration, security.
      Contents of exercises Practical work through the project.
      Literature
      1. Gershkovich S., Data Modeling with Snowflake: A practical guide to accelerating Snowflake development using universal modeling techniques, Packt Publishing, 2025. (Original title)
      2. Malhotr M., Ultimate Data Engineering with Databricks: Develop Scalable Data Pipelines Using Data Engineering's Core Tenets Such as Delta Tables, Ingestion, ... Security, and Scalability, Orange Education Pvt Ltd, 2024. (Original title)
      3. Reis J., Housley M., Fundamentals of Data Engineering: Plan and Build Robust Data Systems, O'Reilly Media, 2022. (Original title)
      4. Kleppmann M., Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems, O'Reilly Media, 2017. (Original title)
      Number of hours per week during the semester/trimester/year
      Lectures Exercises OTC Study and Research Other classes
      8
      Methods of teaching Project and discussion.
      Knowledge score (maximum points 100)
      Pre obligations Points Final exam Points
      Activites during lectures Test paper
      Practical lessons Oral examination 30
      Projects 70
      Colloquia
      Seminars