The course aims at providing an overview of information systems geared to transport, logistic and production systems, with reference to the main methodologies and technologies for the collection, storage, management, display and analysis of data. The course will focus on basic technological components, providing methodological tools to manage and use an information system. In particular, the course will address aspects relating to data management and data warehousing systems, with particular attention to the interrogation methods of the databases, as well as methods of interpretation and extraction of knowledge from data (Data Mining).
The course is articulated in 45 hours of lectures held in the INFAL2 laboratory. Due to the practical nature of the course, some lectures are practical classes are provided during the course; in addition, each theoretical lesson ends with exercises of the concepts introduced. In order to complete, review and better understand the proposed exercises, students are encouraged to install Python 3, PyCharm and MariaDB server.
Python fundamentals:
Database introduction:
SQL principles:
KATIA LUPINETTI (President)
DAVIDE GIGLIO
NICOLA SACCO (President Substitute)
https://corsi.unige.it/10377/p/studenti-orario
The exam is composed of two parts. A quiz (10 questions in 20 minutes), delivered on AulaWeb, and a lab project (2 hours).
The quiz has the purpose of accessing database and SQL concepts; while the lab project tests the scripting knowledge.