CS50 2017 - Lecture 10 - SQL

CS50 · Intermediate ·📊 Data Analytics & Business Intelligence ·8y ago
00:00:00 - Muppet Teaser 00:03:02 - eprint 00:05:07 - Facebook Login Walkthrough 00:14:34 - Flask Sessions 00:28:56 - SQL 00:29:44 - Databases 00:36:55 - SQLite 00:39:01 - Database Operations 00:45:32 - SQL Data Types 00:54:33 - Optimizing the Database 01:06:13 - phpLiteAdmin 01:12:42 - Constraints 01:18:01 - Creating a Database 01:21:58 - sqlite3 01:25:14 - SQL in Python 01:33:15 - SQL Injection Attacks 01:38:50 - Adding SQL to Flask 01:43:31 - C$50 Finance
Watch on YouTube ↗ (saves to browser)

Chapters (18)

Muppet Teaser
3:02 eprint
5:07 Facebook Login Walkthrough
14:34 Flask Sessions
28:56 SQL
29:44 Databases
36:55 SQLite
39:01 Database Operations
45:32 SQL Data Types
54:33 Optimizing the Database
1:06:13 phpLiteAdmin
1:12:42 Constraints
1:18:01 Creating a Database
1:21:58 sqlite3
1:25:14 SQL in Python
1:33:15 SQL Injection Attacks
1:38:50 Adding SQL to Flask
1:43:31 C$50 Finance

Playlist

Uploads from CS50 · CS50 · 0 of 60

← Previous Next →
1 Persistence
Persistence
CS50
 2 Hello, World: Hadi Partovi
Hello, World: Hadi Partovi
CS50
 3 CS50 Live, Episode 008
CS50 Live, Episode 008
CS50
 4 CS50 Live Outtakes
CS50 Live Outtakes
CS50
 5 CS50 Live, Episode 009
CS50 Live, Episode 009
CS50
 6 Robotics
Robotics
CS50
 7 Content Distribution and Archival in a Digital Age
Content Distribution and Archival in a Digital Age
CS50
 8 CS50x Conversation
CS50x Conversation
CS50
 9 Hello, World: Susan Wojcicki
Hello, World: Susan Wojcicki
CS50
 10 60 Seconds of Virtual Reality at Valve
60 Seconds of Virtual Reality at Valve
CS50
 11 Harvard Tour, Widener Library
Harvard Tour, Widener Library
CS50
 12 Harvard Tour, Harvard Yard
Harvard Tour, Harvard Yard
CS50
 13 Camera Stabilization
Camera Stabilization
CS50
 14 CS50 2014, Coming Soon
CS50 2014, Coming Soon
CS50
 15 CS50's ALS Ice Bucket Challenge
CS50's ALS Ice Bucket Challenge
CS50
 16 CS50 2014, Coming Soon
CS50 2014, Coming Soon
CS50
 17 This is CS50 2014
This is CS50 2014
CS50
 18 CS50 Staff 2014
CS50 Staff 2014
CS50
 19 Extruding CS50 in 3D
Extruding CS50 in 3D
CS50
 20 Week 0
Week 0
CS50
 21 Week 1
Week 1
CS50
 22 Week 2
Week 2
CS50
 23 CS50 2014 - Week 0
CS50 2014 - Week 0
CS50
 24 CS50 2014 - Week 1
CS50 2014 - Week 1
CS50
 25 CS50 2014 - Week 2, continued
CS50 2014 - Week 2, continued
CS50
 26 CS50 2014 - Week 3
CS50 2014 - Week 3
CS50
 27 CS50 2014 - Week 0, continued
CS50 2014 - Week 0, continued
CS50
 28 Ansel in the Shoppe
Ansel in the Shoppe
CS50
 29 Supersection 1, Less Comfortable
Supersection 1, Less Comfortable
CS50
 30 Supersection 1, More Comfortable
Supersection 1, More Comfortable
CS50
 31 Section 2
Section 2
CS50
 32 CS50 2014 - Week 4
CS50 2014 - Week 4
CS50
 33 Section 3
Section 3
CS50
 34 Week 3, continued
Week 3, continued
CS50
 35 CS50 2014 - Week 2
CS50 2014 - Week 2
CS50
 36 CS50 2014 - Week 5
CS50 2014 - Week 5
CS50
 37 Quiz 0 Review
Quiz 0 Review
CS50
 38 Section 5
Section 5
CS50
 39 Section 4
Section 4
CS50
 40 CS50 2014 - Week 3, continued
CS50 2014 - Week 3, continued
CS50
 41 CS50 2014 - Week 4, continued
CS50 2014 - Week 4, continued
CS50
 42 CS50 2014 - Week 7
CS50 2014 - Week 7
CS50
 43 Week 4
Week 4
CS50
 44 Week 3
Week 3
CS50
 45 server
server
CS50
 46 server, continued
server, continued
CS50
 47 CS50 2014 - Week 7, continued
CS50 2014 - Week 7, continued
CS50
 48 CS50 2014 - Week 8
CS50 2014 - Week 8
CS50
 49 Section 7
Section 7
CS50
 50 Section 6
Section 6
CS50
 51 CS50 2014 - Week 8, continued
CS50 2014 - Week 8, continued
CS50
 52 Week 8
Week 8
CS50
 53 Week 7
Week 7
CS50
 54 Week 9
Week 9
CS50
 55 Breaking Through The (Google) Glass Ceiling by Christopher Bartholomew
Breaking Through The (Google) Glass Ceiling by Christopher Bartholomew
CS50
 56 Introduction to Amazon Web Services by Leo Zhadanovsky
Introduction to Amazon Web Services by Leo Zhadanovsky
CS50
 57 CS50 2014 - Week 9
CS50 2014 - Week 9
CS50
 58 How to Build Innovative Technologies by Abby Fichtner
How to Build Innovative Technologies by Abby Fichtner
CS50
 59 Light Your World (with Hue Bulbs) by Dan Bradley
Light Your World (with Hue Bulbs) by Dan Bradley
CS50
 60 Building Dynamic Web Apps with Laravel by Eric Ouyang
Building Dynamic Web Apps with Laravel by Eric Ouyang
CS50
The Best Games from Scratch Game Jam, May 2024 🏆 Griffpatch Academy
Next Up
The Best Games from Scratch Game Jam, May 2024 🏆 Griffpatch Academy
griffpatch