CS50's Introduction to Databases with SQL (Harvard)

Course audio: Course audio: English
Level: Beginner
Length: 8 lessons

What you'll be able to do

Query and join tables with SQL
Design database schemas and write data safely
Use views, indexes and transactions to optimise

About this course

Harvard's CS50 SQL course, taught in English by Carter Zenke, introduces relational databases through full-length lectures. After an introduction, the lectures cover querying, relating tables, designing schemas, writing data, creating views, optimizing with indexes and transactions, and scaling with MySQL and PostgreSQL. It suits beginners, analysts and developers who want a rigorous foundation in SQL and database design. Problem sets are available on the CS50 website. Afterwards, apply SQL to data analysis or a backend project.

Before you start: No programming experience needed; a computer with internet access.