CS50x 2025 - 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:15 - Flat-file Databases
00:35:17 - Relational Databases
01:19:22 - Shows
01:25:55 - Schema
01:36:44 - Data Types and Constraints
01:38:18 - Primary and Foreign Keys
01:38:27 - Querying
02:07:15 - Indexes
02:16:57 - Python and SQL
02:23:55 - Race Conditions
02:30:05 - SQL injection attacks

***

HOW TO SUBSCRIBE

HOW TO TAKE CS50

HOW TO JOIN CS50 COMMUNITIES

HOW TO FOLLOW DAVID J. MALAN

***

CS50 SHOP

***

LICENSE

CC BY-NC-SA 4.0
Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International Public License

David J. Malan

[JorgeEscobarMX]

1:10:10 this is most important. If you get ANYTHING from this lecture, please be this... add a where clause to your delete statement.

[Aayushh]

everything went above my head. ill have to rewatch the entire lec again.

[JustMrNone]

This was awsome, thank you Professor Malan.

[JorgeEscobarMX]

This is going to fly over many people's heads.

[TheAuraEngineer]

2:28:18 I highly recommend a vid called “unlimited free boba with computer science” for a good vid on (and example of) race conditions

[arekkita]

Why is this just a screencast and not a video from the hall?

[InterviewRwanda]

I like that he looks like a floating head and arms lol 😂 😂

[delicious]

I start cs50 in 2021 but can’t finish and leave it tell now 😢……I’ll try again and again

[clutchyfinger]

Whoever said C is their favorite but chose "Hello, World" are either trolling or are very sentimental 😂