CS50 2020 - Lecture 7 - SQL

TABLE OF CONTENTS 00:00:00 - Introduction 00:00:49 - Data 00:01:34 - Spreadsheets 00:08:50 - Flat-File Databases 00:10:53 - CSV Files 00:11:44 - 00:21:05 - Data Cleaning 00:23:06 - sorted 00:47:03 - Lambda Functions 00:56:49 - Relational Databases 00:57:55 - SQLite 01:04:54 - SQL 01:05:04 - CRUD 01:09:17 - SELECT 01:12:49 - DISTINCT 01:14:55 - LIKE 01:17:37 - ORDER BY 01:18:49 - GROUP BY 01:26:42 - INSERT 01:31:44 - UPDATE 01:32:36 - DELETE 01:33:57 - Relational Data 01:37:55 - Data Types 01:38:40 - Constraints 01:39:46 - PRIMARY KEY 01:41:09 - FOREIGN KEY 01:42:59 - CS50 Library 01:44:35 - Many-to-Many Relationships 02:05:00 - IMDb 02:12:45 - Indexes 02:15:11 - JOINs 02:20:34 - SQL Injection 02:26:02 - Race Conditions 02:32:00 - Race Conditions (Demo) *** This is CS50, Harvard University’s introduction to the intellectual enterprises of computer science and the art of programming. *** HOW TO SUBSCRIBE HOW TO TAKE CS50 edX: https