Text: We will use a variety of online sources for this course, including online documentation for MySQL and Postgres.
The following text is optional, though recommended for students who have not taken a database course previously: Elmasri & Navathe, Fundamentals of Database Systems 7e, Pearson 2015, ISBN-13: 978-0133970777. The 6th edition is almost as complete. Course notes will refer to this text, but will provide nearly equivalent coverage.
There will be some homework assignments during the semester, plus a midterm and final. The assignments will be worth about 15-20% of your grade, the midterm 35-40%, and the final about 45%. The midterm is set for March 16 (week 8); the final will be Monday, April 27, at our usual time.
My general course groundrules are
My primary notes have now been divided into topic-specific files:
There are also brief notes for each class meeting:
|Week 1: Jan 13
||Jan 20: no class|
|Week 2: Jan 27||Week 3: Feb 3|
|Week 4: Feb 10||Week 5: Feb 17|
|Week 6: Feb 24||Mar 2: no class|
|Week 7: Mar 9||Week 8: Mar 16|
|Week 9: Mar 23||Week 10: Mar 30|
|Week 11: Apr 6||Week 12: Apr 13|
|Week 13: Apr 20
||Final: Apr 27|
(On Windows systems this is unnecessarily difficult. The best approach is to make sure psql is in your %PATH%; an alternative is to copy the file into the appropriate system directory that contains psql.exe.)