AIMS AND CONTENT

LEARNING OUTCOMES

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).

TEACHING METHODS

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.

SYLLABUS/CONTENT

Python fundamentals:

• Introduction to programming
• Variables
• Conditional flow
• Loops
• Collections
• Functions
• Overview on Object-Oriented Programming
• Read - Write files
• Data-interchange formats

Database introduction:

• Entities and keys
• Relationships
• From ER to table

SQL principles:

• Single-table queries
• Multi-table queries
• Multiset operation and "group by"
• DB connection to python scripts

TEACHERS AND EXAM BOARD

Exam Board

KATIA LUPINETTI (President)

DAVIDE GIGLIO

NICOLA SACCO (President Substitute)

LESSONS

LESSONS START

https://corsi.unige.it/10377/p/studenti-orario

Class schedule

The timetable for this course is available here: Portale EasyAcademy

EXAMS

EXAM DESCRIPTION

The exam is composed of two parts. A quiz (10 questions in 20 minutes), delivered on AulaWeb, and a lab project (2 hours).

ASSESSMENT METHODS

The quiz has the purpose of accessing database and SQL concepts; while the lab project tests the scripting knowledge.

Exam schedule