Announcement

  1. Assignment 1 Description
  2. Term Project Term Project Description
  3. Homework 1 Homework 1 Description
  4. Midterm Exam is scheduled on 23rd at 7pm in the same class room
  5. PHP Tutorial Session is scheduled on this Thursday (19th) at 7pm in Linux Lab

Syllabus

Hours

  • Tue, Thu 09:30 - 11:45

Textbook

  • Database Systems Concepts, 6th Edition
    (by Abraham Silberschatz, Henry F. Korth, S. Sudarshan) - McGraw-Hill

Piazza

References

Grading

  • Midterm and Final exams - 25% / 25%
  • SQL Homeworks - 10%
  • Assignments - 40%
* Subject to change

Lecture Slides

# Date Topic Slide Note
1 11.26 Ch 1 and Ch 11 Intro. and B+-Tree
Lecture 01.1
Lecture 01.2
2 11.28 Ch 2 and Ch 3 Relational Model and SQL
Lecture 02.1
Lecture 02.2
3 12.03 Ch 3 SQL
Lecture 03.1
4 12.05 Ch 4 SQL
Lecture 04.1
5 12.09 Ch 6 Formal Relational Languages
Lecture 05.1
Lecture 05.2
6 12.12 Ch 7 ER-model
Lecture 06.1
Lecture 06.2
7 12.17 Ch 5 JDBC,ODBC, and Advanced SQL
Lecture 07.1
8 12.19 Ch 8 Normal Forms
Lecture 08.1
9 1.7 Ch 10 Storage and File Structures
Lecture 09.1
Lecture 09.2
10 1.9 Ch 11 Indexing and Hashing
Lecture 10.1
11 1.14 Ch 12 Query Processing
Lecture 11.1
12 1.16 Ch 13 Query Optimization
Lecture 12.1
1.21 No Class
13 1.23 Ch 14 Transactions
Lecture 13.1
14 1.28 Ch 15 Concurrency Control
Lecture 14.1
15 2.3 (Make-up) Ch 15, CH 16 Recovery
Lecture 15.1
17 2.4 Ch 16
18 2.6 Project Demonstration
19 2.11 Final Exam


Link :