Skip to main content

HarvardX: CS50's Introduction to Databases with SQL

An introduction to databases using a language called SQL.

CS50's Introduction to Databases with SQL
7 weeks
6–12 hours per week
Self-paced
Progress at your own speed
Free
Optional upgrade available

There is one session available:

45,340 already enrolled! After a course session ends, it will be archivedOpens in a new tab.
Starts Apr 19
Ends Dec 31

About this course

Skip About this course

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.

At a glance

  • Language: English
  • Video Transcript: English
  • Associated programs:
  • Associated skills:Data Store, MySQL, Java (Programming Language), Foreign Keys, Scalability, Python (Programming Language), PostgreSQL, SQL (Programming Language), SQLite, Relational Databases

What you'll learn

Skip What you'll learn
  • CREATE TABLE
  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • DROP
  • CREATE INDEX
  • CREATE VIEW
  • SQLite, PostgreSQL, MySQL
  • connectors (Python, Java)
  • replication

This course is part of Computer Science for Databases using SQL Professional Certificate Program

Learn more 
Expert instruction
2 skill-building courses
Self-paced
Progress at your own speed
5 months
6 - 16 hours per week

Interested in this course for your business or team?

Train your employees in the most in-demand topics, with edX For Business.