Week

Session

Date

Topic

Type

Course work

1

1

12 Jan

Administrivia and Introduction

Lecture

 

 

2

14 Jan

The Entity-Relationship Model

Lecture

Start PS1

 

3

16 Jan

Case study on Entity Relationship Diagram

Recitation

 

2

4

19 Jan

The Relational Model

Lecture

 

 

5

21 Jan

The Relational Model (Continued)

Lecture

 

 

6

23 Jan

Case study on Relational Algebra

Recitation

 

3

7

26 Jan

Relational Algebra

Lecture

 

8

28 Jan

Relational Calculus

Lecture

End PS1

 

---

29 Jan

--

--

Start PS2

 

9

30 Jan

Hands-on Relational Algebra

Recitation

 

4

10

2 Feb

The SQL Query Language (Part I)

Lecture

 

 

11

4 Feb

The SQL Query Language (Part II)

Lecture

 

 

12

6 Feb

Hands-on PostgreSQL

Recitation

5

13

9 Feb

The SQL Query Language (Part III)

Lecture

Start P1

 

 

11 Feb

Sports Day

No Class

 

 

 

12 Feb

--

--

End PS2

 

14

13 Feb

TRC expressions and Quiz I review

Recitation

6

15

16 Feb

SQL - Discussion

Lecture

 

 

16

18 Feb

Quiz I & SQL Wrap Up

Lecture

 

 

17

20 Feb

Introduction to ORM

Recitation

 

7

18

23 Feb

Intro to Disks and Files (Part I)

Lecture

 

 

19

25 Feb

Disks & Files - Part II (More on RAID & Disk Management)

Lecture

End P1

 

20

27 Feb

Django & PostgreSQL Introduction

Recitation

Start P2

Spring Break

March 1 - 5

8

21

8 Mar

Midterm

Exam 1

 

 

22

10 Mar

Class Cancelled

Lecture

 

 

23

12 Mar

Django (User Profiles)

Recitation

--

13 Mar

--

--

Start PS3

9

24

15 Mar

Disks & Files Part II

Lecture

 

 

25

17 Mar

File Organizations and Indexing

Lecture

 

 

26

19 Mar

More on Django

Recitation

 

10

27

22 Mar

Tree-Based Indexing Schemes

Lecture

 

28

24 Mar

External Sorting (Continued)

N/A

 

 

 

25 Mar

--

--

End P2

 

29

26 Mar

Understanding B+ Trees

Recitation

11

30

29 Mar

Tree-Based Indexing Schemes (Part II)

 

 

--

30 Mar

--

--

Start P3

 

31

31 Mar

More on Storing

Lecture

End PS3

 

32

2 Apr

P3 Overview

Recitation

 

12

33

5 Apr

Algorithms for Relational Operations

Lecture

 

34

7 Apr

Algorithms for Relational Operations (Part II)

Lecture

Start PS4

 

35

9 Apr

QueryOptimization

Lecture

 

13

36

12 Apr

Query Optimization (Part II)

Lecture

 

 

37

14 Apr

Transaction Management

Lecture

 

--

15 Apr

--

--

End PS4

 

38

16 Apr

TBA

Lecture

 Start PS5

--

18 Apr

--

--

End P3

14

39

19 Apr

Logging and Recovery (Part I)

Lecture

 

40

21 Apr

Logging and Recovery (Part II)

Lecture

 

 

41

23 Apr

NoSQL Databases & Hadoop

Lecture

End PS5

 

42

TBA

Final

Exam 2