Orta Kod Mahallesi

PostgreSQL

Güçlü, açık kaynaklı veritabanı, derinlemesine.

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.

Dersler: 21
Süre: 3 sa
Seviye: Orta

Kursa başla · Why PostgreSQL?

Bu kursun dersleri şimdilik İngilizce.

Bronz açık
Gümüş açık
Altın kilitli

Kanıtlamaya hazır mısın?

Üç sınav seni bekliyor: Bronz, Gümüş ve Altın.

Sınavlara git

Neler yapabileceksin

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

Yolculuk

1
Bölüm 1
Postgres essentials

Why Postgres, and how to find your way around a server with psql.

0 / 3
2
Bölüm 2
Rich data types

Store text, money, time, documents and lists the Postgres way.

0 / 4
3
Bölüm 3
Indexes and performance

Read query plans and build the indexes that make them fast.

0 / 3
4
Bölüm 4
Transactions and concurrency

Stay correct when thousands of users write at the same moment.

0 / 3
5
Bölüm 5
Advanced SQL in Postgres

Leaderboards, trees, top-N per group and real search, in plain SQL.

0 / 4
6
Bölüm 6
Running Postgres

Security, pooling, VACUUM, backups and monitoring in production.

0 / 4