Lecture notes

No. Chapter Content Download Notes
1 [15/08/2016] Chapter 0 Overview of a DBMS Chapter 0
2 [22/08/2016] Chapter 1

Disk Storage, Basic File Structures, and Hashing Chapter 1 Exercises 1
3 [29/08/2016] Chapter 2 Indexing Structures for Files Chapter 2
4 [05/09/2016] Chapter 2 (cont) Indexing Structures for Files
5 [12/09/2016] Chapter 2 (cont) Indexing Structures for Files (cont) Exercises 2
6 [19/09/2016] Chapter 3 Algorithms for Query Processing and Optimization Chapter 3 TEST 1
7 [26/09/2016] Chapter 3 (cont) Algorithms for Query Processing and Optimization (cont)
8 [03/10/2016] OFF (Midterm)
9 [10/10/2016] Chapter 3 (cont) Algorithms for Query Processing and Optimization (cont) Exercises 3
10 [17/10/2016] TEST 2
11 [24/10/2016] Chapter 4 OFF
12 [31/10/2016] Chapter 4 Introduction to Transaction Processing Concepts and Theory Chapter 4 Exercises 4
13 [07/11/2016] Chapter 5 Concurrency Control Techniques Chapter 5 Exercises 5
14 [14/11/2016] Chapter 5 (cont) Concurrency Control Techniques (cont)
15 [21/11/2016] TEST 3
16 [28/11/2016] Chapter 6 Database Recovery Techniques Chapter 6 Exercises 6
17 [05/12/2016] Summary Review Assignment Submission!