CS 330
Lecture 7
SQL
ReadingTextbook, Chapter 4, pp 111-122 (4.1-4.3)
- Introduction to SQL: how Access works underneath.
- Basic Structure.
- The Select clause.
- The where clause.
- The Rename operation.
- Tuple variables. Skip 4.2.6.
- Set Operations. Union, Intersect and Except.
- Examples from the Banking database.
Feedback to Hw2 will come by email by Saturday. Read your email for
supplementary exercises, for those of you who need more practice with Access.
I will send them out by Saturday, too.
Ileana Streinu