Database Systems (Fall 2012/13) - Slides & Schedule

(back to course main page)

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