Week

Session

Date

Topic

Teaching Method

Reading

Projects

Prob. Solving Assignments

1

1

11 Jan

Administrivia and Introduction

Lecture

Syllabus, R&G C1

 

 

 

2

13 Jan

The Entity-Relationship Model

Lecture

R&G C2

 

Start PS1

 

3

15 Jan

Case study on Entity Relationship Diagram

Recitation

Notes from TA

 

 

2

4

18 Jan

The Relational Model

Lecture

R&G C3

 

 

 

5

20 Jan

Relational Algebra

Lecture

R&G C4.2

 

 

 

6

22 Jan

Case study on Relational Algebra

Recitation

Notes from TA

 

End PS1

3

7

25 Jan

Relational Calculus

Lecture

R&G C4.3

 

Start PS2

 

8

27 Jan

The SQL Query Language (Part I)

Lecture

R&G C5

 

 

 

9

29 Jan

Hands-on PostgreSQL + Overview of P1

Recitation

Notes from TA

Start P1

 

4

10

01 Feb

The SQL Query Language (Part II)

Lecture

R&G C5

 

 

 

11

03 Feb

Storing Data – Disks, Buffers,
and Files

Lecture

R&G C9

 

 

 

12

05 Feb

More hands-on PostgreSQL

Recitation

Notes from TA

 

End PS2

5

13

08 Feb

File Organizations and Indexing

Lecture

R&G C8

 

 

 

14

10 Feb

Qatar National Sports Day; No Class

 

 

 

 

 

15

12 Feb

Database Connectivity in Java (JDBC)

Recitation

Notes from TA

End P1

 

6

16

15 Feb

Tree-Based Indexing Schemes

Lecture

R&G C10

Start P2

 

 

17

17 Feb

Hash-Based Indexing Schemes

Lecture

R&G C11

 

Start PS3

 

18

19 Feb

Overview of P2 with a focus on JSPs

Recitation

Notes from TA

 

 

7

19

22 Feb

Review for midterm

Lecture

Notes from the Instructor

 

 

 

 

24 Feb

Midterm

Exam 1

 

 

 

 

20

26 Feb

More on P2

Recitation

Notes from TA

 

 

8

 

01 – 05 Mar

Spring Break; No Classes

 

 

 

End PS3

on 01 Mar

9

21

08 Mar

A Brief Primer on Query Evaluation and External Sorting

Lecture

R&G C12 & C13

 

Start PS4

 

22

10 Mar

Relational Operators (Part I)

Lecture

R&G C12 & C14

End P2

 

 

23

12 Mar

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

Recitation

Notes from TA

Start P3

 

10

24

15 Mar

Relational Operators (Part II)

Lecture

R&G C12 & C14

 

 

 

25

17 Mar

Query Optimization

Lecture

R&G C15

 

 

 

26

19 Mar

Overview of P3

Recitation

Notes from TA

 

 

11

27

22 Mar

Parallel and Distributed DBMSs

Lecture

R&G C22

 

End PS4

 

28

24 Mar

Big Data and Hadoop

Lecture

Notes from the Instructor

 

 

 

29

26 Mar

Simple ISAM in C

Recitation

Notes from TA

End P3

 

12

30

29 Mar

No-SQL Databases: The Google’s BigTable

Lecture

Notes from the Instructor

 

 

 

31

31 Mar

New-SQL

Lecture

Notes from the Instructor

Start P4

 

 

32

02 Apr

Overview of P4 + Hands-on MapReduce

Recitation

Notes from TA

 

Start PS5

13

33

05 Apr

Concurrency Control (Part I)

Lecture

R&G C17

 

 

 

34

07 Apr

Concurrency Control (Part II)

Lecture

R&G C17

 

 

 

35

09 Apr

More on P4 + HBase

Recitation

Notes from TA

 

 

14

36

12 Apr

Logging and Recovery (Part I)

Lecture

R&G C18

 

 

 

37

14 Apr

Logging and Recovery (Part II)

Lecture

R&G C18

 

 

 

38

16 Apr

More on P4

Recitation

Notes from TA

 

End PS5

15

39

19 Apr

TBD

Lecture

 

 

 

 

40

21 Apr

TBD

Lecture

 

 

 

 

41

23 Apr

Review for final

Recitation

Notes from the Instructor

End P4

 

16

 

26 Apr

Final

Exam 2