Individual Course
CS50’s Introduction to Databases with SQL
Course Length
7 weeks
3-6 hours a week
Featuring faculty from:
Harvard John A. Paulson School of Engineering and Applied Sciences
Enroll as Individual
Certificate Price:
$ 299
Enroll as Individual
Certificate Price:
$ 299
An introduction to databases using a language called SQL in an online course from Harvard.
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.
Self-Guided
edX
- Learning Outcome
CREATE TABLE, SELECT, INSERT, UPDATE, DELETE, DROP, CREATE INDEX, and CREATE VIEW
- Learning Outcome
SQLite, PostgreSQL, MySQL connectors (Python, Java) replication
- Learn from Harvard faculty
- Do it on your own time
- Get a certificate, add it to your resume
- Be part of the Harvard Community
Ways to take this course
Audit or Pursue a Verified Certificate
A Verified Certificate costs $299 and provides unlimited access to full course materials, activities, tests, and forums. At the end of the course, learners who earn a passing grade can receive a certificate.
Alternatively, learners can Audit the course for free and have access to select course material, activities, tests, and forums. Please note that this track does not offer a certificate for learners who earn a passing grade.
Faculty
Your Instructor
David J. Malan
Gordon McKay Professor of the Practice of Computer Science, Harvard University
David J. Malan is Gordon McKay Professor of the Practice of Computer Science at Harvard University in the School of Engineering and Applied Sciences as well as a Member of the Faculty of Education in the Graduate School of Education. He teaches Computer Science 50, otherwise known as CS50, which is among Harvard University's largest courses, one of Yale University's largest courses, and edX's largest MOOC. He also teaches at Harvard Business School, Harvard Law School, Harvard Extension School, and Harvard Summer School.
Stay tuned for more
Don’t miss a thing. Subscribe to our newsletter and get updates on exclusive content for Harvard Online learners.