/
lectern.tv
Play15s30s1x0:00/--:--
DoneWatched
Expand
lectern.tv
34:47/2:14:05
1:01
31:59
24:02
1:29
0:59
13:59
1:35
2:39
29:41
8:20
4:46
6:17
7:18
SQL & Relational Databases
Harvard's David J. Malan explores database management, transitioning from Python and flat-files to relational databases, SQL schemas, queries, indexing, and security.
David J. Malan introduces database management and the Structured Query Language (SQL) in CS50. The lecture demonstrates how to store, query, and manipulate data using Python alongside flat-file CSV structures before transitioning to relational databases like SQLite, covering schemas, CRUD operations, joins, indexing, and security vulnerabilities such as SQL injection.
Referenced inHarvard CS50 OpenCourseWare · CS50 (Fall 2023)
Lecture Guide
- 1Flat-file databases (like CSVs) store data in plain text, requiring custom code or libraries to query.
- 2Relational databases store data across multiple related tables using primary and foreign keys to avoid redundancy.
- 3SQL is a declarative language built around CRUD operations: Create, Read, Update, and Delete.
- 4Database joins (such as INNER JOIN) combine rows from multiple tables based on related columns.
Proofs, Examples & Demos
Assumed Background
Part of course·Lecture 9 of 18
CS50: Introduction to Computer Science
About the lecturer
Gordon McKay Professor of the Practice of Computer Science at Harvard University
Gordon McKay Professor of the Practice of Computer Science at Harvard University and lead instructor of CS50.
2 courses · 28 lectures in archiveView profile
Discussion
Share a seminar note, question, or timestamped reference (e.g. 14:20)...Sign in