edX

CS50's Introduction to Databases with SQL

Name: CS50's Introduction to Databases with SQL
Price: 299 USD
Availability: InStock

20k studentsBEGINNEREnglish

Korshub's take

SQL Fundamentals: From SQLite to Production

This is a complete relational-database education. You'll move through the full lifecycle—creating tables with proper types, constraints, and triggers; normalizing data to eliminate redundancy; joining tables with primary and foreign keys; and automating searches with views and indexes. The course bridges multiple database engines, starting with SQLite for portability and graduating to PostgreSQL and MySQL for production scale.

Assignments draw from real datasets, and you'll learn to connect SQL with Python and Java, giving you both the query language and the bridge to application code. Ideal for anyone building data-backed systems.

About this course

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.

Price

$299

No active coupon right now

View Course →