Skip to main content

Ctrl+K

CSC343 Lectures Notes on SQL

CSC343 Lecture Notes on SQL

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

Search

Ctrl+K

By Diane Horton

© Copyright 2025.