CS 330
Lecture 8
Part 1
Short, informal, 10 minute quiz. 10 min SHARP.
Part 2
An example of a nice solution to Hw2. Idea: implementing security when it is
not quite available. A bit about scripts (macros) in Acsess. (10 min)
Part 3: More SQL
Examples for today.
- Aggregate functions: group by, having.
- Nested queries: in, not in.
- More tests for where:
- Set comparison: > some, = some, ..; > all, etc.
- Test for empty set: exists, not exists.
- Test for duplicates: unique, not unique.
- More renaming: whole query (result of select) as.
- Modifications of the database: selete, insert, update.
Reading
Textbook, Ch. 4.4, 4.5, 4.6, 4.7, 4.9.
- On Th: joins; examples.
- Next Tu, after hwk returned: more examples (CAP database). Final review
before midterm.
- Th after that: first midterm.
Ileana Streinu