DDL/DML Migration Best Practices
Key strategies to safely manage schema (DDL) and data (DML) changes in PostgreSQL environments — with limited downtime and no unpleasant surprises.
Upcoming dates
Dates are being finalised — email us and we'll let you know the moment registration opens.
What you'll learn
Practical strategies to safely manage schema (DDL) and data (DML) changes in PostgreSQL environments: how to plan, execute, and verify changes without compromising stability or performance.
The course covers
- Prepare and test migrations — version-controlled, idempotent scripts, tested in staging with rollback plans
- Apply DDL changes safely — incremental schema updates, avoiding locking operations during peak hours
- Handle DML operations wisely — batched updates, no long transactions, staging complex changes with CTEs or temporary tables
- Execute and monitor effectively — automated rollouts, live metrics, validating results for data integrity
Prerequisites
Designed for developers who need to apply schema and data changes to PostgreSQL in production safely and reliably.
For details see the course terms & conditions.
Frequently asked questions
Who is this session for?
Developers who ship schema migrations against production PostgreSQL and want them to stop being risky — what blocks, what does not, and how to watch a migration while it runs.
Do I need my own PostgreSQL environment?
No. You need a computer with a stable internet connection and the latest version of Zoom. All demonstrations run on the instructor's environment.
Will I receive a certificate?
Yes — a certificate of attendance naming the session.
Is the session recorded?
No. The session is live and interactive, with direct Q&A. It is not recorded.
Is this part of a bigger programme?
Yes — it is one of the seven sessions of the High Performance SQL with Postgres track, and can be taken alone or as part of the full track.
Instructor
Over 15 years of experience across Oracle, DB2, MySQL, SQL Server and PostgreSQL. A recognised PostgreSQL contributor, active in the community through committees, user groups and international conferences.
Ready to book?
Live, small-group, taught by the people who run PostgreSQL in production. Questions first? Write to us — no sales pitch.