CS50x 2024 - Lecture 7 - SQL

This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming.

***

TABLE OF CONTENTS

00:00:00 - Introduction
00:01:01 - Flat-file Databases
00:33:00 - Relational Databases
00:57:02 - Halloween Costume Contest
00:58:31 - Shows
00:59:30 - Schema
01:13:29 - Data Types and Constraints
01:15:04 - Primary and Foreign Keys
01:17:43 - Querying
01:47:24 - Indexes
01:55:44 - Python and SQL
02:00:30 - Race Conditions
02:06:47 - SQL injection attacks