Video

CS50 2020 – Lecture 7 – SQL

Post author By CS50
Post date January 27, 2022
21 Comments on 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 – Data Types
01:38:40 – Constraints
01:39:46 – PRIMARY KEY
01:41:09 – FOREIGN KEY
01:42:59 – CS50 Library
01:44:35 – Many-to-Many Relationships
02:05:00 – IMDb
02:12:45 – Indexes
02:15:11 – JOINs
02:20:34 – SQL Injection
02:26:02 – Race Conditions
02:32:00 – Race Conditions (Demo)

***

This is CS50, Harvard University’s introduction to the intellectual enterprises of computer science and the art of programming.

***

HOW TO SUBSCRIBE

http://www.youtube.com/subscription_center?add_user=cs50tv

HOW TO TAKE CS50

edX: https://cs50.edx.org/
Harvard Extension School: https://cs50.harvard.edu/extension
Harvard Summer School: https://cs50.harvard.edu/summer
OpenCourseWare: https://cs50.harvard.edu/x

HOW TO JOIN CS50 COMMUNITIES

Discord: https://discord.gg/T8QZqRx
Ed: https://cs50.harvard.edu/x/ed
Facebook Group: https://www.facebook.com/groups/cs50/
Faceboook Page: https://www.facebook.com/cs50/
GitHub: https://github.com/cs50
Gitter: https://gitter.im/cs50/x
Instagram: https://instagram.com/cs50
LinkedIn Group: https://www.linkedin.com/groups/7437240/
LinkedIn Page: https://www.linkedin.com/school/cs50/
Reddit: https://www.reddit.com/r/cs50/
Quora: https://www.quora.com/topic/CS50
Slack: https://cs50.edx.org/slack
Snapchat: https://www.snapchat.com/add/cs50
Twitter: https://twitter.com/cs50
YouTube: http://www.youtube.com/cs50

HOW TO FOLLOW DAVID J. MALAN

Facebook: https://www.facebook.com/dmalan
GitHub: https://github.com/dmalan
Instagram: https://www.instagram.com/davidjmalan/
LinkedIn: https://www.linkedin.com/in/malan/
Quora: https://www.quora.com/profile/David-J-Malan
Twitter: https://twitter.com/davidjmalan

***

CS50 SHOP

https://cs50.harvardshop.com/

***

LICENSE

CC BY-NC-SA 4.0
Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International Public License
https://creativecommons.org/licenses/by-nc-sa/4.0/

David J. Malan
https://cs.harvard.edu/malan
malan@harvard.edu

source

Tags 10minute mail, api power bi, arduino, arduino ide, azuredatastudio, bigdata, bool mysql, cheap vps, code python, Computer, cs50, data, data base file, data driving, databases, datacleaning, datacollector, datafabric, datahub, datalake, datalineage, datamanagement, datamigration, dataprocessing, dataquality, datasteward, datastudio google, datavisualization, datawarehouse, datax, datetime sql, David, dbeaver, dbschema, edw, email services, eurostat data, eurostat database, free vps, general, general energy, general mor, gmail log in mail, gnu gpl, gnu radio, google bi, google datas, google datastudio, google gmail, gpl v3, graphics, hardware, harvard, host server free, hostdomain, hotmail sign, influxdb, j., kaggle titanic, knime, mail gmail, mail microsoft, mail si, mail temporary, malan, mariadb, masterdata, microsoft sql server, mongodb db, mongoexport, mongoimport, mssql, mysql datetime, mysql export database, mysql log, mysqlworkbench, networking, nosql, odbc, open office apache, opensource, operating systems, outlook web, phpmyadmin, postgre, postgresql copy, postgresql jsonb, programming, python fn, python zen, query sql, rawgraphs, row data, science, sign mail gmail, small data, smtp, software, spark apache, sql, sql server, sql server data type, sql server management studio, sql type, sqldbm, studio google, system administration, tera term, the hosting, tutor python, un comtrade, uncomtrade, vlan, vps, vps host, wan, webhosting, webmail, webscraper, wifis

21 replies on “CS50 2020 – Lecture 7 – SQL”

Can we get notes too !

The best SQL class I ever had

Prof David brought me to computer science and I am now enrolled in a degree program at Harvard. Thank you 🙏🏿

Biran goes out to buy another fridge.

How could you delete Friends from database?! 🙁

This week and week 8 were my favorites from the overall course. Really enjoyed it!

Why is row ID 507 not visible?

1:28:00

well so even here game of thrones seem to be the winner 😎

I have never enjoyed learning, doing homework, studying as much as doing CS50. This course is amazing

I believe David intentionally looked away from Lamda Calculus phrase and reference as to not overwhelm or worry with complexity. Always love the theatricality.

Thanks for the amazing lecture

2:35:13 "We hope you never forget if you take nothing away from today" You can see here how passionate he is for teaching. Thank you to David, Brian and all the staff.