CSC343 Lecture Notes on SQL

Last updated January 2026

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)
• 1.11 postgreSQL “schemas”

2. Deletion in databases

• 2.1 Introduction
• 2.2 How is a table stored?
• 2.3 B-trees
• 2.4 Deletion