Database Systems (Spring 2013/14) - Slides & Schedule

(back to course main page)

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)