Database Systems (Spring 2017/18) - Slides & Schedule

(back to course main page)

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