PostgreSQL
قاعدة البيانات القوية مفتوحة المصدر، بالتفصيل.
PostgreSQL is the open-source database behind countless apps: posts, likes, points and game records all live in its tables. This track starts where the SQL course ends and teaches what makes Postgres special: psql, rich types such as jsonb and timestamptz, indexes and query plans, transactions and locking, window functions and full-text search, and running Postgres in production.
Everything is up to date for PostgreSQL 18, and every lesson is short, practical and checked with quizzes. The examples follow Nova, a made-up social app with users, posts, likes and game scores.
- الدروس
- ٢١
- الوقت
- ٣ ساعة
- المستوى
- متوسط
دروس هذا المسار بالإنجليزية حاليًا.
- البرونز متاحة
- الفضة متاحة
- الذهب مقفلة
مستعد لإثبات نفسك؟
ثلاثة امتحانات في انتظارك: البرونز والفضة والذهب.
ما ستتمكن من فعله
- Explore any Postgres server with psql and understand its databases, schemas and roles
- Choose the right types: timestamptz, numeric, uuid, jsonb, arrays and enums
- Read EXPLAIN ANALYZE and design indexes that make slow queries fast
- Keep data correct under load with transactions, row locks and UPSERT
- Build leaderboards, trees and search with window functions, recursive CTEs and full-text search
- Run Postgres in production: least privilege, pooling, VACUUM, backups and monitoring
الرحلة
١ الوحدة ١Postgres essentials
Why Postgres, and how to find your way around a server with psql.
٠ / ٣٢ الوحدة ٢Rich data types
Store text, money, time, documents and lists the Postgres way.
٠ / ٤٣ الوحدة ٣Indexes and performance
Read query plans and build the indexes that make them fast.
٠ / ٣٤ الوحدة ٤Transactions and concurrency
Stay correct when thousands of users write at the same moment.
٠ / ٣٥ الوحدة ٥Advanced SQL in Postgres
Leaderboards, trees, top-N per group and real search, in plain SQL.
٠ / ٤٦ الوحدة ٦Running Postgres
Security, pooling, VACUUM, backups and monitoring in production.
٠ / ٤