CS50 2020 - Lecture 7 - SQL

Name: CS50 2020 - Lecture 7 - SQL
Uploaded: 2021-03-01T22:16:59Z
Channel: CS50
Description: 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 - favorit...

CS50 · Beginner ·📊 Data Analytics & Business Intelligence ·5y ago

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 - favorites.py 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 Librar…

Watch on YouTube ↗ (saves to browser)

Chapters (34)

Introduction

0:49 Data

1:34 Spreadsheets

8:50 Flat-File Databases

10:53 CSV Files

11:44 favorites.py

21:05 Data Cleaning

23:06 sorted

47:03 Lambda Functions

56:49 Relational Databases

57:55 SQLite

1:04:54 SQL

1:05:04 CRUD

1:09:17 SELECT

1:12:49 DISTINCT

1:14:55 LIKE

1:17:37 ORDER BY

1:18:49 GROUP BY

1:26:42 INSERT

1:31:44 UPDATE

1:32:36 DELETE

1:33:57 Relational Data

1:37:55 Data Types

1:38:40 Constraints

1:39:46 PRIMARY KEY

1:41:09 FOREIGN KEY

1:42:59 CS50 Library

1:44:35 Many-to-Many Relationships

2:05:00 IMDb

2:12:45 Indexes

2:15:11 JOINs

2:20:34 SQL Injection

2:26:02 Race Conditions

2:32:00 Race Conditions (Demo)

Playlist

Uploads from CS50 · CS50 · 0 of 60

← Previous Next →