x
Menu

CS50: Web Programming with Python and JavaScript

Harvard,, Spring 2018 , Prof. David J. Malan

Updated On 02 Feb, 19

Overview

Topics include database design, scalability, security, and user experience. Through hands-on projects, you'll learn to write and use APIs, create interactive UIs, and leverage cloud services like GitHub and Heroku. By course's end, you'll emerge with knowledge and experience in principles, languages, and tools that empower you to design and deploy applications on the Internet.

Includes

Lecture 5: SQL - Lecture 3 - CS50's Web Programming with Python and JavaScript

4.1 ( 11 )


Lecture Details

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

Ratings

0


0 Ratings
55%
30%
10%
3%
2%
Comments
comment person image

Sam

Excellent course helped me understand topic that i couldn't while attendinfg my college.

Reply
comment person image

Dembe

Great course. Thank you very much.

Reply
Send