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)
Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from CS50 · CS50 · 0 of 60

← Previous Next →
1 Hello, World: Hadi Partovi
Hello, World: Hadi Partovi
CS50
 2 Content Distribution and Archival in a Digital Age
Content Distribution and Archival in a Digital Age
CS50
 3 CS50 2014 - Week 1
CS50 2014 - Week 1
CS50
 4 CS50 2014 - Week 3
CS50 2014 - Week 3
CS50
 5 CS50 2014 - Week 0, continued
CS50 2014 - Week 0, continued
CS50
 6 CS50 2014 - Week 4
CS50 2014 - Week 4
CS50
 7 Week 3, continued
Week 3, continued
CS50
 8 Quiz 0 Review
Quiz 0 Review
CS50
 9 CS50 2014 - Week 3, continued
CS50 2014 - Week 3, continued
CS50
 10 CS50 2014 - Week 7
CS50 2014 - Week 7
CS50
 11 CS50 2014 - Week 7, continued
CS50 2014 - Week 7, continued
CS50
 12 Breaking Through The (Google) Glass Ceiling by Christopher Bartholomew
Breaking Through The (Google) Glass Ceiling by Christopher Bartholomew
CS50
 13 Introduction to Amazon Web Services by Leo Zhadanovsky
Introduction to Amazon Web Services by Leo Zhadanovsky
CS50
 14 CS50 2014 - Week 9
CS50 2014 - Week 9
CS50
 15 How to Build Innovative Technologies by Abby Fichtner
How to Build Innovative Technologies by Abby Fichtner
CS50
 16 Light Your World (with Hue Bulbs) by Dan Bradley
Light Your World (with Hue Bulbs) by Dan Bradley
CS50
 17 Building Dynamic Web Apps with Laravel by Eric Ouyang
Building Dynamic Web Apps with Laravel by Eric Ouyang
CS50
 18 CS50 2014 - CS50 Lecture by Steve Ballmer
CS50 2014 - CS50 Lecture by Steve Ballmer
CS50
 19 CS50 2014 - Week 10
CS50 2014 - Week 10
CS50
 20 This is CS50 with Steve Ballmer?
This is CS50 with Steve Ballmer?
CS50
 21 Meteor: a better way to build apps by Roger Zurawicki
Meteor: a better way to build apps by Roger Zurawicki
CS50
 22 Data Analysis in R by Dustin Tran
Data Analysis in R by Dustin Tran
CS50
 23 Data Visualization and D3 by David Chouinard
Data Visualization and D3 by David Chouinard
CS50
 24 CS50 2014 - Week 6
CS50 2014 - Week 6
CS50
 25 Build Tomorrow's Library by Jeffrey Licht
Build Tomorrow's Library by Jeffrey Licht
CS50
 26 CS50 2014 - Week 9, continued
CS50 2014 - Week 9, continued
CS50
 27 Essential Scale-Out Computing by James Cuff
Essential Scale-Out Computing by James Cuff
CS50
 28 iOS App Development with Swift by Dan Armendariz
iOS App Development with Swift by Dan Armendariz
CS50
 29 Sam Clark Leads Yale Students on Tour to CS50 at Harvard
Sam Clark Leads Yale Students on Tour to CS50 at Harvard
CS50
 30 3D Modeling and Manufacture by Ansel Duff
3D Modeling and Manufacture by Ansel Duff
CS50
 31 CS50 2014 - Week 5, continued
CS50 2014 - Week 5, continued
CS50
 32 hello, world
hello, world
CS50
 33 CS50 2014 - Deep Thoughts - Hash Table
CS50 2014 - Deep Thoughts - Hash Table
CS50
 34 CS50 2014 - Deep Thoughts - Binary Tree
CS50 2014 - Deep Thoughts - Binary Tree
CS50
 35 CS50 2014 - Deep Thoughts - Scratch
CS50 2014 - Deep Thoughts - Scratch
CS50
 36 CS50 2014 - Deep Thoughts - MySQL
