96793 - INFORMATION SYSTEMS AND DATABASE MANAGEMENT

Conoscenze e abilità da conseguire

Aim of the course is to understand the concepts and learn the techniques to access data stored in database systems for analytical purposes. In particular, the student will understand the main concepts of relational and noSQL database systems and will learn how to effectively extract data from those systems in order to prepare them for subsequent application of statistical and machine learning techniques. The course will deal with both the query languages of databases and the interfaces with programmatic languages, such as R or Python. At the end of the course the student is able: - to understand the structure of a given database, either relational or noSql; - to access the data stored in a Database Management System either with the specific standard languages or with programmatic interfaces.

Contenuti

- Advanced Excel database functions
- Introduction on Database and DBMS
- The Relational Model
- The Entity-Relationship Model
- Data Modeling
- SQL

Testi/Bibliografia

Atzeni Paolo et al., Basi di dati, McGraw-Hill, Milano, 2018, ISBN 9788838694455

Ramakrishnan Raghu, Gehrke Johannes, Database Management Systems, 3. revised ed., Mc Graw Hill, Boston, 2003, ISBN 9780072465631

Slides, notes and recordings of the lessons are available on virtuale.unibo.it

Metodi didattici

Mixed mode: Frontal and online lectures

Modalità di verifica e valutazione dell'apprendimento

The final exam consists of two parts:

Part 1:
Practical test in the computer room.

Part 2:

Option 1: oral assessment

Option 2: project (description on virtuale.unibo.it)

Depending on the sanitary provisions, the methods of assessment may vary.

Link ad altre eventuali informazioni

https://virtuale.unibo.it/course/view.php?id=25746

Orario di ricevimento

Consulta il sito web di Alessandro Lubisco