Business Intelligent Technologies

Teacher

Anna Monreale

Project to be delivered by email within 15 May 2020: First Part of the project.
Note that in the last page of the project description the student can find the instructions to be followed for the delivery.

SQL Server 2016 Developer Edition:
1. Mandatory: SQL Server 2017 Management Studio
For students with Mac OSX or Linux: Valentina Studio

	Day	Topic	Learning material	Book
1.	17.02.2020 14:00-18:00	Introduction – Relational Model Conceptual modeling	a.introduction.pdf b.modellorelazionale.pdf c.conceptualmodel.pdf Model of University DB Exercises Conceptual Modelling	DB Essentials
2.	24.02.2020 14:00-18:00	Logical Modeling - Exercises on Conceptual & Logical Modeling	c.logicalmodel.pdf conceptual_logicalmodel-companies.jpeg logicalmodel-university.jpeg	DB Essentials
3.	10.03.2020 14:00-18:00	Exercises on Conceptual & Logical Modeling. SQL	exmodelling-10march.pdf e.sql-concettibase.pdf	DB Essentials
4.	23.03.2020 14:00-18:00	Exercises on SQL + Advances SQL & Exercises	text-ex-sql.pdf assignment-23-03.pdf sol-exsql.zip	DB Essentials
5.	27.03.2020 09:00-13:00	Exercises on SQL + Decision Support Systems + Data Warehouses Conceptual Modeling	3-sol-market-queries.sql.zip f.dwconcept.pdf Do Exercises in Appendix A of this book	BOOK: Decision Support Databases Essentials
6.	30.03.2020 14:00-18:00	Data Warehouses Logical Modeling - Exercises on DW models	dwlogical.pdf https://meet.google.com/dcy-dqvb-eub The lecture will start at 14:10
7.	02.04.2020 14:00-18:00	Exercises on DW models + olap - sql reporting
8.	06.04.2020 14:00-18:00	Querying DW
9.	07.04.2020 14:00-18:00	Exercises on Querying DW