CS50W 2018 - Lecture 3 - SQL

From the creator

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. https://www.youtube.com/playlist?list=PLhQjrBD2T382hIW-IsOVuXP1uMzEvmcE5 *** This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming. *** HOW TO SUBSCRIBE http://www.youtube.com/subscription_center?add_user=cs50tv HOW TO TAKE CS50 edX: https://cs50.edx.org/ Harvard Extension Sc

Published 2018-02-13 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.