Database Systems (Fall 2022)

• Syllabus

Lecture Notes

• Week 01: Introduction to DBMS
  
  

• Week 02-05: Data Modeling and SQL
  
  

• Week 06-07: Joins and Subqueries
  
  

• Week 08: Midterms
  
  

• Week 09: Revisit and Practice Multiple Joins
  
  

• Week 10: Practice Data Modeling and Cases Studies
  
  

• Week 11: ER Diagrams
  
  

• Week 12: Database Normalization 

• Week 13: Revision 

• Week 14: Transaction Management and Concurrency Control

Assignments