CS50 2020 Lecture 7 SQL

TABLE OF CONTENTS 00:00:00 Introduction 00:00:49 Data 00:01:34 Spreadsheets 00:08:50 FlatFile 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 ManytoMany 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