CS143 Handouts
Handout 1.
Database Tables
, Data Definition Language (
DDL
)
Handout 2
Queries for relational algebra
(Slides1
,
Slides2
)
Handout 3
Introduction to SQL
Handout 4
Integrity constraints
Updates in SQL
Handout 5
More on constraints
(
and Triggers
)
Handout 6
Notes on QBE
;
Handout 7
Handout on Disk and Files
;
Handout on RAID
Handout 8
Handout on Indexes
and
multi-key indexes
Handout 9
Handout on Joins
Handout 10
Handout on Optimization
and on
Big Overview
Handout 11
Handout on ER Diagrams
Handout 12
Handout1 on Schema Design
Handout 13
Handout2 on Schema Design
Handout 14
Handout3 on Schema Design
Handout 15
Handout on Transactions
Handout 16
Handout on 2-Phase Locking
and
Handout on HW5
Handout 17
Handouts on
Time-stamp based concurrency
and
Recovery
Handout 18
Handouts on
Distributed Databases & Two-Phase Commit
(2PC)