Next Class

2002-07-16

1. review homework
2. more on joining tables
3. functions
   1. aggregate
      • GROUP BY
      • HAVING
   2. scalar
   3. creation
      1. SQL99 standard
      2. PostgreSQL

2002-07-11

1. review homework
2. SELECT overview
3. functions
4. subqueries

2002-07-09

1. welcome
2. introduction
3. class basics
4. database basics
   • what it's used for
   • what it's not used for
   • who uses what/what to use
   • what is a database
5. SQL basics
   • SELECT
   • INSERT
   • DELETE
   • CREATE

Beginning Databases