Database Systems (Spring 2012/13) - Slides & Schedule
| Week | Date | Homework | Slides | Textbook |
|---|---|---|---|---|
| 1 | 26/02/2013 | Introduction to Database Systems SQL Basic SQL Basics(cont.) |
SQL For Web Nerds, Chapter 3 Book, Section 6.1-6.2 |
|
| 2 | 05/03/2013 | SQL Basics(cont.) Advanced SQL SQL Schema, Views |
Book, Section 6.1-6.2 Book, Section 6.3-6.5 Book, Section 6.6 |
|
| 3 | 12/03/2013 | HW#1 distributed | Introduction to MySQL SQL Schema, Views |
TAU Connection Guide SQL foundamentals I SQL foundamentals II SQL Tuning |
| 4 | 19/03/2013 | SQL Schema, Views Constraints and Triggers, Transactions Database Programming 1 |
Book, Section 6.6 Book, Section 7 Book, Section 8 |
|
| - | 26/03/2013 | Passover vacation | ||
| - | 02/04/2013 | Passover vacation | ||
| 5 | 09/04/2013 | HW#1 due Project distributed |
Database Programming 1 |
JDBC Code Example JDBC Driver (MySQL) |
| - | 16/04/2013 | Independence day vacation | ||
| 6 | 23/04/2013 | Database Programming 2 Conceptual DB Design E/R Diagrams & Relational Model |
SWT Thread Pooling SWT Examples Book, Section 4.1-4.2 |
|
| 7 | 30/04/2013 | E/R Diagrams & Relational Model Functional Dependencies & Relational Decomposition Relational Algebra |
Book, Section 4.1-4.6 Book, Section 2.1-2.4 Book, Section 3.1-3.6 Book, 5.1-5.2 |
|
| 8 | 07/05/2013 | HW#2 distributed | -- | Book, Section 11 Book, Section 13.1 |
| - | 14/05/2013 | Shavuot vacation | ||
| 9 | 21/05/2013 | HW#2 due | "Project Days" | |
| 10 | 28/05/2013 |
Relational Algebra DBMS Internals Storage and Indexing |
Book, Section 11 Book, Section 13.1 |
|
| 11 | 04/06/2013 | Storage and Indexing Query Execution Query Optimization |
Book, Section 13.2-13.3 Book, Section 15 |
|
| 12 | 11/06/2013 |
Query Optimization Advanced Topics |
||
| 13 | 18/06/2013 | Project due | Summary and exam rehearsal | Databases 2011-2012 (fall) Databases 2011-2012 (spring) All previous tests |
| - | 02/07/2013 | the Test.. (09:00) | ||
| - | 02/09/2013 | Moed B (09:00) |