CSE logo University of Washington Computer Science & Engineering
 CSE444 Introduction to Database Systems - Spring 2008
  CSE Home   About Us    Search    Contact Info 

   

Daily Schedule for 444

Note that this schedule will be altered during the quarter. Please make sure to check it regularly. Lecture notes will usually be posted by the morning of the corresponding lecture. Until then, the links will probably be broken.

Key:

  • Lecture topic
  • Reading assignment
  • Homework information
  • Project milestones
  • Special events
Week of Monday Wednesday Friday
March 31
 Intro; SQL
pdf / ppt
SQL
Reading: Chapter 6
pdf / ppt 
SQL
pdf / ppt 
HW0 due in class
April 7
 SQL
pdf / ppt
Views, Constraints
Reading: Chapters 6, 7
pdf / ppt 
Project 0 due
SQL in C#, Project
pdf / ppt
Reading: Chapter 8
HW1 due Sat. 9 pm
April 14 ER Diagrams
pdf / ppt
Reading: Chapter 2, 3.2, 3.3
 Database Design
pdf / ppt
Reading: Secs.3.1, 3.4
Database Design, cont.
Project 1 due Sat 9 pm
April 21 XML/XPath/XQuery
pdf / ppt
Reading: Chapter 4.6, 4.7
Project 1 due 9 pm
XML/XPath/XQuery
pdf / ppt
XML/XPath/XQuery
pdf / ppt
HW2 due Sat 9 pm
April 28 Midterm Review
pdf / ppt
Midterm Exam Security
pdf / ppt
Reading: SQL Security 8.7
Project 2 due Sat 9 pm
May 5 Transactions
pdf / ppt
Reading: Sec.8.6
Project 2 due 9 pm
Transactions
pdf / ppt
Reading: Secs.17.2-17.4
Transaction, Recovery
HW3 due Sat 9 pm
May 12 Concurrency Control
Reading: Secs.18.1-18.4, 18.7-18.9
pdf / ppt
Concurrency Control 2 Concurrency Control 3
Project 3 due Sat 9 pm
May 19 Data storage and Indexes
pdf / ppt
Reading: 12, 13.1, 13.2, 13.3
Query Execution: Relational Algebra
Reading: 5.1-5.4
pdf / ppt 
Query Execution 2
pdf / ppt
HW4 due Sat 9 pm
May 26 Memorial Day
No Class
Query Execution 3 Query Optimization
pdf / ppt
Reading: 16.2, 16.5, 16.6, 16.4
Project 4 due Sat 9 pm
June 2 Query Optimization
Query Optimization
Final Review
pdf / ppt
June 12 Final exam
8:30-10:20
   

 


CSE logo Computer Science & Engineering
University of Washington
Box 352350
Seattle, WA  98195-2350
(206) 543-1695 voice, (206) 543-2969 FAX
[comments to perkins]