تصميم قواعد البيانات
نمذج بياناتك بإتقان واختر النوع المناسب من قواعد البيانات.
Good apps start with a good data model. In this track you turn features into entities and relationships, choose keys that never need to change, and clean a messy spreadsheet into tables with normalization. Then you design for real use: data types that can't lose a cent or an hour, constraints that guard your rules, indexes shaped by the queries you actually run, counters that make popular pages fast, and the right kind of database for each job.
Every example is PostgreSQL you can run, and the track ends with you designing a seasonal game leaderboard on your own.
- الدروس
- ١٤
- الوقت
- ٢ ساعة
- المستوى
- متوسط
دروس هذا المسار بالإنجليزية حاليًا.
- البرونز متاحة
- الفضة متاحة
- الذهب مقفلة
مستعد لإثبات نفسك؟
ثلاثة امتحانات في انتظارك: البرونز والفضة والذهب.
ما ستتمكن من فعله
- Turn a feature description into entities, relationships and an ER sketch
- Choose primary keys and build one-to-many and many-to-many tables
- Normalize messy data to third normal form
- Pick data types and constraints that keep data correct
- Design indexes and counters for the queries you really run
- Choose between relational, document, key-value, graph, search and time-series stores
الرحلة
١ الوحدة ١Model the world
Find entities and relationships, choose keys, and normalize messy data into clean tables.
٠ / ٤٢ الوحدة ٢Design for real use
Types, constraints, indexes, counters, and the right database for each job.
٠ / ٦٣ الوحدة ٣Next steps
Change live schemas safely, split huge tables, keep history and model data for analytics.
٠ / ٤