CS50x 2026 - Lecture 7 - SQL

Description:

*** 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:00:43 – Flat-file Databases 00:24:10 – Relational Databases 00:53:24 – Shows 00:59:45 – Schema 01:04:16 – Data Types and Constraints 01:06:05 – Primary and Foreign Keys 01:06:58 – Querying 01:40:47 – Indexes 01:45:56 – Python and SQL 01:57:46 – SQL injection attacks 02:06:15 – Race Conditions *** HOW TO SUBSCRIBE HOW TO TAKE CS50 edX: Harvard Extension School: Harvard Summer School: OpenCourseWare: HOW TO JOIN CS50 COMMUNITIES Bluesky: Discord: Ed: Facebook Group: Faceboook Page: GitHub: Gitter: Instagram: LinkedIn Group: LinkedIn Page: Medium: Quora: Reddit: Slack: Snapchat: SoundCloud: Stack Exchange: Telegram: Threads: TikTok: Twitter: Twitter Community: YouTube: HOW TO FOLLOW DAVID J. MALAN Facebook: GitHub: Instagram: LinkedIn: Quora: Threads: TikTok: Twitter: *** CS50 SHOP *** LICENSE CC BY-NC-SA 4.0 Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International Public License David J. Malan [email protected]