avatar

Zhongpu Chen

PhD

Fall 2021 (Database Principles and Applications)

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