Uni-Logo
Databases and Information Systems
Sie sind hier: Startseite Teaching Lehrangebot Wintersemester 2017/18 Energy Informatics
 

Energy Informatics

WS1718 - General Information

News

  • [Feb 15, 2018] The exam will take place in room 00-006 in building 082 at 12:00 noon until 1:30 pm; i.e. you have 90 minutes!
  • [Feb 15, 2018] You are not required to write or interpret SQL queries for JSON!
  • [Feb 12, 2018] Exercise tomorrow (Feb 13) will start at 4pm.
  • [Feb 08, 2018] The solutions for the Python exercises are already available via the links next to the PDFs of the respective exercise. They are now highlighted.
  • [Feb 07, 2018] Slides from 05/02/18 and 06/02/18 have been updated! Please download them again! We added a hint to the extract function for exercise 2 of sheet 6!
  • [Feb 05, 2018] Tomorrow (06/02/2018) we start with the exercise at 2 pm and continue with the lecture at 4 pm.
  • [Feb 05, 2018] Lecture today starts at 10:00 am (not 08:00 am).
  • [Jan 29, 2018] Exercise sheet Programming-01 was updated on 29/01/2018 3:00 pm: Exercise 5 "Data analysis in Excel" required more than one vote and was adapted.

Lecturers

Contents

Lecture Slides

  1. Week: Peter Thiemann
    1. Data analysis I (pdf), Programming I (pdf), 29/01/2018
    2. Programming II (pdf), 30/01/2018
    3. Programming III (pdf), Data analysis II (pdf), 01/02/2018
  2. Week: Georg Lausen
    1. Introduction to Databases (pdf), 02/02/2018
    2. SQL Querying I (pdf), 05/02/2018
    3. SQL Querying II (pdf; create_db.sql; queries.sql), 06/02/2018
    4. Authorization (pdf), 07/02/2018
    5. Structuring SQL (pdf; oracle_json.sql), 08/02/2018
  3. Week: Christian Schindelhauer
    1. Introduction to Computer Networking (pdf), 09/02/2018
    2. Internet Protocols (pdf), 12/02/2018
    3. Network Algorithms (pdf), 13/02/2018
    4. Security (pdf), 14/02/2018
    5. Networks for Smart Grids (pdf), 15/02/2018

Exercise Sheets

  1. Exercise: Programming-01 (pdf; py), 29/01/2018
  2. Exercise: Programming-02 (pdf; py), 30/01/2018
  3. Exercise: Programming-03 (pdf; py), 01/02/2018
  4. Exercise: Programming+Databases-04 (pdf; py), 02/02/2018
  5. Exercise: Databases-05 (pdf; sql), 05/02/2018
  6. Exercise: Databases-06 (pdf; sql), 06/02/2018
  7. Exercise: Databases-07 (pdf; sql), 08/02/2018
  8. Exercise: Databases+Networking-08 (pdf; intro.pdf; xpath.py; test.xml; client.py; server_mod.py), 09/02/2018
  9. Exercise: Networking-09 (pdf), 12/02/2018
  10. Exercise: Networking-10 (pdf; ex_10.pdf), 13/02/2018

Tools

  1. PIP Install script: https://bootstrap.pypa.io/3.2/get-pip.py

Exam

Literature

  • Learning Python. Mark Lutz, O'Reilly Media, 2013
  • Database Management Systems. Raghu Ramakrishnan, Johannes Gehrke, McGraw-Hill, 2002
  • Computer Networks. Andrew S. Tannenbaum, Prentice Hall, 2010
  • Computer Networking: A Top Down Approach 5th edition. Jim Kurose, Keith Ross, Addison-Wesley, 2009