Exercises
Grouping and Aggregation
Simple Aggregation
Solution: Two Steps
Then, aggregate
Another Example
Grouping and Aggregation: Summary
HAVING Clause
Modifying the Database
More Interesting Insertions
Deletions
Updates
Data Definition in SQL
Data Types in SQL
Creating Tables
Deleting or Modifying a Table
Default Values
Indexes
Creating Indexes
Defining Views
A Different View
Updating Views
Non-Updatable Views
Email: alon@cs.washington.edu
Home Page: http://www.cs.washington.edu/homes/alon
Download presentation source