Strumenti Utente

Strumenti Sito


bdd-infuma:bi-mains

Teachers

Anna Monreale, Riccardo Guidotti

EXAM

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

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 Exercises on Conceptual ModelingDB 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 SQLDB 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.zipDSD 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.pdfDSD 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
bdd-infuma/bi-mains.txt · Ultima modifica: 15/03/2018 alle 21:27 (9 mesi fa) da Anna Monreale