중급 코드 지구

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