| Week |
Date |
Homework |
Slides |
Textbook |
| 1 |
4/11 |
|
Introduction to Database Systems
SQL Basic |
SQL For Web Nerds, Chapter 3
Book, Section 6.1-6.2 |
| 2 |
11/11 |
|
SQL Basics(cont.)
Advanced SQL |
Book, Section 6.1-6.2
Book, Section 6.3-6.4 |
| 3 |
18/11 |
HW#1 distributed |
Introduction to Oracle (Rubi Boim) - pptx
Introduction to Oracle (Rubi Boim) - pdf |
TAU Connection Guide
SQL foundamentals I
SQL foundamentals II
SQL Tuning |
| 4 |
25/11 |
|
SQL Schema, Views |
Book, Section 6.5-6.6
Book, Section 6.7 |
| 5 |
2/12 |
HW#1 due |
Constraints and Triggers, Transactions |
Book, Section 7
Book, Section 8 |
| 6 |
9/12 |
|
Conceptual DB Design
E/R Diagrams & Relational Model |
Book, Section 2.1-2.4
Book, Section 3.1-33 |
| 7 |
16/12 |
Project distributed |
Database Programming 1 (Rubi Boim)
Database Programming 1 |
JDBC Code Example
JDBC jar |
| 8 |
23/12 |
|
Database Programming 2 (Rubi Boim)
Database Programming 2 |
SWT
Thread Pooling |
| 9 |
30/12 |
|
Functional Dependencies & Relational Decomposition
Relational Algebra |
Book, Section 3.4-3.6
Book, 5.1-5.2 |
| 10 |
06/01 |
|
DBMS Internals
Storage and Indexing |
Book, Section 11
Book, Section 13.1 |
| 11 |
13/01 |
HW#2 distributed |
Indexing (cont.)
Query Execution
Query Optimization
Query Optimization (cont.) |
Book, Section 13.2-13.3
Book, Section 15 |
| 12 |
20/01 |
|
XML |
Book, Section 4.7 |
| 13 |
27/01 |
HW#2 due
Project due |
XML (cont.) |
Book, Section 4.7 |