CSC343 Lecture Notes on SQL# Last updated November 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) 2. Deletion in databases 2.1 Introduction 2.2 How is a table stored? 2.3 B-trees 2.4 Deletion