Strumenti Utente

Strumenti Sito


bdd-infuma:start

Questa è una vecchia versione del documento!


ICT: Business intelligence and CRM

Teacher

Anna Monreale

EXAM

  • 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.

Learning Material

  • 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

Software

Data

Class Calendar 2020

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 DBExercises 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.jpegDB Essentials
3. 10.03.2020 14:00-18:00 Exercises on Conceptual & Logical Modeling. SQL exmodelling-10march.pdfe.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.zipDB 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 Ex-Hospital Ex-FlightSeats
7. 02.04.2020 14:00-16:00 Exercises on DW models
8. 06.04.2020 14:00-16:00 olap - sql reporting h.olap.pdf ex-inventory-hotels.pdf inventory-metrics.pdf
9. 07.04.2020 14:00-16:00 Querying DW sqlan.sql.zip Text of Exercises
10. 16.04.2020 09:00-11:00 Querying DW Exercises https://meet.google.com/dcy-dqvb-eub
11. 21.04.2020 14:00-16:00 Reporting + Exercises https://meet.google.com/dcy-dqvb-eub
12. 27.04.2020 09:00-11:00 Final Exam Presentaion + Exercises https://meet.google.com/dcy-dqvb-eub
bdd-infuma/start.1586369799.txt.gz · Ultima modifica: 08/04/2020 alle 18:16 (19 mesi fa) da Anna Monreale