# PostgreSQL 后端开发：基础课程

> 使用 SQL 和 PL/pgSQL 实现函数、过程、触发器、动态命令和服务器端逻辑。

---

LLMS 索引： [llms.txt](/llms.txt)

---

<!-- Generated by scripts/generate_skeleton.py. -->

这里整理 PGPRO 培训的八门 PostgreSQL 课程。中文页先固定课程顺序、主题键和来源关系，下一步可以逐页加工译文。

> **资料状态:** 中文译文骨架，正文待加工

> **翻译基线:** English。英文完整 16 版课程包已公开，俄文完整 16 版用于逐章交叉核对。

## 课程定位

使用 SQL 和 PL/pgSQL 实现函数、过程、触发器、动态命令和服务器端逻辑。

## 资料状态

| 语言 | 当前公开包 | 版本 | 主题数 | 课程页 |
| --- | --- | --- | ---: | --- |
| English | [DEV1-handouts-16-en.zip](https://edu.postgrespro.com/16/DEV1-handouts-16-en.zip) | 16 | 21 | [HTTP 200](https://postgrespro.com/community/courses/DEV1) |
| Русский | [DEV1-handouts-16.zip](https://edu.postgrespro.ru/16/DEV1-handouts-16.zip) | 16 | 21 | [HTTP 200](https://postgrespro.ru/education/courses/DEV1) |

## 课程目录

- [00 Basic Course](/dev1/dev1-00-introduction/)
- [01 Installation and Management, psql](/dev1/dev1-01-tools-overview/)
- [02 PostgreSQL Fundamentals](/dev1/dev1-02-arch-general/)
- [03 Isolation and MVCC](/dev1/dev1-03-arch-mvcc-overview/)
- [04 Buffer Cache and WAL](/dev1/dev1-04-arch-wal-overview/)
- [05 Logical Structure](/dev1/dev1-05-data-logical/)
- [06 Physical Structure](/dev1/dev1-06-data-physical/)
- [07 Data Schema and API](/dev1/dev1-07-bstore-schema/)
- [08 Functions](/dev1/dev1-08-sql-func/)
- [09 Procedures](/dev1/dev1-09-sql-proc/)
- [10 Composite Types](/dev1/dev1-10-sql-row/)
- [11 Overview and Programming Structures](/dev1/dev1-11-plpgsql-introduction/)
- [12 Query Execution](/dev1/dev1-12-plpgsql-queries/)
- [13 Cursors](/dev1/dev1-13-plpgsql-cursors/)
- [14 Dynamic Commands](/dev1/dev1-14-plpgsql-dynamic/)
- [15 Arrays](/dev1/dev1-15-plpgsql-arrays/)
- [16 Error Handling](/dev1/dev1-16-plpgsql-exceptions/)
- [17 Triggers](/dev1/dev1-17-plpgsql-triggers/)
- [18 Debugging](/dev1/dev1-18-plpgsql-debug/)
- [19 Overview](/dev1/dev1-19-access-overview/)
- [20 Logical Backup](/dev1/dev1-20-backup-logical/)

## 辅助资料

- `catalogs.pdf`
- `datatypes.pdf`
- `dev1_new_features.pdf`
- `dev1_student_guide.pdf`
- `unix_commands.pdf`

## 编辑状态

英文和俄文页已经从官方 PDF 提取为原生 Markdown；中文页保留同一主题结构，用于后续翻译、术语统一、图表重建和交叉引用。

- [课程版本矩阵](/versions/)
- [可执行翻译清单](/checklist/)
- [来源与许可](/about/)

---

本节页面：

- [第 00 讲：PostgreSQL Backend Development / Basic Course（待翻译）](/dev1/dev1-00-introduction/): 中文译稿占位页：PostgreSQL Backend Development / Basic Course
- [第 01 讲：Basic Tools / Installation and Management, psql（待翻译）](/dev1/dev1-01-tools-overview/): 中文译稿占位页：Basic Tools / Installation and Management, psql
- [第 02 讲：Architecture / PostgreSQL Fundamentals（待翻译）](/dev1/dev1-02-arch-general/): 中文译稿占位页：Architecture / PostgreSQL Fundamentals
- [第 03 讲：Architecture / Isolation and MVCC（待翻译）](/dev1/dev1-03-arch-mvcc-overview/): 中文译稿占位页：Architecture / Isolation and MVCC
- [第 04 讲：Architecture / Buffer Cache and WAL（待翻译）](/dev1/dev1-04-arch-wal-overview/): 中文译稿占位页：Architecture / Buffer Cache and WAL
- [第 05 讲：Data Organization / Logical Structure（待翻译）](/dev1/dev1-05-data-logical/): 中文译稿占位页：Data Organization / Logical Structure
- [第 06 讲：Data Organization / Physical Structure（待翻译）](/dev1/dev1-06-data-physical/): 中文译稿占位页：Data Organization / Physical Structure
- [第 07 讲：The Bookstore App / Data Schema and API（待翻译）](/dev1/dev1-07-bstore-schema/): 中文译稿占位页：The Bookstore App / Data Schema and API
- [第 08 讲：SQL / Functions（待翻译）](/dev1/dev1-08-sql-func/): 中文译稿占位页：SQL / Functions
- [第 09 讲：SQL / Procedures（待翻译）](/dev1/dev1-09-sql-proc/): 中文译稿占位页：SQL / Procedures
- [第 10 讲：SQL / Composite Types（待翻译）](/dev1/dev1-10-sql-row/): 中文译稿占位页：SQL / Composite Types
- [第 11 讲：PL/pgSQL / Overview and Programming Structures（待翻译）](/dev1/dev1-11-plpgsql-introduction/): 中文译稿占位页：PL/pgSQL / Overview and Programming Structures
- [第 12 讲：PL/pgSQL / Query Execution（待翻译）](/dev1/dev1-12-plpgsql-queries/): 中文译稿占位页：PL/pgSQL / Query Execution
- [第 13 讲：PL/pgSQL / Cursors（待翻译）](/dev1/dev1-13-plpgsql-cursors/): 中文译稿占位页：PL/pgSQL / Cursors
- [第 14 讲：PL/pgSQL / Dynamic Commands（待翻译）](/dev1/dev1-14-plpgsql-dynamic/): 中文译稿占位页：PL/pgSQL / Dynamic Commands
- [第 15 讲：PL/pgSQL / Arrays（待翻译）](/dev1/dev1-15-plpgsql-arrays/): 中文译稿占位页：PL/pgSQL / Arrays
- [第 16 讲：PL/pgSQL / Error Handling（待翻译）](/dev1/dev1-16-plpgsql-exceptions/): 中文译稿占位页：PL/pgSQL / Error Handling
- [第 17 讲：PL/pgSQL / Triggers（待翻译）](/dev1/dev1-17-plpgsql-triggers/): 中文译稿占位页：PL/pgSQL / Triggers
- [第 18 讲：PL/pgSQL / Debugging（待翻译）](/dev1/dev1-18-plpgsql-debug/): 中文译稿占位页：PL/pgSQL / Debugging
- [第 19 讲：Access Control / Overview（待翻译）](/dev1/dev1-19-access-overview/): 中文译稿占位页：Access Control / Overview
- [第 20 讲：Backup / Logical Backup（待翻译）](/dev1/dev1-20-backup-logical/): 中文译稿占位页：Backup / Logical Backup