Overview | Lecture and Exercise Times | Course Material | People

Date |
Topic |
Material |
Reading Assignment |

20.09.2018 | Introduction | [slides] | Chapter 1 |

27.09.2018 | Relational Model | [slides] | Chapters 2.1 and 2.2 |

04.10.2018 | Data Definition with SQL | [slides] | Chapters 2.3 and 6.5.1 |

11.10.2018 | Relational Algebra | [slides] | Chapters 2.4, 6.5.* and 7 |

18.10.2018 |
Queries with SQL | [slides] | Chapters 6.1, 6.2, 6.3, and 6.4 |

01.11.2018 |
Database Design Theory | [sildes] | Chapters 3.1, 3.2, 3.3, and 3.4 |

15.11.2018 | The ecosystem around SQL | [slides] | Chapters 9.1, 9.2 and 9.6 |

22.11.2018 | Views and Indices | [slides] | Chapters 8.1, 8.2, 8.3 and 8.4 |

06.12.2018 | Cubes and OLAP | [slides] | Chapters 10.6 and 10.7 |

13.12.2018 | Database Architcture | [slides] | Chapters 13.1, 13.2 and 13.5 |

20.12.2018 | Outlook | [slides] |

**Note: **All reading assignments are from "Garcia-Molina, Hector and Ullman, Jeffrey D. and Widom, Jennifer, Database Systems: The Complete Book, Second Edition"

Date |
Topic |
Material |
Solution |

27-28.09.2018 | Introduction | [instructions][exercise] | [solution] |

04-05.10.2018 | Relational Model | [exercise] | [solution] |

11-12.10.2018 | Data Definition with SQL (Part I) | [exercise] | [solution] |

18-19.10.2018 | Data Definition with SQL (Part II) | ||

25-26.10.2018 | Relation Algebra | ||

1-2.11.2018 | Queries with SQL (Part I) | [notebook] | [solution] |

8-9.11.2018 | Queries with SQL (Part II) | [ungraded][graded] | |

15-16.11.2018 | Database Design Theory (Part I) | [exercise] | [solution] |

22-23.11.2018 | Database Design Theory (Part II) |
[exercise] |
[solution] |

29-30.11.2018 | Transactions | [solution] | |

06-07.12.2018 | Views and Indices |
[exercise] |
[solution] |

13-14.12.2018 | Cubes and OLAP |
[notebook] |
[solution] |

20-21.12.2018 | Past Exams |
[Feb 2018] [Aug 2018] |