The course aims at learning how to access, model, and manipulate (textual) data by providing concepts of object-oriented programming (Python scripts) and an introduction to data interchange files and databases.
The course includes frontal teaching activities alongside practical lecutures with the aim of consolidating the topics seen in class.
The course has a strong applicative connotation, then students are encouraged to tackle problems of increasing complexity independently.
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, and analysis of data. The course will focus on basic technological components, providing methodological tools to write simple scripts and use an information system. In particular, the course will address aspects relating to the automatization of data management and data warehousing systems, with particular attention to the scripting methods and interrogation methods of structured text files and databases.
At the end of the course, students are able to:
The course is articulated in 45 hours of lectures held in the INFAL2 laboratory. Due to the practical nature of the course, some 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:
All the slides and additional exercise material used during the lectures will be available on AulaWeb.
In general, the notes taken during the lectures and the material on AulaWeb are sufficient to prepare for the exam.
KATIA LUPINETTI (President)
DAVIDE GIGLIO (President Substitute)
https://corsi.unige.it/10377/p/studenti-orario
The exam is composed of two parts.
A quiz part (10 questions -multiple choices- in 20 minutes) will test the database and SQL knowledge of the students, 1 point for each correct answer will be assigned (no penalty for wrong answers is foreseen).
A lab project (2 hours) where students should demonstrate their ability to access data from CSV files, manipulate file content to extract some information, and save the results.
Both the parts are delivered on AulaWeb.
Both parts should be sufficient to pass the exam (6 right answers for the quiz and a grade of 18 for the lab). The final grade is given by the weighted average of the two parts (30% the quiz and 70% the lab).
Students with learning disorders ("Disturbi Specifici di Apprendimento", DSA) will be allowed to use specific modalities and supports that will be determined on a case-by-case basis in agreement with the delegate of the Engineering courses in the Committee for the Inclusion of Students with Disabilities.
The quiz aims to test the knowledge for accessing information in relational databases and the comprehension of SQL queries; while the lab project tests the acquired scripting knowledge.
