Database Systems (Spring 2013/14) - Slides & Schedule
Week | Date | Homework | Slides | Textbook |
---|---|---|---|---|
1 | 18/02/2014 | Introduction to Database Systems SQL Basic |
SQL For Web Nerds, Chapter 3 Book, Section 6.1-6.2 |
|
2 | 25/02/2014 | SQL Basics(cont.) Advanced SQL |
Book, Section 6.1-6.2 Book, Section 6.3-6.4 |
|
3 | 04/03/2014 | HW#1 distributed | Introduction to MySQL | TAU Connection Guide SQL foundamentals I SQL foundamentals II SQL Tuning |
4 | 11/03/2014 | SQL Schema, Views Constraints and Triggers, Transactions |
Book, Section 6.5-6.6 Book, Section 6.7 Book, Section 7 Book, Section 8 |
|
5 | 18/03/2014 | HW#1 due Project distributed |
Database Programming 1 (Yael) | JDBC Code Example JDBC Driver (MySQL) |
- | 25/03/2014 | No class this week | ||
6 | 01/04/2014 | Database Programming 2 (Yael) | SWT Thread Pooling SWT Examples |
|
7 | 08/04/2014 | Conceptual DB Design E/R Diagrams & Relational Model |
Book, Section 2.1-2.4 Book, Section 3.1-33 |
|
- | 15/04/2014 | Passover vacation | ||
- | 22/04/2014 | Passover vacation | ||
8 | 29/04/2014 | HW#2 distributed | Functional Dependencies & Relational Decomposition Relational Algebra |
Book, Section 3.4-3.6 Book, 5.1-5.2 |
- | 06/05/2014 | Independence day | ||
9 | 13/05/2014 | HW#2 due | "Project Days" | |
10 | 20/05/2014 | DBMS Internals Storage and Indexing |
Book, Section 11 Book, Section 13.1 |
|
11 | 27/05/2014 | Query Execution Query Optimization |
Book, Section 13.2-13.3 Book, Section 15 |
|
- | 03/06/2014 | Shavu'ot | ||
12 | 10/06/2014 | Query Optimization (Cont.) | ||
- | 15/06/2014, 10am | Project due | ||
- | 17/06/2014 | Rehearsal class, Orenstein 103 | ||
- | 01/07/2014 | the Test.. (09:00) | ||
- | 05/09/2014 | Moed B (09:00) |