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 *** HOW TO SUBSCRIBE HOW TO TAKE CS50 edX: Harvard Extension School: Harvard Summer School: OpenCourseWare: HOW TO JOIN CS50 COMMUNITIES Discord: Ed: Facebook Group: Faceboook Page: GitHub: Gitter: Instagram: LinkedIn Group: LinkedIn Page: Medium: Quora: Reddit: Slack: Snapchat: SoundCloud: Stack Exchange: TikTok: @cs50 Twitter: YouTube: HOW TO FOLLOW DAVID J. MALAN Facebook: GitHub: Instagram: LinkedIn: Quora: TikTok: @davidjmalan Twitter: *** CS50 SHOP *** LICENSE CC BY-NC-SA 4.0 Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International Public License David J. Malan malan@