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.	ex-sql.zip	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 Ex. AnalyticSQL dwessentialssolutions.pdf	DSD Essentials
8.	06.03.2018 09:00-18:00	Analytic Sql - ETL Process - Microsoft SQL Server Data Tools	ETL sqlan.sql.zip	DSD Essentials
9.	14.03.2018 14:00-18:00	ETL - Exercises		DSD Essentials
10.	15.03.2018 09:00-18:00	ETL - Exercises	2016ssis.zip (When you import the solution you will have some error due to the connection to DB and files. Please, modify them with login and pass and correct path of file)	DSD Essentials
11.	19.03.2018 14:00-18:00			DSD Essentials