CS50 · Technology

CS50

From the team that brought you CS50 at Harvard, Yale, and Oxford, this is the Fifty Foundation, led by David J. Malan et al. Theatrical courses in computer science and math. For free, for all. 🎭

Episodes

CS50 SQL - Lecture 3 - Writing

01 Oct 2023

1h 43m

AI processed

In this episode of CS50's introduction to databases with SQL, Carter Zanke discusses how to add, update, and delete data in SQL databases, using Boston's Museum of Fine Arts (MFA) as a practical example. The episode covers SQL commands such as INSERT INTO, DELETE FROM, and UPDATE, along with SQLite commands like .read ...

CS50 SQL - Lecture 2 - Designing

01 Oct 2023

1h 21m

AI processed

In this episode of CS50's introduction to databases with SQL, Carter Zanke discusses database schema design, focusing on creating tables, defining columns, and specifying data types and constraints. The episode uses the example of the Massachusetts Bay Transportation Authority (MBTA) subway system to illustrate how to ...

CS50 SQL - Lecture 1 - Relating

01 Oct 2023

1h 41m

AI processed

This podcast is a lecture and Q&A session on relational databases and SQL. Speaker 1, Carter Zanke, explains how to work with databases containing multiple tables, focusing on relationships between tables (one-to-one, one-to-many, many-to-many) and how to visualize them using entity-relationship diagrams. The lecture c...

CS50 SQL - Lecture 0 - Querying

01 Oct 2023

1h 19m

AI processed

This podcast introduces databases with SQL, explaining how to represent, organize, manage, and query data. Speaker 1, Carter Zanke, uses examples from Google, smartphones, and YouTube to illustrate the importance of data management skills in the information age. The discussion covers the concept of tables, their applic...