This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
teaching:infoh415:tp [2021/09/20 12:06] gdejaege |
teaching:infoh415:tp [2021/09/22 13:41] gdejaege [Active databases] |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| ==== Before Session 1 ==== | ==== Before Session 1 ==== | ||
| - | If you are planning on working on your own laptop, please download and install the following before the first exercice session. | + | If you are planning on working on your own laptop/computer (which is strongly advised given the state of the computers in the computer rooms), please download and install the following before the first exercice session. |
| * For windows: | * For windows: | ||
| - | * [[https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017|SQL Server Management Studio]] | + | * [[https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15| Azure studio]] or [[https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017|SQL Server Management Studio]] |
| * [[https://www.microsoft.com/en-us/sql-server/sql-server-downloads|SQL Server Express]] | * [[https://www.microsoft.com/en-us/sql-server/sql-server-downloads|SQL Server Express]] | ||
| * For mac: | * For mac: | ||
| Line 17: | Line 17: | ||
| ==== Session 1 : Exercises "PhD" ==== | ==== Session 1 : Exercises "PhD" ==== | ||
| - | * {{:teaching:infoh415:infoh415_tp01_slides_2020.pdf|Slides: Intro + recap}} | + | * {{:teaching:infoh415:2021_adb_tp1_slides.pdf|Slides: Intro + recap}} |
| - | * {{:teaching:infoh415:infoh415_tp01_exercices_2018.pdf|Exercises + Solutions}} | + | * {{:teaching:infoh415:2021_adb_tp1_exercices.pdf|Exercises + Solutions}} |
| * {{teaching:infoh415:sdi_actives_phd_scripts.zip|SQL Server Scripts}} | * {{teaching:infoh415:sdi_actives_phd_scripts.zip|SQL Server Scripts}} | ||
| - | * The exercice sessions will normally all take place in UB4.126 | + | * This exercice sessions will normally take place in UB4.130 |
| ==== Sessions 2 and 3 : Exercises "Employees Departments Projects" ==== | ==== Sessions 2 and 3 : Exercises "Employees Departments Projects" ==== | ||
| - | * {{:teaching:infoh415:2019_infoh415_tp02_03_slides.pdf|Recap}} | + | * {{:teaching:infoh415:2021_adb_tp02_03_slides.pdf|Recap}} |
| - | * {{:teaching:infoh415:2018_infoh415_tp02_03_exercices_updated.pdf|Exercises + Solutions}} | + | * {{:teaching:infoh415:2021_adb_exercices.pdf|Exercises + Solutions}} |
| * {{teaching:infoh415:sdi_actives_constraints_scripts.zip|SQL Server Scripts}} | * {{teaching:infoh415:sdi_actives_constraints_scripts.zip|SQL Server Scripts}} | ||