CSE logo University of Washington Department of Computer Science & Engineering
 CSE444 Introduction to Database Systems - Autumn 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
Sept. 27

Intro to DB Systems
.ppt;   .pdf

SQL
.ppt;   .pdf

Oct. 2
SQL
.ppt;   .pdf
SQL & Project Intro
.ppt;   .pdf
Views & Constraints
.ppt;   .pdf
Oct. 9 E/R Diagrams
.ppt;   .pdf

Project
.ppt;   .pdf
IMDB_Example
HW1 Due

Database Design
.ppt;   .pdf

Oct. 16 Database Design

XML
.ppt;   .ppt

Proj Part1 Due

XPath/XQuery

.ppt, .pdf

Oct. 23 XQuery in SQL Server
.ppt;   .pdf
Security
.ppt;   .pdf
   Advanced SQL Injection
HW2 Due
Midterm
Oct. 30 Transactions in SQL .ppt;   .pdf

Recovery
.ppt;   .pdf

Proj Part2 Due

 
Nov. 6

Concurrency Control
.ppt;   .pdf

Supplemental Notes
.ppt;   .pdf

 

HW3 Due

Holiday
Nov. 13  

Data Storage and Indexes
.ppt;   .pdf

Proj Part3 Due

Query Execution: Relational Algebra
.ppt;   .pdf

Nov. 20 Query Execution
.ppt;   .pdf

HW4 Due
Holiday
Nov. 27 Query Execution
.ppt;   .pdf

Proj Part4 Due  
Dec. 4 Query Optimization
.ppt;   .pdf
  Final Review
.ppt;   .pdf

 

Final Exam: Monday, December 11, 8:30-10:20 am, in EEB 037.

* 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]