Education > Information Central > Course Central > CS Instructional Labs
Database Systems I [CMPT 354-D1] - Fall 2010 Course Home Page
Instructor: Richard Frank Ph.D.
Slides
Week 01: Introduction [PPTX] [PDF]
Week 02:
Tuesday: ER Model [PPTX] [PDF]
Thursday: Relational Model [PPTX] [PDF] Updated 09/16
Recommended reading for comparison of E-R Model and Relational Model: [click]
Week 03: Tuesday: ER Model to Relational Model to SQL [PPTX] [PDF]
Thursday: Overview of SQL Server 2008. No slides. Bring computer if desired.
Week 04: Tuesday: Relational Algebra [PPTX] [PDF] Link Fixed 09/27 6:10pm
Thursday: Query Optimization & Relational Algebra [PPTX] [PDF]
Week 05: Tuesday: SQL [PPTX] [PDF]
Thursday: Math & Ordering [PPTX] [PDF]
Week 06: Tuesday: Triggers/Procedures [PPTX] [PDF]
Thursday: Review [PPTX] [PDF]
Week 08/09: Normal Form, Server Architecture, Application Development [PPTX] [PDF]
Good example of Procedures: http://www.sql-server-performance.com/articles/dba/stored_procedures_basics_p1.aspx
Week 09 Thu: Database Hacking [PPTX] [PDF]
Week 10: Tue: Internet Applications [PPTX] [PDF]
Thu: Poppies [PPTX] [PDF]
Week 11: Tue: XMLPath and XMLQuery [PPTX] [PDF]
Thu: Search Engines [PPTX] [PDF]
Week 12: Data Warehousing [PPTX] [PDF]
Week 13: Various Topics in Databases [PPTX] [PDF]
Review [PPTX] [PDF]
Review Full [PPTX] [PDF]
Last Update:12/03/2010