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]
Auf dieser Seite können Sie das Online-Video CS50 2021 in HDR - Lecture 7 - SQL mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer CS50 31 Dezember 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 129,551 Mal angesehen und es wurde von 1.5 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
