TABLE OF CONTENTS 00:00:00 – Introduction 00:00:49 – Data 00:01:34 – Spreadsheets 00:08:50 – Flat-File Databases 00:10:53 – CSV Files 00:11:44 – favorites.py 00:21:05 – Data Cleaning 00:23:06 – sorted 00:47:03 – Lambda Functions 00:56:49 – Relational Databases 00:57:55 – SQLite 01:04:54 – SQL 01:05:04 – CRUD 01:09:17 – SELECT 01:12:49 – DISTINCT 01:14:55 – LIKE 01:17:37 – ORDER BY 01:18:49 – GROUP BY 01:26:42 – INSERT 01:31:44 – UPDATE 01:32:36 – DELETE 01:33:57 – Relational Data 01:37:55 – Data Types 01:38:40 – Constraints 01:39:46 – PRIMARY KEY 01:41:09 – FOREIGN KEY 01:42:59 – CS50 Library 01:44:35 – Many-to-Many Relationships 02:05:00 – IMDb 02:12:45 – Indexes 02:15:11 – JOINs 02:20:34 – SQL Injection 02:26:02 – Race Conditions 02:32:00 – Race Conditions (Demo) *** 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/T8QZqRx 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/ Reddit: https://www.reddit.com/r/cs50/ Quora: https://www.quora.com/topic/CS50 Slack: https://cs50.edx.org/slack Snapchat: https://www.snapchat.com/add/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 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]