Week

Session

Date

Topic

Teaching Method

Reading

Projects

Prob. Solving Assignments

1

1

7 Jan

Administrivia and Introduction

Lecture

Syllabus, R&G C1

 

 

 

2

9 Jan

The Entity-Relationship Model

Lecture

R&G C2

 

Start PS1

 

3

11 Jan

Case study on Entity Relationship Diagram

Recitation

Notes from TA

 

 

2

4

14 Jan

The Relational Model

Lecture

R&G C3

 

 

 

5

16 Jan

The Relational Model (Continued)

Lecture

R&G C3

 

 

 

6

18 Jan

Case study on Relational Algebra

Recitation

Notes from TA

 

 

3

7

21 Jan

Relational Algebra

Lecture

R&G C4.2

 

End PS1

 

8

23 Jan

Relational Calculus

Lecture

R&G C4.3

 

Start PS2

 

9

25 Jan

Hands-on Relational Algebra & TRC Expressions

Recitation

Notes from TA

 

 

4

10

28 Jan

The SQL Query Language (Part I)

Lecture

R&G C5

Start P1

 

 

11

30 Jan

The SQL Query Language (Part II)

 

 

 

 

 

12

1 Feb

Hands-on PostgreSQL

Recitation

Notes from TA

 

 

5

13

4 Feb

The SQL Query Language (Part III)

Lecture

R&G C5

 

End PS2

 

14

6 Feb

ORM

Lecture

Notes from the Instructor

 

 

 

15

8 Feb

Quiz I

N/A

N/A

 

 

6

16

11 Feb

Storing Data - Disks, Buffers,
and Files

Lecture

R&G C9

 

 

 

-

13 Feb

Sports Day

No Class

 

 

 

 

17

15 Feb

Hands-on Django

Recitation

Notes from TA

End P1

Start P2

 

7

18

18 Feb

File Organizations and Indexing & Midterm Overview

Lecture

Notes from the Instructor

 

 

 

19

20 Feb

Midterm

Exam 1

 

 

 

 

20

22 Feb

Overview of P2

Recitation

Notes from TA

 

 

8

21

25 Feb

Tree-Based Indexing Schemes

Lecture

R&G C10

 

Start PS3

 

22

27 Feb

Tree-Based Indexing Schemes (Part II)

Lecture

R&G C10

 

 

 

23

01 Mar

More on P2 and Django

Recitation

Notes from TA

 

 

Spring Break

March 4 - 9

9

24

11 Mar

Hash-Based Indexing Schemes

Lecture

R&G C11

 

 

 

25

13 Mar

A Brief Primer on Query Evaluation and External Sorting

Lecture

R&G C12 & C13

 

 

 

26

15 Mar

Case study on Query Plans and Cost Estimation + Overview of P3

Recitation

Notes from TA

 

 

10

27

18 Mar

External Sorting (Continued)

Lecture

R&G C12 & C13

 

End PS3

 

28

20 Mar

P2 Student Presentations

N/A

N/A

 

 

 

29

22 Mar

More on P3 - Understanding B+ Trees

Recitation

Notes from TA

End P2

Start P3

 

11

30

25 Mar

Relational Operators (Part I)

Lecture

R&G C12 & C14

 

Start PS4

 

31

27 Mar

Relational Operators (Part II)

Lecture

R&G C12 & C14

 

 

 

32

29 Mar

Query Optimization

Lecture

R&G C15

 

 

12

33

1 Apr

Query Optimization (Continued)

Lecture

R&G C15

 

 

 

34

3 Apr

Concurrency Control (Part I)

Lecture

R&G C16

 

 

 

35

5 Apr

Quiz II

N/A

N/A

 

 

13

36

8 Apr

Concurrency Control (Part II)

Lecture

R&G C16

 

End PS4

 

37

10 Apr

Logging and Recovery (Part I)

Lecture

R&G C16

 

Start PS5

 

38

12 Apr

Logging and Recovery (Part II)

Lecture

R&G C18

 

 

14

39

15 Apr

NoSQL Databases & Hadoop

Lecture

R&G C18

End P3

 

 

40

17 Apr

NoSQL Databases & Hadoop

Lecture

Notes from Instructor

 

 

 

41

19 Apr

Final Exam Review

Lecture

Notes from the Instructor

 

End PS5

 

42

TBA

Final

Exam 2