20110499 - Abilità informatiche

ENG
The "Computer Skills" module, intended for students who have passed the "Big data and decision automation" exam, aims to allow participants to carry out practical activities on the topics addressed in the aforementioned course.
teacher profile | teaching materials

Programme

Computer Skills - second year
A.Y. 2023-2024

date schedule topics room
Friday 13 October 2023 16-18 Relational DB: practical case 350
Friday 20 October 2023 16-18 Relational DB: practical case 350
Friday 27 October 2023 16-18 Relational DB: practical case 350
Friday 3 November 2023 16-18 Relational DB: implementation on MySQL 350
Friday 10 November 2023 16-18 Relational DB: implementation on MySQL 350
Friday 17 November 2023 16-18 Relational DB: implementation on MySQL 350
Friday 24 November 2023 16-18 Project Work presentation and discussion 350



Core Documentation

During the lessons, participants in the laboratory will be provided with all the necessary information so that they can autonomously carry out the illustrated steps for the creation and basic use of Relational DBs and documental NoSQL DBs.

The materials presented during the lessons will be published on the Department's e-learning platform.

Type of delivery of the course

The course will be divided into lectures and practical activities carried out independently by the students, who will then present and discuss the products produced with the teacher. In particular, two practical activities will be carried out. 1) Creation of a relational database, which will be divided into the following activities: a. Modeling of the domain identified using the ERA methodology b. Implementation and population of the database c. Development of queries for analyzing domain data 2) Creation of a NoSQL database, using one of the most widespread documentary NoSQL DBs, through the following steps: a. Cloud access to a NoSQL document platform b. Setting the work space c. Creation of the DB d. I/O operations to/from the DB e. Search and analysis operations

Attendance

attendance is absolutely recommended because during the lessons the methods of carrying out the activities that the students will have to carry out independently will be illustrated

Type of evaluation

The suitability of participants will be assessed on the basis of the work that will be carried out individually and independently.