Questa è una vecchia versione del documento!
Anna Monreale, Riccardo Guidotti
Day | Topic | Learning material | Book | |
---|---|---|---|---|
1. | 19.02.2018 09:00-18:00 | Introduction – Conceptual modeling – Exercise | Introduction Relational ModelConceptual Modeling Exercises on Conceptual 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. | ex-sql.zip | DSD Essentials |
6. | 28.02.2018 09:00-13:00 | DW Conceptual Modelling. | dwconcept.pdf | DSD Essentials |
7. | 05.03.2018 09:00-18:00 | Logical Modeling for DW – case studies for DW, SQL analitico -The Cube, Reporting | Logical Model -DW The cube SQL analitico Ex. AnalyticSQL dwessentialssolutions.pdf | DSD Essentials |
8. | 06.03.2018 09:00-18:00 | Analytic Sql - ETL Process - Microsoft SQL Server Data Tools | ETL sqlan.sql.zip | DSD Essentials |
9. | 14.03.2018 14:00-18:00 | ETL - Exercises | DSD Essentials | |
10. | 15.03.2018 09:00-18:00 | ETL - Exercises | 2016ssis.zip (When you import the solution you will have some error due to the connection to DB and files. Please, modify them with login and pass and correct path of file) | DSD Essentials |
11. | 19.03.2018 14:00-18:00 | DSD Essentials |