Database Systems (Winter 2012) - Slides & Schedule

(back to course main page)

Week Date Homework Slides Textbook
1 01/11 Introduction to Database Systems
SQL Basic		 SQL For Web Nerds, Chapter 3
Book, Section 6.1-6.2
2 08/11 SQL Basics(cont.)
Advanced SQL		 Book, Section 6.1-6.2
Book, Section 6.3-6.4
3 15/11 HW#1 distributed Introduction to MySQL (Rubi Boim) TAU Connection Guide
SQL foundamentals I
SQL foundamentals II
SQL Tuning
- 22/11 Strike
4 29/11 SQL Schema, Views
Constraints and Triggers, Transactions		 Book, Section 6.5-6.6
Book, Section 6.7
Book, Section 7
Book, Section 8
5 06/12 HW#1 due Database Programming 1 (Rubi Boim) JDBC Code Example
JDBC Driver (MySQL)
6 13/12 Project distributed Database Programming 2 (Rubi Boim) SWT
Thread Pooling
- 20/12 No class this week..
7 27/12 Conceptual DB Design
E/R Diagrams & Relational Model		 Book, Section 2.1-2.4
Book, Section 3.1-33
8 03/01 HW#2 distributed Functional Dependencies & Relational Decomposition
Relational Algebra		 Book, Section 3.4-3.6
Book, 5.1-5.2
9 10-11/01 "Project Days"
10 17/01 DBMS Internals
Storage and Indexing		 Book, Section 11
Book, Section 13.1
11 24/01 HW#2 due Query Execution
Query Optimization
Query Optimization (cont.)		 Book, Section 13.2-13.3
Book, Section 15
12 31/01 Project due XML
XML (cont.)		 Book, Section 4.7
- 07/02 Project due
- 12/02 the Test.. (09:00)