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)