Purdue CS448: Introduction To Relational Database Systems
|
Course DescriptionDatabase technology is one of the major contributions of computer science to the commercial world. The relational database model has been extremely successful in satisfying the requirements of modern applications. In this course, we will study the concepts, design, and implementation of relational database systems. We will cover the topics including relational database model, relational algebra, SQL query language, database design, storage, indexing, query processing, query optimization, and transaction management. If time allows, we will also highlight advanced topics such as distributed and parallel databases, cloud-native databases. |
Instructor
|
Teaching Assistants
|
Logistics
|
Labs and PSOs
PSO sessions start from the 3rd week.
|
Online communications
|
Textbooks
Note that the lectures slides are self-contained.
|
Grading
|
Academic Integrity and More
|
Schedule |
Lecture |
Topic |
Readings |
Lec 1 (01/11) |   Course Logistics & Introduction |
|
Lec 2 (01/13) |   Relational Model |
|
Lec 3 (01/18) |   Relational Algebra |
|
Lec 4 (01/20) |   SQL 1 |
|
Lec 5 (01/25) |   SQL 2 |
|
Lec 6 (01/27) |   Storage 1 |
|
Lec 7 (02/01) |   Storage 2 |
|
Lec 8 (02/03) |   Buffer Management |
|
Lec 9 (02/08) |   Index Overview |
|
Lec 10 (02/10) |   Tree Indexing |
|
Lec 11 (02/15) |   Hash Indexing |
|
Lec 12 (02/17) |   Overview of SQL Query Processing |
|
Lec 13 (02/22) |   Logical Query Optimization |
|
Lec 14 (02/24) |   Cancelled due to a conference |
|
Lec 15 (03/01) |   Physical Query Optimization |
|
Lec 16 (03/03) |   Mid-term exam (in-class) |
|
Lec 17 (03/08) |   Physical Query Optimization 2 |
|
Lec 18 (03/10) |   Query Evaluation |
|
Lec 19 (03/15) |   Cancelled due to Spring break |
|
Lec 20 (03/17) |   Cancelled due to Spring break |
|
Lec 21 (03/22) |   Overview of Transaction Management |
|
Lec 22 (03/24) |   Concurrency Control |
|
Lec 23 (03/29) |   Concurrency Control 2 |
|
Lec 24 (03/31) |   Crash Recovery |
|
Lec 25 (04/05) |   Crash Recovery 2 |
|
Lec 26 (04/07) |   Crash Recovery 3 |
|
Lec 27 (04/12) |   Distributed Databases |
|
Lec 28 (04/14) |   Distributed Databases 2 |
|
Lec 29 (04/19) |   Cloud Databases |
|
Lec 30 (04/21) |   Big Data |
|
Lec 31 (04/26) |   Big Data 2 |
|
Lec 32 (04/28) |   Review |
|