Themen der Lehrveranstaltung
1. Data Management Fundamentals, 2. Data modeling - the relational model, 3. Data handling using SQL 4. Selection queries 5. Join operations 6. Aggregation queries 7. Set operations in SQL 8. Subqueries 9. Outer Joins

Unterrichtsform
Lectures and exercises

Bildungsziele
ILO (Intended Learning Outcomes) Introduction to Data Management and Data Analysis ILO1 Knowledge and understanding ILO1.2 The student acquires knowledge of economic theory necessary to understand and analyse economic and business phenomena in the public sector in order to support decision-making processes. Knowledge of public policy and the tools necessary for the design of sustainable policies will be consolidated. Knowledge related to the labour market, education and health will also be deepened, functional to the development of public policy analysis and evaluation skills. ILO2 Ability to apply knowledge and understanding ILO2.4 ability to interpret results deriving from statistical and econometric analysis in contexts of interest to companies and public bodies ILO3 Making judgements ILO3.1 ability to apply acquired knowledge to interpret economic and business phenomena in order to make managerial and operational decisions in the context of public administration ILO3.2 ability to select data and use appropriate information to describe a problem concerning the design, implementation and evaluation of public sector projects and policies, aiming at innovation and improvement of processes, products and results ILO3.3 ability to relate models and empirical evidence in the study of public policy phenomena ILO4 Communication skills ILO4.1 ability to communicate effectively in oral and written form the specialised contents of the individual disciplines, using different registers according to recipients and communicative and didactic purposes, as well as to evaluate the formative effects of his/her communication ILO5 Learning ability ILO5.1 ability to use information technology autonomously to carry out bibliographical research and investigations and for one's own training and further education.

Bildungsziele und erwartete Lernergebnisse (zus. Informationen)
Knowledge and understanding of different types of data and their representation. Management of complex data structure for knowledge representation

Art der Prüfung
Written exam with questions of data extraction from relational datasources, and interpretation of results. Obligatory written final exam (ILOs 1-5). The final grade (100%) will be a weighted average of the various questions considering their complexity and length.

Bewertungskriterien
Criteria for the exam: correctness and clarity of answers, knowledge and understanding of data representation, ability to interpret requests and represent them into a proper SQL query, selecting the most effective and efficient one. Students will be evaluated on their understanding and ability to apply data management query techniques; knowledge and understanding of data representation; ability to interpret requests and transform them in proper queries.

Pflichtliteratur

Lecture notes.

Additional materials and references will be provided by the lectures throughout the course.

Weitere Informationen
Co-lecturer to be appointed.