Thursday, December 2nd, 2021

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 – 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…

Leave a Reply

Your email address will not be published. Required fields are marked *