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

Administration
 Home Page
 Syllabus
 Calendar/Lecture Notes
 E-mail Archive 
Project
 Description
 Resources
Homeworks
 Assignments and Solutions
Exams
 Problem sets and Solutions
   

Daily Schedule for 444

Note that this schedule will be altered during the quarter. Please make sure to check it every week.

Key:

  • Lecture topic
  • Reading assignment
  • Homework information
  • Project milestones
  • Special events
Week of Monday Wednesday Friday
Mar. 26
 SQL
pdf / ppt
SQL
pdf / ppt 
SQL
pdf / ppt 
Apr. 2
 SQL
pdf / ppt
Views, Constraints
pdf / ppt 
 SQL in C#
pdf / ppt
Reading: Chapter 8
HW1 due
Apr. 9 ER Diagrams
pdf / ppt
Reading: Chapter 2, 3.2, 3.3
 Database Design
pdf / ppt
Database Design
pdf / ppt
Project 1 due
Apr. 16 XML/XPath/XQuery
pdf / ppt
Reading: Chapter 4.6, 4.7
XML/XPath/XQuery
pdf / ppt 
XML/XPath/XQuery
pdf / ppt
HW2 due
Apr. 23  Midterm Review and Security
pdf / ppt
Reading: SQL Security – 8.7
Midterm Test
midterm / solution

Project 2 due
Apr. 30 Transactions
pdf / ppt
Transactions
pdf / ppt
Transaction, Recovery
HW3 due
May. 7 Concurrency Control
pdf / ppt
Concurrency Control 2 Concurrency Control 3
Project 3 due
May. 14 Data storage and Indexes
pdf / ppt
Reading: 12, 13.1, 13.2, 13.3
Query Execution: Relational Database
pdf / ppt 
Query Execution 2
pdf / ppt
HW4 due
May. 21 Query Execution 3: Physical Operators  Query Optimization
pdf / ppt
Reading: 16.2, 16.5, 16.6, 16.4
Query Optimization
Project 4 due
May. 28  Query Optimizaton Query Optimization  Final Review
pdf / ppt
Jun. 4      

 

Final Exam: 10:20 am to 12:30 pm, Tuesday, June 5th at EEB 045

Additional Readings




CSE logo Department of Computer Science & Engineering
University of Washington
Box 352350
Seattle, WA  98195-2350
(206) 543-1695 voice, (206) 543-2969 FAX
[comments to akgupta[AT]cs.washington.edu]