I use Moodle for my courses, which makes it challenging to make my
course content public. The website you see below is an automatically
generated approximation of my Moodle page, based on a script that I've
run.
General materials
- Syllabus
- Solutions to textbook Practice Exercises
- Clicker questions from in class
Week 1
- The Pen Is Mightier Than the Keyboard
- Assignment: Introduction
- Due Tue Sep 13 23:55:00 CDT 2016
- Assignment: Relational Model
- Due Sat Sep 17 23:55:00 CDT 2016
Week 2
- Assignment: Relational Algebra
- Due Mon Sep 19 23:55:00 CDT 2016
- Assignment: SQL Part 1
- Due Wed Sep 21 23:55:00 CDT 2016
- Assignment: SQL Part 2
- Due Sat Sep 24 23:55:00 CDT 2016
Week 3
- More SQL problems (problems 1 and 2)
- Due Mon Sep 26 23:55:00 CDT 2016
- More SQL problems (problem 3)
- Due Wed Sep 28 23:55:00 CDT 2016
- Design theory: analytical
- Due Sat Oct 01 23:55:00 CDT 2016
Week 4
- Design theory: programming
- Due Wed Oct 05 23:55:00 CDT 2016
- Additional reading, if interested
- Some hard drive specs from Seagate
- Some SSD specs from Samsung
- Anatomy of a Solid-state Drive
- Coding for SSDs
- Block organization, part 1
- Due Sat Oct 08 23:55:00 CDT 2016
Week 5
- Block organization, part 2
- Due Mon Oct 10 23:55:00 CDT 2016
- Exam 1 topics
- Exam 1: Wednesday, October 12
- Buffer Manager, part 1
- Due Sat Oct 15 23:55:00 CDT 2016
Week 6
- Buffer Manager, part 2
- Due Wed Oct 19 23:55:00 CDT 2016
- B+ tree visualization
- Buffer Manager, part 3
- Due Sat Oct 22 23:55:00 CDT 2016
Week 7
- B+ tree (individual)
- Due Wed Oct 26 23:55:00 CDT 2016
Week 8
- Extendable hashing (individual)
- Due Mon Oct 31 23:55:00 CDT 2016
- Query optimization 1, team
- Due Sat Nov 05 23:55:00 CDT 2016
Week 9
- Query optimization 2, individual
- Due Mon Nov 07 23:55:00 CST 2016
- MongoDB in-class lab
Week 10
- Exam 2 topics
- Exam 2: Wednesday, November 16
- Final paper: references
- Due Mon Nov 14 23:55:00 CST 2016
- Final paper: complete. No extensions allowed, by college policy, without permission of a class dean.
- Due Mon Nov 21 21:30:00 CST 2016