CSC343 Lecture Notes on SQL

Diane Horton

1 Introduction to SQL
2 Aggregation and Grouping
3 Filtering groups with HAVING
4 Views
5 Sets and Bags in SQL
6 NULL values in SQL
7 Joins
8 Subqueries
9 Database Modifications
10 Data Definition Language