CS50 2014 - Deep Thoughts - MySQL
CS50
 37 LaunchCode Visits CS50
LaunchCode Visits CS50
CS50
 38 CS50 Live, Episode 100
CS50 Live, Episode 100
CS50
 39 CS50 Field Trip to Google
CS50 Field Trip to Google
CS50
 40 This is CS50 AP
This is CS50 AP
CS50
 41 Week 4: Monday - CS50 2011 - Harvard University
Week 4: Monday - CS50 2011 - Harvard University
CS50
 42 Week 2: Wednesday - CS50 2011 - Harvard University
Week 2: Wednesday - CS50 2011 - Harvard University
CS50
 43 Week 1: Wednesday - CS50 2011 - Harvard University
Week 1: Wednesday - CS50 2011 - Harvard University
CS50
 44 Week 11: Monday - CS50 2011 - Harvard University
Week 11: Monday - CS50 2011 - Harvard University
CS50
 45 Week 3: Wednesday - CS50 2011 - Harvard University
Week 3: Wednesday - CS50 2011 - Harvard University
CS50
 46 Week 12: Monday - CS50 2011 - Harvard University
Week 12: Monday - CS50 2011 - Harvard University
CS50
 47 Week 1: Friday - CS50 2011 - Harvard University
Week 1: Friday - CS50 2011 - Harvard University
CS50
 48 Week 3: Monday - CS50 2011 - Harvard University
Week 3: Monday - CS50 2011 - Harvard University
CS50
 49 Week 10: Wednesday - CS50 2011 - Harvard University
Week 10: Wednesday - CS50 2011 - Harvard University
CS50
 50 Week 2: Monday - CS50 2011 - Harvard University
Week 2: Monday - CS50 2011 - Harvard University
CS50
 51 Week 9: Monday - CS50 2011 - Harvard University
Week 9: Monday - CS50 2011 - Harvard University
CS50
 52 Week 7: Monday - CS50 2011 - Harvard University
Week 7: Monday - CS50 2011 - Harvard University
CS50
 53 Week 5: Monday - CS50 2011 - Harvard University
Week 5: Monday - CS50 2011 - Harvard University
CS50
 54 Week 5: Wednesday - CS50 2011 - Harvard University
Week 5: Wednesday - CS50 2011 - Harvard University
CS50
 55 Week 7: Wednesday - CS50 2011 - Harvard University
Week 7: Wednesday - CS50 2011 - Harvard University
CS50
 56 Week 8: Monday - CS50 2011 - Harvard University
Week 8: Monday - CS50 2011 - Harvard University
CS50
 57 Week 9: Wednesday - CS50 2011 - Harvard University
Week 9: Wednesday - CS50 2011 - Harvard University
CS50
 58 Week 8: Wednesday - CS50 2011 - Harvard University
Week 8: Wednesday - CS50 2011 - Harvard University
CS50
 59 Week 10: Monday - CS50 2011 - Harvard University
Week 10: Monday - CS50 2011 - Harvard University
CS50
 60 Week 2: Wednesday - CS50 2010 - Harvard University
Week 2: Wednesday - CS50 2010 - Harvard University
CS50

Related AI Lessons

⚡
Managing Permissions Directly via SQL in BigQuery
Manage BigQuery permissions directly via SQL to streamline LLM inference workflows
Medium · Data Science
 ⚡
Data’s Best Decade is Ahead. Most Companies Are Looking at it Wrong.
Learn how to leverage data correctly to drive business decisions and stay ahead in the industry
Medium · AI
 ⚡
Data’s Best Decade is Ahead. Most Companies Are Looking at it Wrong.
Learn how to leverage data effectively to drive business decisions and unlock its full potential in the upcoming decade
Medium · Machine Learning
 ⚡
Data’s Best Decade is Ahead. Most Companies Are Looking at it Wrong.
Learn how to leverage data effectively by shifting focus from reporting to decision-making, a crucial skill for companies to thrive in the upcoming decade
Medium · Data Science

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
Up next
Hedge Fund Performance and Risk Metrics
Coursera
Watch →