Studying at the University of Verona
Here you can find information on the organisational aspects of the Programme, lecture timetables, learning activities and useful contact details for your time at the University, from enrolment to graduation.
Type D and Type F activities
The educational activities of type D are chosen by the student, those of type F are further knowledge useful for entering the world of work (internships, soft skills, project works, etc.). According to the Didactic Regulations of the Course, some activities can be chosen and included autonomously in the booklet, others must be approved by a special committee to verify their consistency with the study plan. Type D or F educational activities can be covered by the following activities.
1. Teachings taught at the University of Verona.
Include the teachings listed below and/or in the Course Catalogue (which can also be filtered by language of delivery via Advanced Search).
Booklet entry mode: if the teaching is included among those listed below, the student can include it autonomously during the period in which the study plan is open; otherwise, the student must submit a request to the Secretariat, sending the form to carriere.scienze@ateneo.univr.it during the period indicated.
2. CLA certificate or language equivalency.
In addition to those required by the curriculum, the following are recognized for those matriculated from A.Y. 2021/2022:
- English language: 3 CFUs are recognized for each level of proficiency above the one required by the course of study (if not already recognized in the previous course of study).
- Other languages and Italian for foreigners: 3 cfu are recognized for each proficiency level starting from A2 (if not already recognized in the previous study cycle).
These cfu will be recognized, up to a maximum of 6 cfu in total, as type F if the teaching plan allows, or as type D. Additional elective credits for language knowledge may be recognized only if consistent with the student's educational project and if adequately justified.
Those enrolled until A.Y. 2020/2021 should consult the information found here.
Booklet entry mode: request the certificate or equivalency to the CLA and send it to the Student Secretariat - Careers for career entry of the exam, via email: carriere.scienze@ateneo.univr.it
3. Soft skills
Discover the training paths promoted by the University's TALC - Teaching and learning center, intended for students regularly enrolled in the academic year of course delivery https://talc.univr.it/it/competenze-trasversali
Booklet entry mode: the teaching is not expected to be included in the curriculum. Only after obtaining the Open Badge, the CFUs in the booklet will be automatically validated. The registration of CFUs in career is not instantaneous, but there will be some technical time to wait.
4. CONTAMINATION LAB
The Contamination Lab Verona (CLab Verona) is an experiential course with modules on innovation and enterprise culture that offers the opportunity to work in teams with students from all areas to solve challenges set by companies and organisations.
Upon completion of a CLab, students will be entitled to receive 6 CFU (D- or F-type credits).
Find out more: https://www.univr.it/clabverona
PLEASE NOTE: In order to be admitted to any teaching activities, including those of your choice, you must be enrolled in the academic year in which the activities in question are offered. Students who are about to graduate in the December and April sessions are therefore advised NOT to undertake extracurricular activities in the new academic year in which they are not enrolled, as these graduation sessions are valid for students enrolled in the previous academic year. Therefore, students who undertake an activity in an academic year in which they are not enrolled will not be granted CFU credits.
5. Stage/internship period
In addition to the CFUs required by the curriculum (check carefully what is indicated on the Didactic Regulations): here information on how to activate the internship.
Teachings and other activities that can be entered autonomously in the booklet
years | Modules | TAF | Teacher |
---|---|---|---|
1° 2° | Introduction to Robotics for students of scientific courses. | D |
Paolo Fiorini
(Coordinator)
|
1° 2° | Matlab-Simulink programming | D |
Bogdan Mihai Maris
(Coordinator)
|
1° 2° | Rapid prototyping on Arduino | D |
Franco Fummi
(Coordinator)
|
1° 2° | Programming Challanges | D |
Romeo Rizzi
(Coordinator)
|
years | Modules | TAF | Teacher |
---|---|---|---|
1° 2° | Introduction to 3D printing | D |
Franco Fummi
(Coordinator)
|
1° 2° | Python programming language | D |
Carlo Combi
(Coordinator)
|
1° 2° | HW components design on FPGA | D |
Franco Fummi
(Coordinator)
|
1° 2° | Protection of intangible assets (SW and invention)between industrial law and copyright | D |
Roberto Giacobazzi
(Coordinator)
|
years | Modules | TAF | Teacher |
---|---|---|---|
1° 2° | Federated learning from zero to hero | D |
Gloria Menegaz
|
Data warehouse and integration (2022/2023)
Teaching code
4S009009
Teacher
Coordinator
Credits
6
Also offered in courses:
- Programming and database of the course Master's degree in Data Science
Language
English
Scientific Disciplinary Sector (SSD)
ING-INF/05 - INFORMATION PROCESSING SYSTEMS
Period
Semester 2 dal Mar 6, 2023 al Jun 16, 2023.
Learning objectives
The goal of the course is to enable students to master the engineering methods and processes that are necessary to manage modern information system, and especially data-intensive systems, to operate on large data collections and to understand the utility and methods of business analysis, obtaining useful knowledge to improve the decision-making process. As a consequence, the course will expose the students to some of the most advanced methodologies adopted to understand the conceptual and technological problems encountered in the design and implementation of solutions based on analyses for complex systems starting from collections of data that must be integrated, organized and analyzed mainly through automatic tools.
Prerequisites and basic notions
Theory or relational databases
Program
1. Introduction to database management systems (DBMS): architectures and functionalities of a DBMS. Physical and logical data independence. Data models. Concepts of model, schema and instance of a database. Languages for database systems. DBMS vs. file system. Information Systems and Data Science.
2. The relational theory: basic concepts.
3. Interacting with a database system: languages for the definition, querying and update of a database. SQL: select-from-where statement, join in SQL, the GROUP BY and ORDER BY clauses, using subqueries. Views.
4. Conceptual database design: conceptual data models. The Entity-Relationship model (ER). Elements of the ER model: entities, attributes, relationships, ISA hierarchies and cardinality constraints. Logical database design: logical data models, the relational data model. Elements of the relational data models: relations and integrity constraints. Mapping between conceptual schemas in ER model and logical schema in the relational model.
5. Decision support systems.
1. Datawarehouse systems
2. Designing Data Warehouse on integrated data (GAV and LAV approaches)
3. OLAP queries
Bibliography
Didactic methods
In-person classes and practical sessions
Learning assessment procedures
The exam consists of a written test (2 hours), possibly supplemented by an oral, containing some open questions about theory concepts, an exercise about the conceptual modeling and the logical modeling of a datawarehouse, and some exercises about the specification of queries in SQL on the designed datawarehouse.
Evaluation criteria
To pass the exam, the students must show that:
- they have understood the concepts related to the theory of relational databases and data warehouses and their design;
- they are able to describe the concepts in a clear and exhaustive way;
- they are able to apply the acquired knowledge to solve application scenarios described by means of questions and exercises.
The written exam will be evaluated with at most 33 points (30 cum Laude).
Criteria for the composition of the final grade
The final mark will be the mark obtained in the written exam, possibly supplemented by the mark obtained during the oral test.
Exam language
Inglese