This schedule includes a week by week summary of in-class activities, pre-class and post-class responsibilities, dates of exams, and due dates of quizzes, individual assignments, and project deliverables.
WEEK 1
Week’s Topics:
- Course Overview
- Relational DBs and Relational Algebra
- An Example DB: Sometime this week, start Assignment A-w2 (do task 1 by reading the paper) (2 hours)
To Do before January 9 class:
- NA
Class meeting (Tuesday, January 9 ):
- Course Overview — discussions, readings, quizzes, exams, projects; WSPDBC mini courses (http://online.stanford.edu/course/databases-self-paced); optional textbook (U/W) — see Organization.
- Start Hans Rosling Exercise
- Recorded lecture
To Do before January 11 class:
- Introduction to relational models (2.5 hours)
Class meeting (Thursday, January 11 ):
To Do after January 11 class:
- Submit Assignment A-w1 by Saturday, January 13 at 11:59 pm (2 hours)
- Reminder: start Assignment A-w2 (by reading the paper)
- Submit Data Diary entries by Saturday, January 13 at 11:59 pm (required for 5265, optional for 3265)
WEEK 2
Week’s Topics:
- SQL Basics
- An example DB in context
To Do before January 16 class:
- Introduction to SQL Tasks (3 hours)
- Quiz Q-w2 on Brightspace
Class meeting (Jan 16):
- Discuss Assignment A-w1 (A-w1 Key; A-w1 self mark form)
- A-w1 in SQL exercises (Key)
- A simple online retailer DB
- Recorded lecture
To Do before Jan 18 class:
Class meeting (Jan 18):
- Introduction to SQL Exercises 2 (no recorded lecture, but see selected solutions to exercises in class at the bottom)
- Quiz Q-w2 key (also covered in class)
To Do after Jan 18 class:
- Submit Assignment A-w2 on Brightspace by Saturday, January 20 at 11:59 pm (2 hours)
- Submit Data Diary entries by Saturday, January 20 at 11:59 pm (required for 5265, optional for 3265)
WEEK 3
Week’s Topics:
- Intermediate SQL
To Do BEFORE January 23 class:
- Intermediate SQL Tasks 1 (3 hours)
- Quiz Q-w3 (on Brightspace)
Class meeting (January 23):
- Intermediate SQL Exercises 1
- Discuss Assignment A-w2 (rubric)
- Discuss Quiz Q-w3
To Do BEFORE January 25 class:
- Intermediate SQL Tasks 2 (2 hours)
Class meeting (January 25):
- Discuss Assignment A-w2 (rubric)
- Intermediate SQL exercises 2
- GROUP BY and HAVING illustration
- Sample DBs on Dorm Energy Monitoring and Online Retailer
- Recorded Lecture
To Do after Jan 25 class:
- Submit Assignment A-w3 on Brightspace by Saturday, January 27 at 11:59 pm (2 hours)
- Submit Data Diary entries by Saturday, January 27 at 11:59 pm (required for 5265, optional for 3265)
WEEK 4
Week’s Topics:
- Constraints
- Referential Integrity
- Triggers
To Do BEFORE January 30 class:
- Constraints and Triggers Tasks 1 (2 hours)
- Quiz Q-w4 on Brightspace
Class meeting (January 30):
- Constraints and Triggers Exercises 1
- Discuss Quiz Q-w4 (key)
- Discuss Assignment A-w3 (rubric)
- Recorded Lecture
To Do BEFORE February 1 class:
- Constraints and Triggers Tasks 2 (2 hours)
Class meeting (February 1):
To Do after February 1 class:
- Submit Assignment A-w4 on Brightspace by Saturday, February 3 at 11:59 pm (Key and query questions; possible answers to query questions, also In Class February 20)
- Submit Data Diary entries by Saturday, February 3 at 11:59 pm (required for 5265, optional for 3265)
- Study for Exam 1 (2 hours estimate)
WEEK 5
Week’s Topics:
- Exam
- Database Conceptual Design
To Do BEFORE February 6 class:
- Study for Exam 1 (2 hour estimate).
In Class (February 6):
- Exam 1
To Do BEFORE February 8 class:
- Dream DB description (due Tuesday, Feb 6 at 11:59 PM)
In Class (February 8):
- Group intros and schedule meetings (submit individual descriptions of meeting before 9:30 am)
- Hand back Exam 1
To Do after February 8 class:
- Submit Data Diary entries by Saturday, February 10 at 11:59 pm (required for 5265, optional for 3265)
Submit Assignment A-w5 on Brightspace by Saturday, February 3 at 11:59 pm
WEEK 6
Week’s Topics:
- Unified Modeling Language
To Do BEFORE February 13 class:
- UML Tasks 1
- Quiz Q-w6 on Brightspace
In Class (February 13):
- UML Exercises 1
- Discuss Quiz Q-w6
- Recorded Lecture
To Do BEFORE February 15 class:
- UML Tasks 2 (1 hour)
In Class (February 15):
To Do after February 15 class:
- Submit Group Project Deliverable GPD1 on Brightspace by Friday, February 16 at 11:59 pm
- Submit Assignment A-w6 on Brightspace by Saturday, February 17 at 11:59 pm
- Submit Data Diary entries by Saturday, February 17 at 11:59 pm (required for 5265, optional for 3265)
- Optional Project Group Meetings on Sunday February 18
WEEK 7
Week’s Topics:
- Views
- Modification with Triggers
- Automatic View Modification
- Materialized Views
To Do BEFORE Feb 20:
- Views Task 1 (1.5 hours)
- Quiz Q-w7 on Brightspace
In Class (February 20):
- Views exercises (Exercises and accompanying handout)
- Discuss Assignment A-w6
- Discuss Queries from DormEnergy database (answers to query exercises given at end of assignment A-w4 key at end of Week 4)
- Pointer to Final Group Project specification
- Design issues, including “circularity” (Worksheet and key)
- Interrogating the supported functionality of a design
- Recorded Lecture
To Do BEFORE Feb 22:
- Views Tasks 2 (1 hour)
In Class (February 22):
- No class, but recorded lecture available on
- Finish views exercises (Exercises and accompanying handout)
- Interrogating the supported functionality of a design
- Discuss Final Group Project specification
- Review implementation resources — see TAs during office hours if you have difficulty downloading https://www.sqlite.org and https://www.sqlite.org/docs.html
To Do after February 22 class:
- Submit Group Project UMLs on Brightspace by Friday, February 23 at 11:59 pm
- Submit Assignment A-w7 on Brightspace by Saturday, February 24 at 11:59 pm (This is simply an individual update on how you think your group is interacting)
- Submit Data Diary entries by Saturday, February 24 at 11:59 pm (required for 5265, optional for 3265)
WEEK 8
Week’s Topics:
- Project
To Do BEFORE February 27 class:
- Work on Group Project
In Class (February 27):
- No lecture, but Doug available for Project Group consultations
To Do BEFORE March 1:
- Work on Group Project
In Class (March 1):
- No lecture, but Doug available for Project Group consultations
To Do after March 1 class:
- Submit Final Group Project on Brightspace by Friday, March 2 at 6:00 pm
Submit Data Diary(no)- Enjoy break
WEEK 9 Spring break (March 3 – March 11 )
WEEK 10
Week’s Topics:
- Relational Design
- Functional Dependencies
- Boyce Codd Normal Form
- Relational decomposition
- Project Queries
To Do BEFORE March 13:
- Relational Design Tasks 1 (2 hours)
Quiz Q-w10 on Brightspace(Due Thursday before class)
In Class (Tuesday, March 13):
- No class (Doug at NSF), but watch Doug’s prerecorded lecture (slides only)
- Relational Design Exercises 1
To Do BEFORE March 15 class:
- Quiz Q-w10 on Brightspace
In Class (March 15):
- Relational Design Exercises 2
- Discuss Quiz Q-w10
- Recorded Lecture (slides only)
To Do after March 15 class:
- Submit Assignment A-w10 on Brightspace
by Saturday, March 17 at 11:59 pmTuesday, March 20 in class or on Brightspace by 8:10 am - Submit Data Diary entries by Saturday, March 17 at 11:59 pm (required for 5265, optional for 3265)
WEEK 11
Week’s Topics:
- Introduction to Indexes
- Introduction to Transactions
- Isolation Levels
To Do BEFORE March 20:
Quiz Q-w11 Indexes on Brightspace- Submit Assignment A-w10 on Brightspace
by Saturday, March 17 at 11:59 pmTuesday, March 20 in class or on Brightspace by 8:10 am
In Class (March 20):
To Do BEFORE March 22:
In Class (March 22):
- Query evaluation and selecting indexes (recorded lecture) (slides only)
To Do after March 22 class:
- Submit Assignment A-w11 as one neatly-formatted PDF on Brightspace by Saturday, March 24 at 11:59 pm
- Submit Data Diary entries by Saturday, March 24 at 11:59 pm (required for 5265, optional for 3265)
WEEK 12
Week’s Topics:
- Exam
- Transactions
To Do BEFORE March 27:
Study, including Key and rubric for A-w11
In Class (March 27):
- Exam 2
To Do BEFORE March 29:
In Class (March 29):
- Transactions (recorded lecture) (slides only)
- Transaction example
To Do after March 29 class:
- Submit Assignment A-w12 to Brightspace by 11:59 pm on Saturday, March 31 at 11:59 pm
- Submit Data Diary entries by Saturday, March 31 at 11:59 pm (required for 5265, optional for 3265)
WEEK 13
Week’s Topics:
- Data Mining
To Do BEFORE April 3 class:
Data Mining TasksQuiz
In Class (April 3):
- Data Mining, learning functional dependencies (recorded lecture) (slides only)
To Do BEFORE April 5 class:
In Class (April 5)
- Discuss Individual Project Specification
- Individual Project Thoughts
- Discuss A-w12 (Key and rubric)
- Recorded Lecture
To Do after April 5 class:
Submit Assignment A-w13 to Brightspace by Saturday, April 7 by 11:59 pmSubmit Data Diary entries by Saturday, April 7 at 11:59 pm (required for 5265, optional for 3265)
WEEK 14
Week’s Topics:
To Do BEFORE April 10:
- Work on Individual Project
In Class (April 10):
- Data mining (decision trees) (recorded lecture) (slides only)
To Do BEFORE April 12:
- Work on Individual Project
IN Class (April 12):
- Building test sets for project (recorded lecture)(slides only)
- Datasets
To Do After April 12 Class:
- Work on Individual Project
WEEK 15
Week’s Topics:
- Individual Projects
- Data Mining
To Do BEFORE April 17 class:
- Work on Individual Project
In Class (April 17):
- No class, but consulting on Individual Project in FGH atrium during class time
To Do BEFORE April 19 class:
- Submit Individual Project to Brightspace by Tuesday, April 17 at 11:59 pm
In Class (April 19):
- Final Exam Study Guide
- Course evaluations
Classes End (Monday, April 23)
Reading Day (Tuesday, April 24, 2018)
Take home Final Exam due Sunday, April 29
OPTIONAL MATERIAL (will not count towards CS 265 grade): If you do these now or later, and if you would like to see a followup course, please email me (anytime).
DB2 XML
- Watch videos (45 min) and answer questions from DB2 XML Data (https://class.stanford.edu/courses/DB/XML/SelfPaced/courseware/ch-xml_data/)
- Well-formed XML (9:35 + 3:44)
- DTDs, IDs, and IDREFs (18:01)
- XML Schema (13:09);
- Do XML Quiz
- Do DTD Exercises from DB2
- Complete DB2 XML Data mini course (OPTIONAL! Will not count towards CS 265 grade)
DB6 XPATH and XQUERY
- Watch videos (60 min) from DB6 XPath and XQuery
- XPath Introduction (9:50)
- XPath Demo (22:16)
- XQuery Introduction (5:13)
- XQuery Demo (16:20)
- Do XML Course-Catalog XPath and XQuery Exercises
- Do XML World-Countries XPath and XQuery Exercises
- Complete DB6 XPath and XQuery mini course (OPTIONAL! Will not count towards CS 265 grade)
DB7 XSLT
- Watch videos ( min) from DB7 XSLT (OPTIONAL!)
- XSLT (22:14)
- Do XML Course-Catalog XSLT exercises
- Do XML World Countries XSLT exercises
- Complete DB7 XSLT mini course (OPTIONAL! Will not count towards CS 265 grade)
Complete DB8 Relational Design Theory
- Watch remaining videos (36 min) and answer questions from DB8 Relational Design Theory (https://class.stanford.edu/courses/DB/RD/SelfPaced/courseware/ch-relational_design_theory/)
- Multivalued Dependencies (6:24 + 4:26 + 11:30 + 1:23)
- Do the Multivalued Dependencies Quiz from DB8Relational Design Theory (https://class.stanford.edu/courses/DB/RD/SelfPaced/courseware/ch-relational_design_theory/)
- Complete the Normalization Quiz from DB8 Relational Design Theory (https://class.stanford.edu/courses/DB/RD/SelfPaced/courseware/ch-relational_design_theory/)
Complete DB12 Views and Authorization
- Watch remaining videos (60 min) and answer questions from DB12 Views and Authorization (https://class.stanford.edu/courses/DB/Views/SelfPaced/courseware/ch-views/) and answer questions from DB12 Views and Authorization modules
- Authorizations (3:24 + 1:50 + 4:10 + 1:35)
DB13 Online-Analytical Processing
- Watch videos (45 min ) and answer questions from DB13 Online- Analytical Processing (https://class.stanford.edu/courses/DB/OLAP/SelfPaced/courseware/ch-on-line_analytical_processing/)
- Introduction to OLAP (14:22 + 3:46)
- OLAP Demo (26:46)
- Do OLAP Quiz
- Complete DB13 Online Analytical Processing mini course (OPTIONAL! Will not count towards CS 265 grade)
DB14 Recursion in SQL
- Watch videos (63 min ) from DB14 Recursion in SQL (OPTIONAL!)
- Basic Recursive WITH Statement – Introduction (11:54)
- Basic Recursive WITH Statement Demo (30:06)
- Non-linear and Mutual Recursion (8:05 + 13:00)
- Do Recursion Quiz (OPTIONAL!)
- Complete DB14 Recursion in SQL mini course (OPTIONAL! Will not count towards CS 265 grade)