Database Systems (Spring 2014/15) - Slides & Schedule

(back to course main page)

Week Date Homework Slides Textbook
1 10/03/2015 Introduction to Database Systems
SQL Basic		 SQL For Web Nerds, Chapter 3
Book, Section 6.1-6.2
- 17/03/2015 No class this week (Election day)
2 24/03/2015 SQL Basics(cont.)
Advanced SQL		 Book, Section 6.1-6.2
Book, Section 6.3-6.4
- 31/03/2015 No class this week (Thursday makeup day)
- 07/04/2015 Passover
3 14/04/2015 HW#1 distributed Introduction to MySQL (Yael) TAU Connection Guide
SQL foundamentals I
SQL foundamentals II
SQL Tuning
4 21/04/2015 SQL Schema, Views
Constraints and Triggers, Transactions		 Book, Section 6.5-6.6
Book, Section 6.7
Book, Section 7
Book, Section 8
5 28/04/2015 HW#1 due
Project distributed		 Database Programming 1 (Yael) JDBC Code Example
6 05/05/2015 Database Programming 2 (Yael) SWT
SWT Examples
7 12/05/2015 Conceptual DB Design
E/R Diagrams & Relational Model		 Book, Section 2.1-2.4
Book, Section 3.1-33
8 19/05/2015 HW#2 distributed Functional Dependencies & Relational Decomposition
Relational Algebra		 Book, Section 3.4-3.6
Book, 5.1-5.2
9 25/05/2015 "Project Days"
10 02/06/2015 HW#2 due DBMS Internals
Storage and Indexing		 Book, Section 11
Book, Section 13.1
11 09/06/2015 Query Execution
Query Optimization		 Book, Section 13.2-13.3
Book, Section 15
12 16/06/2015 Query Optimization (Cont.)
- 12/07/2015 The test (09:00)
- 11/09/2015 Makeup test (Moed B. 09:00)