Topic outline

• Resources
  

  Resources

  • Announcements Forum
  • Northwind script File
  • Adventure works DW File
  • AdvantureWork DB File
  • Airline Reservation DB File
  • Adventure works OLTP Diagram File
  • Adventure works DW Diagram File
• Examinations
  

  Examinations

  
  

  • Mid-term examination - Advanced Databases. Quiz
  • Final 2022-2023 Quiz
  • Final 2022-2023 (copy) Quiz
  • Re-take Midterm Quiz
• Relational databases & advanced queries
  

  Relational databases & advanced queries

  • Lecture 1 File
  • Practice 1 File
  • Submission of Practice 1 (2022-2023) Assignment
• View, Stored Procedure, Function, and Trigger
  

  View, Stored Procedure, Function, and Trigger

  • Lecture 2 File
• Transaction and concurrency
  

  Transaction and concurrency

  • Sesssion 3 File
• Relational database performance tuning
  

  Relational database performance tuning

  • Practical 2 File
  • Submission for Practical session 2 Assignment
  • Session 4 File
• Data warehouse
  

  Data warehouse

  • Session 5 File
• Semi-structure databases - XML
  

  Semi-structure databases - XML

  • Session 6 File
• Object oriented databases
  

  Object oriented databases

  • Session 7 File
• No-SQL
  

  No-SQL

  • Restaurant DB for MongoDB File
  • Northwind for NoSQL File
  • Session 8 File
  • Practice 3 Page
  • Submission of practical session 3 Assignment
  • Setup a sharding system File