bdd-infuma:start
Questa è una vecchia versione del documento!
Indice
Business Intelligent Technologies
Teacher
Anna Monreale
- KDD Laboratory, Università di Pisa ed ISTI - CNR, Pisa
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
Software
- SQL Server 2016 Developer Edition:
- Mandatory: SQL Server 2017 Management Studio
- For students with Mac OSX or Linux: Valentina Studio
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.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 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 |
bdd-infuma/start.1585663495.txt.gz · Ultima modifica: 31/03/2020 alle 14:04 (5 anni fa) da Anna Monreale