Best Practices for DDL / DML Migration
Key strategies to safely manage schema (DDL) and data (DML) changes in PostgreSQL environments
Tue 14 August,
13:00–16:00 CEST
This session is designed for developers who manage PostgreSQL databases and want to apply safe, reliable changes in production environments. You’ll learn how to plan and execute schema and data modifications with confidence and minimal risk.
The goal is simple: help you implement DDL and DML changes in PostgreSQL with limited downtime and avoiding surprises.
What You’ll Learn
- Bad modeling practices
- Misuse of SQL features
- Ignoring atomicity and constraints
- Inefficient queries
- Poor transaction management
During this session, you’ll learn practical strategies to safely manage schema (DDL) and data (DML) changes in PostgreSQL environments. We’ll cover essential techniques to help you plan, execute, and verify changes without compromising stability or performance:
- Prepare and test migrations: Use version-controlled, idempotent scripts and test thoroughly in staging with rollback plans.
- Apply DDL changes safely: Introduce schema updates incrementally, avoid locking operations during peak hours.
- Handle DML operations wisely: Use batching for updates, avoid long transactions, and stage complex changes with CTEs or temporary tables.
- Execute and monitor effectively: Automate rollouts, monitor live metrics, and validate results to ensure data integrity and system stability.
Format and Schedule
Session duration: 3 hours
Sessions will be conducted in English via Zoom.
Next session date:
Tue 14 August 13:00-16:00 CEST
Participants must have the latest version of Zoom installed on their computer.
Sessions will not be recorded.
The course format combines theoretical slides with live demos, led by the instructor in real time.
The session includes a live Q&A for direct interaction.
Participants will receive a certificate of attendance upon completion of the session.
Register now!
📝 After Registration: You’ll receive an invoice by email.
💳 Payment Methods: Credit card or direct bank transfer.
⚠️ Important: Your spot is only confirmed once payment is received.
Instructors
With a background in banking, finance, and telecommunications, Daria combines technical precision with real-world reliability.
PostgreSQL Database Administrator
Ilya has over 15 years of experience in IT, working across Oracle, DB2, MySQL, SQL Server, and PostgreSQL. His background includes high-availability systems, telecommunications, and mission-critical applications with complex legacy environments.
He is a recognised PostgreSQL contributor, actively involved in the community through committees, local user groups and conferences.
CEO, Founder, Data Egret GmbH & PostgreSQL Consultant