CS50x 2023 - 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:12 - SQL 00:03:01 - Flat-file Databases 00:36:36 - Relational Databases 01:04:46 - Schemas 01:14:21 - Types 01:16:12 - Constraints 01:17:37 - Primary Keys, Foreign Keys, Relationships 01:46:39 - Indexes 01:52:16 - Python and SQL 02:04:24 - Race Conditions 02:13:09 - SQL Injection Attacks 02:19:17 - Little Bobby Tables *** HOW TO SUBSCRIBE http://www.youtube.com/subscription_c... HOW TO TAKE CS50 edX: https://cs50.edx.org/ Harvard Extension School: https://cs50.harvard.edu/extension Harvard Summer School: https://cs50.harvard.edu/summer OpenCourseWare: https://cs50.harvard.edu/x HOW TO JOIN CS50 COMMUNITIES Discord:   / discord   Ed: https://cs50.harvard.edu/x/ed Facebook Group:   / cs50   Faceboook Page:   / cs50   GitHub: https://github.com/cs50 Gitter: https://gitter.im/cs50/x Instagram:   / cs50   LinkedIn Group:   / 7437240   LinkedIn Page:   / cs50   Medium:   / cs50   Quora: https://www.quora.com/topic/CS50 Reddit:   / cs50   Slack: https://cs50.edx.org/slack Snapchat:   / cs50   SoundCloud:   / cs50   Stack Exchange: https://cs50.stackexchange.com/ TikTok:   / cs50   Twitter:   / cs50   YouTube:    / cs50   HOW TO FOLLOW DAVID J. MALAN Facebook:   / dmalan   GitHub: https://github.com/dmalan Instagram:   / davidjmalan   LinkedIn:   / malan   Quora: https://www.quora.com/profile/David-J... TikTok:   / davidjmalan   Twitter:   / davidjmalan   *** CS50 SHOP https://cs50.harvardshop.com/ *** LICENSE CC BY-NC-SA 4.0 Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International Public License https://creativecommons.org/licenses/... David J. Malan https://cs.harvard.edu/malan malan@harvard.edu