bdd-infuma:bi-mains
Questa è una vecchia versione del documento!
Teachers
Anna Monreale, Riccardo Guidotti
- KDD Laboratory, Università di Pisa ed ISTI - CNR, Pisa
EXAM
- Project
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
- Italian versione of slides on Databases can be found here in section “Calendario delle lezioni BDD (Primo Semestre 2016) e Lucidi dei docenti”
Software
- Microsoft SQL Server Management Studio
Data
Class Calendar 2018
Day | Topic | Learning material | Book | |
---|---|---|---|---|
1. | 19.02.2018 09:00-18:00 | Introduction – Conceptual modeling – Exercise | Introduction Relational ModelConceptual Modeling | DB Essentials |
2. | 20.02.2018 09:00-13:00 | Logical design - Exercises | Logical Design | DB Essentials |
3. | 26.02.2018 09:00-13:00 | SQL Language | SQL | DB Essentials |
4. | 26.02.2018 14:00-18:00 | Exercises on SQL. Decision Support Systems. | DB Essentials | |
5. | 27.02.2018 09:00-13:00 | Exercises SQL. | DSD Essentials | |
6. | 28.02.2018 09:00-13:00 | DW Conceptual Modelling. | DSD Essentials | |
7. | 05.03.2018 09:00-18:00 | Logical Modeling for DW – case studies for DW | DSD Essentials | |
8. | 06.03.2018 09:00-18:00 | ETL Process - Microsoft SQL Server Data Tools | DSD Essentials | |
9. | 14.03.2018 14:00-18:00 | ETL - Exercises | DSD Essentials | |
10. | 15.03.2018 09:00-18:00 | SQL analitico -The Cube, Reporting | DSD Essentials | |
11. | 19.03.2018 09:00-13:00 | DSD Essentials |
bdd-infuma/bi-mains.1519035145.txt.gz · Ultima modifica: 19/02/2018 alle 10:12 (7 anni fa) da Anna Monreale