INFO-H-415 : Exercises

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:
  • Azure studio or SQL Server Management Studio
  • SQL Server Express
• For mac:
  • Follow this tutorial. Note that I could not verify if this tutorial works by myself.
• For linux:
  • SQL Server. While choosing the “edition”, please select the free “Express” edition.
  • Azure studio. To connect to your SQL Server express, please indicate server: “localhost”, login: “SA” and the password selected during the installation of SQL Server.

• Slides: Intro + recap
• Exercises + Solutions
• SQL Server Scripts

• Recap
• Exercises + Solutions
• SQL Server Scripts
• New scripts
• The second exercise session will take place the 30/09 14h-16h in S.UB4.126

• Recap
• Drawing temporal difference Attention: this drawing is not totally correct, an update version should be posted soon
• Drawing temporal join
• Traduction of EA schemas
• Exercises and solutions
• SQL Server Scripts
• Explanation of 10th query exercise
• 10th query step by step drawing

• Planning:
  • Session 4: Exercice 1 (relational schema) and queries 1 to 5
  • Session 5: Queries 6 to 8 and constraints
  • Session 6: Queries 9 to 13

Material for Graph databases sessions

Please be sure to install the correct version of Neo4J as indicated in the installation document.

• Exercises
• infoh415_postgis_insertion.zip
• shapefiles.zip
• tp_10_txt_corrections.zip
• shapefiles.tar.gz
• On-line PostGIS documentation
• On-line PostGIS documentation - Command reference

• bel_alt.vrt
• infoh415_postgis_generate.sql.zip
• Exercices
• Slides
• Corrections and commands

• Exercices
• Initialisation script
• References