Dettagli sull'Insegnamento per l'A.A. 2018/2019
Nome:
Database Systems / Database Systems
Informazioni
Crediti:
: Master Degree in Applied Data Science 6 CFU (c)
Erogazione:
Master Degree in Applied Data Science 1st anno curriculum Data for Smart City Compulsory
Master Degree in Applied Data Science 1st anno curriculum Data for Life Science Compulsory
Lingua:
Inglese
Obiettivi
This course aims at providing practical knowledge and competences about database systems. After a brief introduction to database systems and their architectures, the course turns to data modelling through the Entity-Relationship model. Then, a brief overview of the Boolean algebra is provided, in order to introduce students to SQL essential aspects. The latter consist of introducing data types and definition, and training students on basic SQL constraints and queries, as well as insert/delete/update operations. Afterwards, SQL advanced aspects are provided, such as complex queries, triggers, views and modification of a database schema. Finally, the course introduces database programming, illustrates limitations of traditional database systems and provides knowledge about XML and JSON data formats.
Sillabo
- Introduction to database systems and architectures.
- Usage of the Entity Relationship model for data modelling.
- Boolean Algebra.
- SQL essential aspects: data types and data definition, basic SQL constraints and querying, insert/delete/update.
- SQL advanced aspects: complex queries, triggers, views, database schema modification.
- Introduction to database programming and advanced aspects: limitations, XML and JSON data formats.
Testi di riferimento
- Elmasri Ramez And Navathe Shamkant, Fundamentals of Database Systems , Pearson. (vol. 7th edition) 2016.
Modalità d'esame
The exam of the Database Systems course is composed of a mandatory written test and an optional oral test. The oral test can be required: by the student in order to improve grades; by the teacher in case the student's written test has serious omissions or mistakes.
Aggiornamenti alla pagina del corso
Le informazioni sulle editioni passate di questo corso sono disponibili per i seguenti anni accademici:
Per leggere le informazioni correnti sul corso, se ancora erogato, consulta il catalogo corsi di ateneo.
Ultimo aggiornamento delle informazioni sul corso: 10 settembre 2018, 16:38