
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 [email protected]