CSE 444: Introduction to Database Systems

Winter 2001


Course Information

        Daily schedule

        Course syllabus

        Project information

        Project teams

        Useful HOW-TOs

        Interview Times

 

Homework Assignments

Assignment

Topic

Due Date

Answers

Homework 1/Programming

SQL

Due January 17

Answers

Notes

Programming Assignment

Programming Assignment on SQL

Due January 24

Notes and Answers

Homework 2

Transactions

Due February 14

Solutions

Homework 3

Locking, Recovery and Storage

Due February 22

Solutions

Homework 4

Query Processing and Optimization

Due March 7

Solutions

 

Lectures

DATE

LECTURE

PDF

01/03

Introduction and Overview

Lecture 1

01/08

SQL

Lecture 2

01/10

SQL

Lecture 3

01/17

SQL

Lecture 4

01/19

Building SQL Applications (Sieg 134)

Slides

01/22

SQL

Lecture 6

01/24

Schema Design

Lecture 7

01/29

Schema Design

Lecture 8

01/31

Schema Design

Lecture 9

02/07

Transactions

Lecture 10

02/12

Transactions

Lecture 11

02/14

Transaction Recovery and Storage

Lecture 12

02/21

Storage and Indexing

Lecture 13

02/26

Storage and Indexing

Lecture 14

02/28

Query Processing

Lecture 15

03/05

Query Optimization

Lecture 16

03/07

Query Optimization

Lecture 17

Hypermail Archive

Midterms

Winter 2001 midterm with solution

Fall 2000 midterm and its solution
Fall 1999 midterm and its solution
Fall 1998 midterm and its solution

Finals

Autumn 00 and its solution

Autumn 99

Autumn 98