SQL Introduction
Selections
Projections
Ordering the Results
Joins
Disambiguating Attributes
Tuple Variables
First Unintuitive SQLism
Union, Intersection, Difference
Exercises
Subqueries
Subqueries Returning Relations
Conditions on Tuples
Correlated Queries
Removing Duplicates
Conserving Duplicates
Aggregation
Grouping and Aggregation
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