TABLE OF CONTENTS

00:00:00 - Introduction
00:00:51 - Databases
00:01:53 - SQL
00:02:35 - SQL Data Types
00:04:26 - create.sql
00:09:27 - Constraints
00:11:07 - INSERT
00:13:39 - insert.sql
00:14:06 - SELECT
00:25:37 - SQL Functions
00:26:21 - UPDATE
00:28:37 - DELETE
00:36:57 - Foreign Keys
00:42:48 - joins.sql
00:50:15 - Indexing
00:56:30 - SQL Injection
01:02:57 - Race Conditions
01:08:10 - SQL Transactions
01:09:08 - SQLAlchemy
01:09:45 - list.py
01:15:42 - import.py
01:22:05 - passengers.py
01:25:19 - airline0
01:38:59 - airline1

This course picks up where Harvard University's CS50 leaves off, diving more deeply into the design and implementation of web apps with Python, JavaScript, and SQL using frameworks like Flask, Django, and Bootstrap. Topics include database design, scalability, security, and user experience. Through hands-on projects, students learn to write and use APIs, create interactive UIs, and leverage cloud services like GitHub and Heroku. By course's end, students emerge with knowledge and experience in principles, languages, and tools that empower them to design and deploy applications on the Internet.

is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming.

***

HOW TO SUBSCRIBE

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/cs50
Ed: https://cs50.harvard.edu/x/ed
Facebook Group: Page: https://github.com/cs50
Gitter: https://gitter.im/cs50/x
Instagram: Group: Page: https://cs50.medium.com/
Quora: https://www.quora.com/topic/CS50
Reddit: https://cs50.edx.org/slack
Snapchat: Exchange: https://cs50.stackexchange.com/
TikTok: TO FOLLOW DAVID J. MALAN

Facebook: https://github.com/dmalan
Instagram: https://www.quora.com/profile/David-J-Malan
TikTok: SHOP

https://cs50.harvardshop.com/

***

LICENSE

CC BY-NC-SA 4.0
Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International Public License
https://creativecommons.org/licenses/by-nc-sa/4.0/

David J. Malan
https://cs.harvard.edu/malan