Videos on the Relational Model and SQL

The following collection of videos provides an overview of the relational model and the SQL query language. It was originally developed for a course on databases designed for non-CS majors.

The slides in the videos are similar to the ones that we cover in lecture, but the videos take a slightly different approach, and they may be useful as a way of reinforcing your understanding of these concepts. Each video is between 3 and 10 minutes long.

1. The Relational Model

2. Keys, Candidate Keys, and Primary Keys

3. Capturing Relationships Using Foreign Keys

4. Constraints and Null Values

5. SQL: Simple SELECT Commands

6. SQL: Pattern Matching; Comparisons Involving NULL

7. SQL: Removing Duplicates; Aggregate Functions

8. Subqueries in SQL

9. SQL: Queries Involving Subgroups

10. SQL: Cartesian Product; Joins

11. SQL: Joins Revisited

12. SQL: Outer Joins

13. SQL: Data Types; Creating Tables and Inserting Rows

14. SQL: Other Commands

Last updated on September 10, 2024.