
HarvardX: CS50's Introduction to Databases with SQL
An introduction to databases using a language called SQL.
Why choose edX Subscription?
Course Insight
Suitable for beginner learners. This course serves as an entry point into Business & Management, building foundational knowledge before moving on to advanced frameworks or specialized paths.
SKILLS TO
MASTER
Quick Facts
What You’ll Learn
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.
Outcomes
- CREATE TABLE.
- SELECT.
- INSERT.
- UPDATE.
- DELETE.
- DROP.
- CREATE INDEX.
- CREATE VIEW.
- SQLite, PostgreSQL, MySQL.
- connectors (Python, Java).
- replication.
FAQs
Top Alternatives
Highly-rated courses worth your attention







