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]
