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