CS50 SQL - Lecture 6 - Scaling

CS50 · Beginner ·🔐 Cybersecurity ·2y ago
To follow along with this lecture, visit https://cs50.harvard.edu/sql. *** This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming. *** TABLE OF CONTENTS 00:00:00 - Introduction 00:00:17 - Scalability 00:03:24 - MySQL 00:56:23 - Stored Procedures 01:16:22 - PostgreSQL 01:29:04 - Replication 01:42:56 - Sharding 01:46:04 - Access Control 01:54:27 - SQL Injection Attacks 02:01:59 - Prepared Statements 02:08:13 - This was CS50 SQL *** HOW TO SUBSCRIBE http://www.youtube.com/subscription_center?add_user=cs50tv HOW TO TA…
Watch on YouTube ↗ (saves to browser)

Chapters (11)

Introduction
0:17 Scalability
3:24 MySQL
56:23 Stored Procedures
1:16:22 PostgreSQL
1:29:04 Replication
1:42:56 Sharding
1:46:04 Access Control
1:54:27 SQL Injection Attacks
2:01:59 Prepared Statements
2:08:13 This was CS50 SQL

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
HOW the NSA monitors your VPN
Next Up
HOW the NSA monitors your VPN
David Bombal (backup)