CS50 2021 in HDR - Lecture 7 - SQL

This is CS50, Harvard University's Introduction to the intellectual enterprises of computer science and the art of programming. Enroll for free at https://cs50.edx.org/. Slides, source code, and more at https://cs50.harvard.edu/x. Playlist at https://www.youtube.com/playlist?list=PLhQjrBD2T383f9scHRNYJkior2VvYjpSL. TABLE OF CONTENTS 00:00:00 - Introduction 00:01:17 - SQL 00:03:21 - Data Collection 00:07:46 - Flat File Databases 00:09:24 - Reading from a CSV 00:14:26 - Filtering Duplicates 00:21:21 - Counting Titles 00:28:53 - Sorting Data 00:30:26 - Lambda Functions 00:36:07 - Cleaning Data 00:39:48 - Regular Expressions 00:45:50 - Search 00:48:17 - Relational Databases 00:51:20 - Create, Read, Update, Delete 00:53:32 - sqlite3 00:57:09 - SELECT 01:01:58 - WHERE 01:04:37 - DELETE 01:05:59 - UPDATE 01:11:31 - Redundancies 01:18:00 - Table Relationships 01:27:49 - INSERT 01:30:10 - Python and SQL 01:39:55 - shows.db 01:41:49 - SQL Types 01:43:11 - Many-to-Many Relationships 01:48:27 - Indexes 01:59:14 - JOIN 02:03:38 - SQL Injection Attacks 02:11:15 - Race Conditions 02:20:10 - Transactions 02:21:26 - This was CS50 *** This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming. *** HOW TO SUBSCRIBE http://www.youtube.com/subscription_center?add_user=cs50tv 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: https://discord.gg/cs50 Ed: https://cs50.harvard.edu/x/ed Facebook Group: https://www.facebook.com/groups/cs50/ Faceboook Page: https://www.facebook.com/cs50/ GitHub: https://github.com/cs50 Gitter: https://gitter.im/cs50/x Instagram: https://instagram.com/cs50 LinkedIn Group: https://www.linkedin.com/groups/7437240/ LinkedIn Page: https://www.linkedin.com/school/cs50/ Medium: https://cs50.medium.com/ Quora: https://www.quora.com/topic/CS50 Reddit: https://www.reddit.com/r/cs50/ Slack: https://cs50.edx.org/slack Snapchat: https://www.snapchat.com/add/cs50 SoundCloud: https://soundcloud.com/cs50 Stack Exchange: https://cs50.stackexchange.com/ TikTok: https://www.tiktok.com/@cs50 Twitter: https://twitter.com/cs50 YouTube: http://www.youtube.com/cs50 HOW TO FOLLOW DAVID J. MALAN Facebook: https://www.facebook.com/dmalan GitHub: https://github.com/dmalan Instagram: https://www.instagram.com/davidjmalan/ LinkedIn: https://www.linkedin.com/in/malan/ Quora: https://www.quora.com/profile/David-J-Malan TikTok: https://www.tiktok.com/@davidjmalan Twitter: https://twitter.com/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/by-nc-sa/4.0/ David J. Malan https://cs.harvard.edu/malan [email protected]