CMPT 354 Fall 2013
Inactive links are under construction (not "permanently removed").
Instructor:
Oliver Schulte
Office Hours: Tuesday 10-11 am. Office Location: TASC 1 9021
Office Phone: 778-782-3390
E-mail Office Hour: W 10-11 am. Include 354 in the title otherwise emails may be ignored.
Office Hours: Tuesday 10-11 am. Office Location: TASC 1 9021
Office Phone: 778-782-3390
E-mail Office Hour: W 10-11 am. Include 354 in the title otherwise emails may be ignored.
Teaching Assistants:
TBA
Office Hours: TBA
Office Location: TBA
Office Hours: TBA
Office Location: TBA
Announcements
Course Resources
- Syllabus
- Course Schedule
- Database Management Systems' website
- Submission Server
- SFU Medical Excuse Form.
Midterm Resources
- Midterm Skeleton: Previous Instructions and Appendix.
- Link to Previous Midterm 1
- Link to Previous Midterm 2
- Link to Previous Midterm 3
Final Exam Resources
- Final Exam Instructions from previous term.
- Final Exam Info from previous term.
- Midterm Skeleton: Previous Instructions and Appendix.
- Link1 to Previous Exam
- Link2 to Previous Exam
External Learning Resources
- Database Management Powerpoint on XML.Systems textbook website
- Changes in SQL:99 standards
- The 24x7 on-line book collection, for reference material.
- Overview of ASP Net.
- Stanford Teaching Videos on Database Systems. You will need to register.
Sample Assignments
These are assignments from previous terms. They will give you a good idea of the assignment work required for this course.- Assignment 1:
- Download the assignment:
.
- Submission Instructions.
- Getting started with SQL Server.
- If you want to install a personal copy of SQL Server on your machine, you can use this: Installation Guide for the SQL Server 2012 Express. We can not promise support for all platforms. You can also use the setup in the CSIL lab, for which support is available.
- AdventureWorks Schema
- AdventureWorksLT.sql.db.zip
- Download the assignment:
- Assignment 2:
- Assignment 3.
- Download the assignment:
- Submission Instructions.
- For this assignment you can use a programming language of your choice to connect to a database, as long as it is compatible with the CSIL environment (see detailed instructions). If you want to use Visual Studio, here are some resources to get you started. CSIl provides further documentation. See also the assignment text for more information on Visual Studio.
- Download the assignment:
- Assignment 4.
- Download the assignment:
- Submission Instructions.
- Download the assignment:
Slides
-
Chapter 1
-
Chapter 2
-
Chapter 3
-
Chapter 4
-
Chapter 5
-
Chapter 6
-
Chapter 7
-
Chapter 8
-
Chapter 12
- Powerpoint on XML. PDF on XML.