Our notes on Harvard CS50
We wrote these notes when we read the Harvard CS50 site for our SQL comparisons. For each note, you see the day of our check and a link to the page that we read.
We give the label "Product's own words" to a note that holds only what Harvard CS50 says about its own product.
Harvard CS50 account
- For the problem sets, you log in to cs50.dev with a GitHub account. To submit the problem sets and the final project for feedback, CS50 tells you to create an edX account. Checked October 20, 2026 (source)
Harvard CS50 query check and help
- You check 17 of the 18 problems with check50. The other problem is a written answer. CS50 says that with check50 you see "what output it expected, and what output your program actually gave". Product's own words Checked October 21, 2026 (source)
Harvard CS50 SQL topics
- The video chapters are the lecture names: Querying, Relating, Designing, Writing, Viewing, Optimizing and Scaling. On the course site, CS50 lists the topics of week 1. Some of these are "Subqueries", "Joins: INNER JOIN, Outer Joins, LEFT JOIN, RIGHT JOIN, FULL JOIN, NATURAL JOIN" and "Groups: GROUP BY, HAVING". We found no window functions in the topics of the seven weeks or in the lecture notes. Checked October 20, 2026 (source)
- In the notes of lecture 1, CS50 has the sections "Subqueries", "JOIN" and "Groups". In the Groups section, CS50 says: "In this query, the GROUP BY keyword was used to create groups for each book and then collapse the ratings of the group into an average rating!" In the free code zip file of lecture 1, CS50 gives groups.sql, joins.sql and nested.sql. In the notes and the code files of the seven lectures, we found no window function. Checked October 31, 2026 (source)
Harvard CS50 SQL engines
- SQLite, then introductions to PostgreSQL and MySQL. In the description: "This course begins with SQLite for portability’s sake and ends with introductions to PostgreSQL and MySQL for scalability’s sake as well." Checked October 20, 2026 (source)
Harvard CS50 content and size
- Harvard CS50’s Intro to Databases with SQL – Full University Course Checked October 20, 2026 (source)
- freeCodeCamp.org. Carter Zenke teaches the course. Checked October 20, 2026 (source)
- 11:08:48 (11 h 9 min) Checked October 20, 2026 (source)
- English. YouTube shows one caption track: English (auto-generated). Checked October 20, 2026 (source)
- freeCodeCamp links the course site in the description ("Slides, source code, and more"). On the course site, CS50 gives the code of each lecture as a free zip file. For 13 of the 18 problems, you download the data (12 databases and one CSV file). For the other 5, you design the database yourself. Checked October 21, 2026 (source)
- CS50 gives seven problem sets on the course site, one for each week. Checked October 20, 2026 (source)
- CS50 gives a final project: you design and build "your very own database" on a subject that you choose. Checked October 20, 2026 (source)
- CS50 sends you to edX for a verified certificate or a professional certificate, and to Harvard Extension School for transfer credit. Checked October 20, 2026 (source)
- On each problem page, CS50 gives the task, the schema and the steps to test and submit. We found no answer query on the problem pages. Checked October 31, 2026 (source)
Harvard CS50 certificate
- None in the video. CS50 gives a free CS50 Certificate if you get a score of at least 70% on each problem and on the final project. For a verified certificate, CS50 sends you to edX. Checked October 20, 2026 (source)
Harvard CS50 updates
- October 9, 2025 Checked October 20, 2026 (source)