CS50 2020 - Lecture 7 - SQL
Skills:
SQL Analytics90%
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/
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from CS50 · CS50 · 0 of 60
← Previous
Next →
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Hello, World: Hadi Partovi
CS50
Content Distribution and Archival in a Digital Age
CS50
CS50 2014 - Week 1
CS50
CS50 2014 - Week 3
CS50
CS50 2014 - Week 0, continued
CS50
CS50 2014 - Week 4
CS50
Week 3, continued
CS50
Quiz 0 Review
CS50
CS50 2014 - Week 3, continued
CS50
CS50 2014 - Week 7
CS50
CS50 2014 - Week 7, continued
CS50
Breaking Through The (Google) Glass Ceiling by Christopher Bartholomew
CS50
Introduction to Amazon Web Services by Leo Zhadanovsky
CS50
CS50 2014 - Week 9
CS50
How to Build Innovative Technologies by Abby Fichtner
CS50
Light Your World (with Hue Bulbs) by Dan Bradley
CS50
Building Dynamic Web Apps with Laravel by Eric Ouyang
CS50
CS50 2014 - CS50 Lecture by Steve Ballmer
CS50
CS50 2014 - Week 10
CS50
This is CS50 with Steve Ballmer?
CS50
Meteor: a better way to build apps by Roger Zurawicki
CS50
Data Analysis in R by Dustin Tran
CS50
Data Visualization and D3 by David Chouinard
CS50
CS50 2014 - Week 6
CS50
Build Tomorrow's Library by Jeffrey Licht
CS50
CS50 2014 - Week 9, continued
CS50
Essential Scale-Out Computing by James Cuff
CS50
iOS App Development with Swift by Dan Armendariz
CS50
Sam Clark Leads Yale Students on Tour to CS50 at Harvard
CS50
3D Modeling and Manufacture by Ansel Duff
CS50
CS50 2014 - Week 5, continued
CS50
hello, world
CS50
CS50 2014 - Deep Thoughts - Hash Table
CS50
CS50 2014 - Deep Thoughts - Binary Tree
CS50
CS50 2014 - Deep Thoughts - Scratch
CS50
CS50 2014 - Deep Thoughts - MySQL
CS50
LaunchCode Visits CS50
CS50
CS50 Live, Episode 100
CS50
CS50 Field Trip to Google
CS50
This is CS50 AP
CS50
Week 4: Monday - CS50 2011 - Harvard University
CS50
Week 2: Wednesday - CS50 2011 - Harvard University
CS50
Week 1: Wednesday - CS50 2011 - Harvard University
CS50
Week 11: Monday - CS50 2011 - Harvard University
CS50
Week 3: Wednesday - CS50 2011 - Harvard University
CS50
Week 12: Monday - CS50 2011 - Harvard University
CS50
Week 1: Friday - CS50 2011 - Harvard University
CS50
Week 3: Monday - CS50 2011 - Harvard University
CS50
Week 10: Wednesday - CS50 2011 - Harvard University
CS50
Week 2: Monday - CS50 2011 - Harvard University
CS50
Week 9: Monday - CS50 2011 - Harvard University
CS50
Week 7: Monday - CS50 2011 - Harvard University
CS50
Week 5: Monday - CS50 2011 - Harvard University
CS50
Week 5: Wednesday - CS50 2011 - Harvard University
CS50
Week 7: Wednesday - CS50 2011 - Harvard University
CS50
Week 8: Monday - CS50 2011 - Harvard University
CS50
Week 9: Wednesday - CS50 2011 - Harvard University
CS50
Week 8: Wednesday - CS50 2011 - Harvard University
CS50
Week 10: Monday - CS50 2011 - Harvard University
CS50
Week 2: Wednesday - CS50 2010 - Harvard University
CS50
More on: SQL Analytics
View skill →
Related AI Lessons
Chapters (34)
Introduction
0:49
Data
1:34
Spreadsheets
8:50
Flat-File Databases
10:53
CSV Files
11:44
favorites.py
21:05
Data Cleaning
23:06
sorted
47:03
Lambda Functions
56:49
Relational Databases
57:55
SQLite
1:04:54
SQL
1:05:04
CRUD
1:09:17
SELECT
1:12:49
DISTINCT
1:14:55
LIKE
1:17:37
ORDER BY
1:18:49
GROUP BY
1:26:42
INSERT
1:31:44
UPDATE
1:32:36
DELETE
1:33:57
Relational Data
1:37:55
Data Types
1:38:40
Constraints
1:39:46
PRIMARY KEY
1:41:09
FOREIGN KEY
1:42:59
CS50 Library
1:44:35
Many-to-Many Relationships
2:05:00
IMDb
2:12:45
Indexes
2:15:11
JOINs
2:20:34
SQL Injection
2:26:02
Race Conditions
2:32:00
Race Conditions (Demo)
🎓
Tutor Explanation
DeepCamp AI