للحصول على شهادة
This course is an introduction to databases using SQL from Harvard’s CS50 program. It is designed to help learners understand how modern databases work and how data is stored, organized, and managed in real-world systems.
The course starts with the basics of querying data using SQL, teaching how to create, read, update, and delete information in relational databases. It explains how data is structured in tables with rows and columns, and how real-world entities can be modeled using proper database design techniques.
Learners will explore relationships between tables using primary and foreign keys, and understand how to join data from multiple tables efficiently. The course also covers advanced concepts such as normalization, which helps reduce data redundancy and improve database structure.
In addition, students will learn about views for simplifying queries and indexes for improving performance. The course also introduces how SQL connects with programming languages like Python and Java for building real applications.
Finally, it explains database systems at scale, including SQLite for simplicity and PostgreSQL and MySQL for larger, production-level systems.
By the end of this course, learners will have a strong foundation in database design, SQL querying, and real-world database optimization techniques.