CS50: Introduction to Computer Science
10-20 hours a week • Start today
Individual Course
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
CREATE TABLE, SELECT, INSERT, UPDATE, DELETE, DROP, CREATE INDEX, and CREATE VIEW
SQLite, PostgreSQL, MySQL connectors (Python, Java) replication
Your Instructor
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.
These courses can be bundled together to receive a professional certificate at a discounted price.
Learn More10-20 hours a week • Start today
Ways to take this course
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.
Don’t miss a thing. Subscribe to our newsletter and get updates on exclusive content for Harvard Online learners.