# Prisma production guardrails course

> Separate database environments, roles, and connections; run expand-transition-contract migrations; and connect rollback, PITR, SLOs, and change governance.

- Canonical: https://learning.reopt.ai/en/courses/prisma-production
- Language: en
- HTML: https://learning.reopt.ai/en/courses/prisma-production

---

[Enterprise product delivery](/en/tracks/enterprise-delivery)

# Prisma production guardrails

Safe environments, migrations, recovery, and observability

Separate database environments, roles, and connections; run expand-transition-contract migrations; and connect rollback, PITR, SLOs, and change governance.
Advanced 8 lessons 515 XP About 89 min

Source · Handbook · Prisma production guardrails · Source reviewed 2026-07-01

Complete the prerequisite courses first
[Enterprise monorepo architecture](/en/courses/enterprise-monorepo) to unlock this course.

[Study prerequisites](/en/courses/enterprise-monorepo)

![Prisma production guardrails course](/images/home/track-enterprise-delivery.png)
0%

Course progress 9 learning steps

## What you'll learn

- Separate environments, roles, pooled and direct connections, and connection budgets.
- Design zero-downtime changes with expand-transition-contract compatibility windows.
- Choose code rollback, rollforward, or PITR from failure evidence.
- Operate restore drills, three-layer observability, approvals, and change freezes.

1

## 1. 환경·권한·연결 토폴로지

운영 사고를 줄이는 가장 바깥의 경계를 먼저 고정합니다.

- 코드보다 환경 경계가 먼저다 prod 분리, role account, pooled/direct URL과 connection budget Concept 45 XP
- Prisma 운영 경계 퀴즈 환경·권한·연결 경로 선택 Quiz 50 XP

2

## 2. 무중단 마이그레이션

스키마와 앱 배포를 분리하고 호환성 창을 운영합니다.

- Expand→Transition→Contract 위험 변경 분해, static check, staging rehearsal와 배포 창 Concept 45 XP
- 실전: email 컬럼 이름 변경 한 번의 RENAME을 호환 가능한 릴리즈로 분해 Scenario 60 XP

3

## 3. 실패 대응·Rollback·DR

사용자 영향, DB 상태, 복구 목표에 따라 안전한 순서를 선택합니다.

- Rollback은 데이터 되감기부터가 아니다 실패 4유형, code rollback→rollforward→PITR와 계층 백업 Concept 45 XP
- Migration 장애·DR 준비도 격리·복구·증거·리허설 점검 Checklist 55 XP

4

## 4. 관측·SLO·변경 거버넌스

요청·ORM·DB 신호와 변경 승인·freeze 정책을 연결합니다.

- 느린 요청을 세 레이어로 추적하기 App·Prisma·DB 관측, trace 연결, error budget과 policy Concept 45 XP
- 워크북: DB 변경 운영 정책 SLO·관측·승인·freeze·예외 규칙 설계 Workbook 70 XP

## Final challenge

Turn what you learned into a reusable work artifact.

- 최종 챌린지 · 프로덕션 DB 변경 계획 환경·migration·복구·관측을 포함한 end-to-end 실행안 Complete lessons first 100 XP

---

Site guide for agents: https://learning.reopt.ai/llms.txt · Sitemap: https://learning.reopt.ai/sitemap.xml · Contact: https://learning.reopt.ai/contact