Lecture Location and Time
From Week 1 to Week 17, Period 5 to Period 7.
- Class 1: Room B405 (Thursday).
- Class 2: Room J201 (Friday).
Syllabus
- Week 1: Introduction (ch0, ch1)
- Week 2: Introduction to Relational Languages (ch2)
- Week 3-7: SQL (ch3, 04_lab, 05, 06, 07)
- Week 8: E-R Model(08)
- Week 9-10: Relational Database Design (er2, 09_norm)
- Week 11: Complex Data Types(data_type)
- Week 12: Advanced SQL (advanced)
- Week 13: Application Development(app)
- Week 14: Presentation
- Week 15: Indexing(index)
- Week 16: Transactions(transaction)
- Week 17: Final Exam
Note that this course is application-oriented, and it is highly recommended to read Database System Concepts, 7th Edition if you want to learn more about database systems.
Resources
- [email protected]: for codes and exercises
- [email protected]: for codes and exercises (if your network is unable to connect to GitHub)
- Lark: for online discussion