Teachers

Anna Monreale, Riccardo Guidotti

EXAM

Slides
Databases essentials - Antonio Albano PDF File
A First Course in Database Systems, JefferyD. Ullman and Jennifer Widom
Decision Support Databases Essentials - Antonio Albano PDF File
Italian versione of slides on Databases can be found here in section “Calendario delle lezioni BDD (Primo Semestre 2016) e Lucidi dei docenti”

SQL Server 2016 Developer Edition:
1. Mandatory: SQL Server 2017 Management Studio (17.4) and SQL Server 2017 Data Tools 15.5.2 (no need to install Microsoft Visual Studio 2015! choose option 4 “Download SSDT as an ISO image”)
Microsoft Excel
Power BI Desktop
For students with Mac OSX or Linux: Valentina Studio

	Day	Topic	Learning material	Book
1.	19.02.2018 09:00-18:00	Introduction – Conceptual modeling – Exercise	Introduction Relational Model Conceptual Modeling Exercises on Conceptual Modeling	DB Essentials
2.	20.02.2018 09:00-13:00	Logical design - Exercises	Logical Design	DB Essentials
3.	26.02.2018 09:00-13:00	SQL Language	SQL	DB Essentials
4.	26.02.2018 14:00-18:00	Exercises on SQL. Decision Support Systems.		DB Essentials
5.	27.02.2018 09:00-13:00	Exercises SQL.		DSD Essentials
6.	28.02.2018 09:00-13:00	DW Conceptual Modelling.	dwconcept.pdf	DSD Essentials
7.	05.03.2018 09:00-18:00	Logical Modeling for DW – case studies for DW, SQL analitico -The Cube, Reporting	Logical Model -DW The cube SQL analitico	DSD Essentials
8.	06.03.2018 09:00-18:00	Analytic Sql - ETL Process - Microsoft SQL Server Data Tools		DSD Essentials
9.	14.03.2018 14:00-18:00	ETL - Exercises	ETL	DSD Essentials
10.	15.03.2018 09:00-18:00	Reporting		DSD Essentials
11.	19.03.2018 14:00-18:00			DSD Essentials