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) |