Средний Квартал кода

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.

Уроки: 21
Время: 3 ч
Уровень: Средний

Начать курс · Why PostgreSQL?

Уроки этого курса пока на английском.

Бронза доступна
Серебро доступна
Золото закрыта

Готовы это доказать?

Вас ждут три экзамена: бронза, серебро и золото.

К экзаменам

Чему вы научитесь

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

Маршрут

1
Модуль 1
Postgres essentials

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

0 / 3
2
Модуль 2
Rich data types

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

0 / 4
3
Модуль 3
Indexes and performance

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

0 / 3
4
Модуль 4
Transactions and concurrency

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

0 / 3
5
Модуль 5
Advanced SQL in Postgres

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

0 / 4
6
Модуль 6
Running Postgres

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

0 / 4