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]
On this page of the site you can watch the video online CS50 2021 in HDR - Lecture 7 - SQL with a duration of hours minute second in good quality, which was uploaded by the user CS50 31 December 2021, share the link with friends and acquaintances, this video has already been watched 129,551 times on youtube and it was liked by 1.5 thousand viewers. Enjoy your viewing!
