***

This is CS50x (2024), Harvard University's introduction to SQL (Lecture 7)

***

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

***

HOW TO JOIN CS50 COMMUNITIES

Ed: https://cs50.harvard.edu/x/ed
GitHub: https://github.com/cs50
YouTube: http://www.youtube.com/cs50


***

CS50 SHOP

https://cs50.harvardshop.com/

***

David J. Malan
https://cs.harvard.edu/malan
malan@harvard.edu