| Entrambe le parti precedenti la revisione
Revisione precedente
Prossima revisione
|
Revisione precedente
Ultima revisione
Entrambe le parti successive la revisione
|
bdd-infuma:bi-mains [19/02/2018 alle 11:36 (6 anni fa)]
Anna Monreale [Class Calendar 2018] |
bdd-infuma:bi-mains [15/03/2018 alle 21:27 (6 anni fa)]
Anna Monreale [EXAM] |
| |
| ====== EXAM ===== | ====== EXAM ===== |
| * Project | * Project: 2 deliveries |
| | * - First part within March 14, 2018: {{ :bdd-infuma:exam1.pdf | First Part of the Project}} |
| | * - The whole project within May 8, 2018: {{ :undefined:exam-mains.pdf.zip |}} |
| ====== Learning Material ===== | ====== Learning Material ===== |
| * Slides | * Slides |
| * Italian versione of slides on Databases can be found [[http://didawiki.di.unipi.it/doku.php/bdd-infuma/start|here]] in section "Calendario delle lezioni BDD (Primo Semestre 2016) e Lucidi dei docenti" | * Italian versione of slides on Databases can be found [[http://didawiki.di.unipi.it/doku.php/bdd-infuma/start|here]] in section "Calendario delle lezioni BDD (Primo Semestre 2016) e Lucidi dei docenti" |
| ====== Software ===== | ====== Software ===== |
| * Microsoft SQL Server Management Studio | * SQL Server 2016 Developer Edition: |
| | - Mandatory: [[https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms | SQL Server 2017 Management Studio (17.4)]] and [[https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt | SQL Server 2017 Data Tools 15.5.2]] (no need to install Microsoft Visual Studio 2015! choose option 4 "Download SSDT as an ISO image") |
| | * Microsoft Excel |
| | * [[https://powerbi.microsoft.com/it-it/desktop/| Power BI Desktop]] |
| | * For students with Mac OSX or Linux: [[https://www.valentina-db.com/en/valentina-studio-overview|Valentina Studio]] |
| ====== Data ===== | ====== Data ===== |
| * {{ :bdd-infuma:foodmart_mysql.sql.zip | Foodmart}} | * {{ :bdd-infuma:foodmart_mysql.sql.zip | Foodmart}} |
| |3. | 26.02.2018 09:00-13:00 |SQL Language | {{ :bdd-infuma:d.sql-concettibase.pdf | SQL}}|DB Essentials| | |3. | 26.02.2018 09:00-13:00 |SQL Language | {{ :bdd-infuma:d.sql-concettibase.pdf | SQL}}|DB Essentials| |
| |4. | 26.02.2018 14:00-18:00 |Exercises on SQL. Decision Support Systems.| |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| | |5. | 27.02.2018 09:00-13:00 |Exercises SQL. | {{ :bdd-infuma:ex-sql.zip |}}|DSD Essentials| |
| |6. | 28.02.2018 09:00-13:00 |DW Conceptual Modelling. | |DSD Essentials| | |6. | 28.02.2018 09:00-13:00 |DW Conceptual Modelling. | {{ :bdd-infuma:dwconcept.pdf |}} |DSD Essentials| |
| |7. | 05.03.2018 09:00-18:00 |Logical Modeling for DW – case studies for DW | |DSD Essentials| | |7. | 05.03.2018 09:00-18:00 |Logical Modeling for DW – case studies for DW, SQL analitico -The Cube, Reporting | {{ :bdd-infuma:g.dwlogical.pdf |Logical Model -DW}} {{ :bdd-infuma:h.olap.pdf | The cube}} {{ :bdd-infuma:i-analytics-sqlreporting.pdf |SQL analitico}} {{ :bdd-infuma:sql-dw.txt.zip |Ex. AnalyticSQL}} {{ :bdd-infuma:dwessentialssolutions.pdf |}}|DSD Essentials| |
| |8. | 06.03.2018 09:00-18:00 |ETL Process - Microsoft SQL Server Data Tools | |DSD Essentials| | |8. | 06.03.2018 09:00-18:00 |Analytic Sql - ETL Process - Microsoft SQL Server Data Tools | {{ :bdd-infuma:i.etl.pdf | ETL}} {{:bdd-infuma:sqlan.sql.zip |}} |DSD Essentials| |
| |9. | 14.03.2018 14:00-18:00 |ETL - Exercises | |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| | |10.| 15.03.2018 09:00-18:00 |ETL - Exercises| {{ :mds:lbi: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 09:00-13:00 | | |DSD Essentials| | |11.| 19.03.2018 14:00-18:00 | | |DSD Essentials| |
