CSC343 Lecture Notes on SQL

Last updated August 2025

1. SQL

• 1.1 Introduction to SQL
• 1.2 Aggregation and Grouping
• 1.3 Filtering groups with HAVING
• 1.4 Views
• 1.5 Sets and Bags in SQL
• 1.6 Null values in SQL
• 1.7 Joins
• 1.8 Subqueries
• 1.9 Database Modifications
• 1.10 The Data Definition Language (DDL)