Database Systems (Winter 2009-2010) - Slides & Schedule

(back to course main page)

Week Date Homework Slides Textbook
1 20/10 Introduction to Database Systems
SQL Basic		 SQL For Web Nerds, Chapter 3
Book, Section 6.1-6.2
2 27/10 SQL Basics(cont.)
Advanced SQL		 Book, Section 6.1-6.2
Book, Section 6.3-6.4
3 03/11 HW#1 distributed Introduction to Oracle - pptx
Introduction to Oracle - pdf		 TAU Connection Guide
SQL foundamentals I
SQL foundamentals II
SQL Tuning
4 10/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 17/11 HW#1 due Conceptual DB Design
E/R Diagrams & Relational Model		 Book, Section 2.1-2.4
Book, Section 3.1-33
6 24/11 Project distributed Database Programming 1
Database Programming 1		 JDBC Code Example
JDBC jar
7 01/12 Database Programming 2
Database Programming 2		 SWT
Thread Pooling
8 08/12 Functional Dependencies & Relational Decomposition
Relational Algebra		 Book, Section 3.4-3.6
Book, 5.1-5.2
9 15/12 DBMS Internals
Storage and Indexing		 Book, Section 11
Book, Section 13.1
10 21-22/12 "Project Days"
11 29/12 HW#2 distributed Query Execution
Query Optimization
Query Optimization (cont.)		 Book, Section 13.2-13.3
Book, Section 15
12 05/01 XML
XML (cont.)		 Book, Section 4.7
13 12/01 HW#2 due Collaborative Filtering - pptx
Collaborative Filtering
14 19/01 Project due NO Class...
15 04/02 Rehearsal, Schreiber 006 at 16:00
16 07/02 the Test.. (09:00)