CS50 2021 in HDR - Lecture 7 - SQL

Name: CS50 2021 in HDR - Lecture 7 - SQL
Uploaded: 2022-01-01T00:21:58Z
Channel: CS50
Description: This is CS50, Harvard University's Introduction to the intellectual enterprises of computer science and the art of programming. Enroll for free at https...

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

This is CS50, Harvard University's Introduction to the intellectual enterprises of computer science and the art of programming. Enroll for free at https://cs50.edx.org/. Slides, source code, and more at https://cs50.harvard.edu/x. Playlist at https://www.youtube.com/playlist?list=PLhQjrBD2T383f9scHRNYJkior2VvYjpSL. TABLE OF CONTENTS 00:00:00 - Introduction 00:01:17 - SQL 00:03:21 - Data Collection 00:07:46 - Flat File Databases 00:09:24 - Reading from a CSV 00:14:26 - Filtering Duplicates 00:21:21 - Counting Titles 00:28:53 - Sorting Data 00:30:26 - Lambda Functions 00:36:07 - Cleaning Data …

Watch on YouTube ↗ (saves to browser)

Chapters (32)

Introduction

1:17 SQL

3:21 Data Collection

7:46 Flat File Databases

9:24 Reading from a CSV

14:26 Filtering Duplicates

21:21 Counting Titles

28:53 Sorting Data

30:26 Lambda Functions

36:07 Cleaning Data

39:48 Regular Expressions

45:50 Search

48:17 Relational Databases

51:20 Create, Read, Update, Delete

53:32 sqlite3

57:09 SELECT

1:01:58 WHERE

1:04:37 DELETE

1:05:59 UPDATE

1:11:31 Redundancies

1:18:00 Table Relationships

1:27:49 INSERT

1:30:10 Python and SQL

1:39:55 shows.db

1:41:49 SQL Types

1:43:11 Many-to-Many Relationships

1:48:27 Indexes

1:59:14 JOIN

2:03:38 SQL Injection Attacks

2:11:15 Race Conditions

2:20:10 Transactions

2:21:26 This was CS50

Playlist

Uploads from CS50 · CS50 · 0 of 60

← Previous Next →