Anna Monreale
| 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.jpeg | DB 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.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 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 |
