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 • CS50 Lectures 2021 (HDR) .
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_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]