CSE logo University of Washington Department of Computer Science & Engineering
 CSE444 Introduction to Database Systems - Winter 2006
  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
Jan. 02

Intro to DB Systems
.ppt;   .pdf
SQL
.ppt;    .pdf
Jan. 09
SQL
.ppt;    .pdf
SQL  .ppt;  .pdf
Phase0 Due
Project Intro
.ppt;   .pdf
Jan. 16
Holiday
E/R Diagrams
.ppt;  .pdf
E/R Diagrams
.ppt;  .pdf
Jan. 23
Database Design
.ppt.pdf
Database Design .ppt; .pdf
Phase1 Due
Database Design
Jan. 30
XML
.ppt;   .ppt
XPath/XQuery .ppt, .pdf
Hw 2 Due
XQuery
.ppt;   .pdf
Feb. 06
Security
.ppt .pdf
Transactions in SQL
.ppt.pdf
Phase2 Due
Midterm
Feb. 13
Data Storage, Recovery
.ppt;   .pdf
Recovery  .ppt .pdf
Hw3 Due

Concurrency control
.ppt.pdf
Feb. 20
Holiday Concurrency control
.ppt;   .pdf
Phase3 Due

Feb. 27
Indexes
.ppt;    .pdf
Managing and Monitoring SQL Server 2005
.ppt .pdf
Hw4 Due
Hash Tables and Query Execution
.ppt;   .pdf
Mar. 06
Query Execution
.ppt;   .pdf
Query Execution
.ppt.pdf
Phase4 Due
Final Review
.ppt;  .pdf

Final Exam: Wednesday, March 15, 2:30-4:20, in MGH 241.

* Read on your own, not covered in lecture

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]