Master’s Degree in Data Management
Credits: 9.0 
Course year: 3 
Teaching hours: 81.0 
Language: English 
Curriculum: Common path 

Short Description

The course will be organised into four section:

  1. Management Information Systems
    • Technical / technological aspects;
    • Business aspects;
    • Business Intelligence (BI) concepts;
    • Enterprise MIS;
    • The importance of data management and data quality.
  2. Relational Databases, R-DBMS and OLTP
    • Introduction; core concepts and definitions; reference architectures
    • Data, Database, DBMS, RDBMS
    • Conceptual modelling: ER / EER diagrams and design reference patterns
    • Logical modelling: the mapping algorithm
    • Physical modelling
    • SQL queries
    • Introduction to NoSQL DBMS
  3. Data Warehouse (DWH) and OLAP
    • Introduction; core concepts and definitions
    • Requirement analysis and elicitation
    • Use case modelling with UML 2.0 U-C diagrams
    • Conceptual modelling: DFM
    • Logical modelling: ROLAP
    • Physical modelling: DWH and data marts
    • ETL pipelines
  4. Additional topics
    • Citizen Science
    • Data security
    • Data storytelling
    • Data visualisation
    • (Big) Data Quality
    • Big data, data lakes, data analytics, machine learning, AI;

More infoData Management