Learn · CS50 at Harvard

CourseCS50's Introduction to Databases with…7 lectures

CS50's Introduction to Databases with SQL

Carter Zenke and David J. Malan · Harvard University

Start with lecture 1 At CS50 at Harvard

About

This is CS50’s introduction to databases using a language called SQL. Learn how to create, read, update, and delete data with relational databases, which store data in rows and columns. Learn how to model real-world entities and relationships among them using tables with appropriate types, triggers, and constraints. Learn how to normalize data to eliminate redundancies and reduce potential for errors. Learn how to join tables together using primary and foreign keys. Learn how to automate searches with views and expedite searches with indexes. Learn how to connect SQL with other languages like Python and Java. Course begins with SQLite for portability’s sake and ends with introductions to PostgreSQL and MySQL for scalability’s sake as well. Assignments inspired by real-world datasets.

Whereas CS50x itself focuses on computer science more generally as well as programming with C, Python, SQL, and JavaScript, this course, aka CS50 SQL, is entirely focused on SQL. You can take CS50 SQL before CS50x, during CS50x, or after CS50x. But for an introduction to computer science itself, you should still take CS50x!

Watch an introduction

How to Take this Course

Even if you are not a student at Harvard, you are welcome to “take” this course for free via this OpenCourseWare by working your way through the course’s seven weeks of material. For each week, follow this workflow:

flowchart TD A[Watch Lecture] --> B[Submit Problem Set]

And then submit the course’s final project.

To submit the course’s problem sets and final project for feedback, be sure to create an edX account, if you haven’t already. Ask questions along the way via any of the course’s communities!

Lectures

  1. Querying Querying · Video
  2. Relating Relating · Video
  3. Designing Designing · Video
  4. Writing Writing · Video
  5. Viewing Viewing · Video
  6. Optimizing Optimizing · Video
  7. Scaling Scaling · Video

Syllabus and materials

At CS50 at Harvard, as the course publishes them.

Credits and licence

Institution
Harvard University
Department
CS50
Taught by
Carter Zenke, David J. Malan
Level
Undergraduate
Language
English
Subjects
Computer science
Source
CS50 at Harvard
Licence
CC BY-NC-SA 4.0, as CS50 at Harvard states it. Non-commercial use only. CS50 at Harvard's terms
Attribution
CS50, Harvard University. Licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license.
Who can watch
CS50 at Harvard gives no rating. Invisible Network shows it to Tweens profiles and older, judged from what the source says about it. How courses are placed