The course syllabus is here.
The two books are available online through the UofT library: SQL and RDD. You can also buy a copy in the U of T book store.
Here is a practice final exam.
Here is a revised version of the CGI example and the updated instructions on installing it. This version has has more comments and is a bit more complicated than the earlier one. You can use it as a basis for your own web interface. (Updated at 7:35 pm on March 14.)
Here are the details on handling external transfers in your final projects, including sample files.
Examples from today's class are here: cgi2.zip. (The installation instructions are the same as the previous week.)
The answers to assignment 2 are here.
Here is the final CGI file we used in class, and the instructions on installing it.
The final project assignment is here.
Here is the code from today's lecture: university.sql.
Here are the answers to Assignment 1. The last slide of today's slide stack has the distribution.
Assignment 2 is now available and is due on February 14.
Assignment 1 is now available and is due on January 24.
All effort will be made to post slides before class. On some days we might end up not getting through all the slides planned for the lecture. In this case, you will see those slides repeated in the next week's presentation. Slide files uploaded before the class will be updated to correct any inaccuracies or sometimes to add information that was presented in class interactively. Such slides will be marked with an *. They won't be updated, however, just to remove the slides that we didn't get through.
|Week 1:||PDF*, ODP*||Week 5:||PDF, ODP||Week 9:||PDF, ODP|
|Week 2:||PDF*, ODP*||Week 6:||PDF*, ODP*||Week 10:||PDF*, ODP*|
|Week 3:||PDF*, ODP*||Week 7:||PDF*, ODP*||Week 11:||PDF, ODP|
|Week 4:||PDF*, ODP*||Week 8:||PDF, ODP||Week 12:||PDF, ODP|