SQL - Intro to Computer Science - Harvard's CS50 (2018)
SQL is a standard language for storing, manipulating and retrieving data in databases. Learn how to use SQL in this video.
This course teaches the foundations of computer science. This video is lecture 8 of Harvard University's CS50 2018 course (part 9 since the lectures start at 0).
Check out our full CS50 playlist: https://www.youtube.com/playlist?list=PLWKjhJtqVAbmGw5fN5BQlwuug-8bDmabi
🔗CS50 IDE (must have free edX account): https://cs50.io/
🔗Notes: https://cs50.harvard.edu/x/2020/notes/8/
🔗Problem Set: https://cs50.harvard.edu/x/2020/psets/8/
🔗Source Code: https://cdn.cs50.net/2019/fall/lectures/8/src8.zip
⭐️Contents⭐️
⌨️ (0:00:00) Introduction
⌨️ (0:00:50) Week 7 Recap
⌨️ (0:04:02) C$50 Finance
⌨️ (0:06:14) Cookies
⌨️ (0:14:13) store
⌨️ (0:20:49) Databases
⌨️ (0:25:42) Mock Database
⌨️ (0:27:34) SQL
⌨️ (0:37:59) SQLite
⌨️ (0:50:19) phpLiteAdmin
⌨️ (1:11:21) lecture
⌨️ (1:37:06) Race Conditions
⌨️ (1:44:24) SQL Injection Attacks
Lecture taught by David J. Malan. Thanks to Harvard's CS50 for giving us permission to post this lecture. Checkout their YouTube channel for more great lectures: https://www.youtube.com/cs50
--
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://medium.freecodecamp.org