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
- Course Schedule
- Solutions to textbook Practice Exercises
- Clicker questions from in class
Week 1
- Laptop multitasking hinders classroom learning for both users and nearby peers
- Introduction
- Assignment: Introduction
- Due Wed Apr 03 11:10:00 CDT 2019
- Late days remaining: check back here throughout the term
- Due Wed Dec 31 18:00:00 CST 1969
Week 2
- The seminal 1970 paper from E.F. Codd
- ... and a response pointing out some incomplete details
- In class SQL demos
- SQL style guide
- Assignment: Relational Model
- Due Mon Apr 08 11:10:00 CDT 2019
- Assignment: Relational Algebra
- Due Wed Apr 10 11:10:00 CDT 2019
- SQL course enrollment
- Assignment: SQL Course Enrollment, Part 1
- Due Fri Apr 12 12:00:00 CDT 2019
- Partner pairings
- Due Wed Dec 31 18:00:00 CST 1969
Week 3
- Assignment: SQL Course Enrollment, Part 2
- Due Mon Apr 15 11:10:00 CDT 2019
- Exam 1 topics
- Exam 1 (calendar entry and grades)
- Due Wed Apr 17 11:10:00 CDT 2019
- More SQL problems
- More SQL problems (problems 1 and 2)
- Due Fri Apr 19 12:00:00 CDT 2019
- More SQL 1 and 2 solution
Week 4
- SQL Injection Attacks
- SQL Injection Attacks (individual)
- Due Mon Apr 22 11:10:00 CDT 2019
- More SQL problems (problem 3)
- Due Wed Apr 24 11:10:00 CDT 2019
- Design theory: analytical
- Due Fri Apr 26 12:00:00 CDT 2019
Additional reading, if interested
- Some hard drive specs from Seagate
- Some SSD specs from Seagate
- Anatomy of a Solid-state Drive
- Coding for SSDs
Week 5
- Design theory: programming
- Design theory: programming (pair)
- Due Mon Apr 29 11:10:00 CDT 2019
- Block organization
- Block organization, part 1
- Due Fri May 03 12:00:00 CDT 2019
Week 6
- Peer evaluations for pair programming, and new partner preferences
- Due Tue May 07 10:00:00 CDT 2019
- Block organization, part 2
- Due Wed May 08 11:10:00 CDT 2019
- Exam 2 topics
- Exam 2 (calendar entry and grades)
- Due Fri May 10 12:00:00 CDT 2019
- B+ tree visualization
Week 7
- Partner pairings, round 2
- Due Wed Dec 31 18:00:00 CST 1969
- B+ tree
- B+ tree (pair)
- Due Fri May 17 12:00:00 CDT 2019
Week 8
- Extendable hashing
- Extendable hashing (individual)
- Due Fri May 20 11:10:00 CDT 2016
- Query processing
- Query processing (individual)
- Due Fri May 24 12:00:00 CDT 2019
Week 9
- Query optimization
- Query optimization (individual)
- Due Mon May 27 11:10:00 CDT 2019
- Exam 3 topics
- Exam 3 (calendar entry and grades)
- Due Wed May 29 11:10:00 CDT 2019
- Password for query optimization team assignment
- Optimization of slow queries (pair)
- Due Fri May 31 12:00:00 CDT 2019
Week 10
- Optimization of slow queries
- Final paper
- Mongo DB in-class lab
- Final paper: references
- Due Tue Jun 04 22:00:00 CDT 2019
- Final paper: complete. No extensions allowed, by college policy, without permission of a class dean.
- Due Mon Jun 10 21:30:00 CDT 2019
- Peer evaluations
- Due Mon Jun 10 21:30:00 CDT 2019
- Moodle forum participation
- Due Wed Dec 31 18:00:00 CST 1969