CS50's Introduction to Databases with SQL
- Free
- Certificate included
- Course certificate
- Beginner
- 7 weeks
CS50's Introduction to Databases with SQL teaches relational databases from the ground up. You learn to create, read, update and delete data; to model real-world entities and relationships with tables, types, triggers and constraints; to normalize data to remove redundancy; to join tables with primary and foreign keys; to automate queries with views and speed them up with indexes; and to connect SQL to languages such as Python and Java. The course starts with SQLite for portability and ends with introductions to PostgreSQL and MySQL for scalability. Its seven weeks of material each pair a lecture with a problem set based on real-world datasets, and the course closes with a final project.
It is free to take through Harvard's OpenCourseWare, and a free edX account lets you submit work for feedback. Scoring at least 70% on every problem and the final project earns a free CS50 Certificate; a verified certificate is available through edX for a fee. Harvard lists the difficulty as introductory and the time commitment as 6 to 12 hours per week, and says the course can be taken before, during or after CS50x.
What you’ll learn
- Create, read, update and delete data in relational databases
- Design tables with appropriate types, triggers and constraints
- Normalize data and join tables with primary and foreign keys
- Use views to automate searches and indexes to speed them up
- Connect SQL to Python and Java
- Move from SQLite to PostgreSQL and MySQL
Who it’s for
Anyone who needs to query or design databases, from analysts to developers; no prior programming is assumed.
Source: Harvard Online (opens in a new tab) · Verified · Report a change
More free Harvard courses
Every Harvard course we have verified, with cost and certificate terms compared.
ProgrammingAll free programming courses
Free and free-to-audit programming courses from every provider, ranked.