Harvard CS50 Databases with SQL | Full University Course

عدد الدروس : 1 عدد ساعات الدورة : 11:08:49 شهادة معتمدة : نعم التسجيل في الدورة للحصول على شهادة

للحصول على شهادة

  • 1- التسجيل
  • 2- مشاهدة الكورس كاملا
  • 3- متابعة نسبة اكتمال الكورس تدريجيا
  • 4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك
A complete Harvard CS50 course on databases and SQL covering CRUD operations, relational design, optimization, and real-world database systems.
عن الدورة

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.