Database Systems (Spring 2018/19) - Slides & Schedule

Note: Slides may be updated. If so, final versions will be uploaded few hours before each class. (back to course main page)

Week Date Homework Slides Textbook
1 16/10/2018 Introduction to Database Systems
SQL Basic
SQL For Web Nerds, Chapter 3
Book, Section 6.1-6.2
2 23/10/2018 SQL Basics(cont.)
Advanced SQL
Book, Section 6.1-6.2
Book, Section 6.3-6.4
3 06/11/2018 HW#1 distributed Introduction to MySQL (Amit) TAU Connection Guide
SQL foundamentals I
SQL foundamentals II
SQL Tuning
4 13/11/2018 SQL Schema, Views
Constraints and Triggers, Transactions
Book, Section 6.5-6.6
Book, Section 6.7
Book, Section 7
Book, Section 8
5 20/11/2018 Conceptual DB Design
E/R Diagrams & Relational Model
Book, Section 2.1-2.4
Book, Section 3.1-33
6 27/11/2018 HW#1 due,
Project distributed
Database Programming (Amit)
7 04/12/2018 Web Programming (Amit) code
8 11/12/2018 HW#2 distributed Functional Dependencies & Relational Decomposition
Relational Algebra
Book, Section 3.4-3.6
Book, 5.1-5.2
9 18/12/2018 DBMS Internals
Storage and Indexing
Book, Section 11
Book, Section 13.1
10 25/12/2018 HW#2 due "Projects Day" Location: Schriber M20
11 01/01/2019 Query Execution
Query Optimization
Book, Section 13.2-13.3
Book, Section 15
12 08/01/2019 Query Optimization (Cont.)
- 22/01/2019 Project due (23:55)
- 29/01/2019 Exam, Moed A. (09:00)
- 26/02/2019 Exam, Moed B. (09:00)