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
here.
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.)