# Basic Server-Side Application Development

> SQL and PL/pgSQL functions, procedures, triggers, dynamic commands and server-side logic.

---

LLMS index: [llms.txt](/en/llms.txt)

---

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

This course keeps the official topic order and exposes the English handout as readable, native Markdown for review and future editorial work.

> **Source status:** 官方 PDF 已提取为原生 Markdown

> **Translation baseline:** English baseline. The current English archive is the working baseline; the Russian edition is retained for chapter-level cross-checking.

## Course scope

SQL and PL/pgSQL functions, procedures, triggers, dynamic commands and server-side logic.

## Source status

| Language | Current package | Version | Topics | Course page |
| --- | --- | --- | ---: | --- |
| 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) |

## Contents

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

## Supplementary materials

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

## Editorial status

The available English handout is extracted from the official PDF. Where no current English archive was found, the route remains ready for a later source edition.

- [Version matrix](/en/versions/)
- [Work checklist](/en/checklist/)
- [Sources and permissions](/en/about/)

---

Section pages:

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