| Entrambe le parti precedenti la revisioneRevisione precedenteProssima revisione | Revisione precedente |
| bdd-infuma:start [24/04/2020 alle 12:48 (5 anni fa)] – [Software] Anna Monreale | bdd-infuma:start [03/05/2020 alle 14:25 (5 anni fa)] (versione attuale) – [Class Calendar 2020] Anna Monreale |
|---|
| * Project to be delivered by email within 15 May 2020:{{ :bdd-infuma:exam-mains-2020-final.pdf |}} | * Project to be delivered by email within 15 May 2020:{{ :bdd-infuma:exam-mains-2020-final.pdf |}} |
| * Note that in the last page of the project description the student can find the instructions to be followed for the delivery. | * Note that in the last page of the project description the student can find the instructions to be followed for the delivery. |
| | |
| | |
| |
| ====== Learning Material ===== | ====== Learning Material ===== |
| - Mandatory: [[https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms | SQL Server 2017 Management Studio ]] | - Mandatory: [[https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms | SQL Server 2017 Management Studio ]] |
| * For students with Mac OSX or Linux: [[https://www.valentina-db.com/en/valentina-studio-overview|Valentina Studio]] | * For students with Mac OSX or Linux: [[https://www.valentina-db.com/en/valentina-studio-overview|Valentina Studio]] |
| * Reporting Software: we will use an online tool: https://www.qlik.com/us/trial/qlik-sense-business: please before Monday 27, you need to do the registration. | * **Reporting Software: we will use an online tool: https://www.qlik.com/us/trial/qlik-sense-business: please before Monday 27, you need to do the registration.** |
| ====== Data ===== | ====== Data ===== |
| * {{ :bdd-infuma:foodmart_mysql.sql.zip | Foodmart}} | * {{ :bdd-infuma:foodmart_mysql.sql.zip | Foodmart}} |
| |9. | 07.04.2020 14:00-16:00 | Querying DW |{{ :bdd-infuma:sqlan.sql.zip |}} {{ :bdd-infuma:ex-aq.pdf | Text of Exercises}} | | |9. | 07.04.2020 14:00-16:00 | Querying DW |{{ :bdd-infuma:sqlan.sql.zip |}} {{ :bdd-infuma:ex-aq.pdf | Text of Exercises}} | |
| |10. | 16.04.2020 09:00-11:00 | Querying DW Exercises | {{ :bdd-infuma:l-analytics-sqlreporting.pdf |}} {{ :bdd-infuma:sol-assignment-aq.zip |}} {{ :bdd-infuma:assignment-aq-2.pdf |}}| | |10. | 16.04.2020 09:00-11:00 | Querying DW Exercises | {{ :bdd-infuma:l-analytics-sqlreporting.pdf |}} {{ :bdd-infuma:sol-assignment-aq.zip |}} {{ :bdd-infuma:assignment-aq-2.pdf |}}| |
| |11. | 21.04.2020 14:00-16:00 | Reporting + Exercises | {{ :bdd-infuma:assignment-aq-3.pdf |}} {{ :bdd-infuma:sol-assignment2-aq.zip |}}| | |11. | 21.04.2020 14:00-16:00 | Final Exam Presentaion + Exercises | {{ :bdd-infuma:assignment-aq-3.pdf |}} {{ :bdd-infuma:sol-assignment2-aq.zip |}}| |
| |12. | 27.04.2020 09:00-11:00 | Final Exam Presentaion + Exercises | https://meet.google.com/dcy-dqvb-eub | | |12. | 27.04.2020 09:00-11:00 | Reporting + Exercises | **Reporting Software: we will use an online tool: https://www.qlik.com/us/trial/qlik-sense-business: please before Monday 27, you need to do the registration.** -- https://meet.google.com/dcy-dqvb-eub {{ :bdd-infuma:sol-assignment3-aq.sql.zip |}}| |
| |
| |
