Strumenti Utente

Strumenti Sito


bdd-infuma:start

ICT: Business intelligence and CRM

Teacher

Anna Monreale

EXAM

  • Project to be delivered by email within 15 May 2020:exam-mains-2020-final.pdf
  • 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 l-analytics-sqlreporting.pdf sol-assignment-aq.zip assignment-aq-2.pdf
11. 21.04.2020 14:00-16:00 Final Exam Presentaion + Exercises assignment-aq-3.pdf sol-assignment2-aq.zip
12. 27.04.2020 09:00-11:00 Reporting + Exercises Reporting Software: we will use an online tool: https://www.qlik.com/us/trial/qlik-sense-business: please before Monday 27, you need to do the registration.https://meet.google.com/dcy-dqvb-eub sol-assignment3-aq.sql.zip
bdd-infuma/start.txt · Ultima modifica: 03/05/2020 alle 14:25 (6 mesi fa) da Anna Monreale