<- Back to all courses

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 need to apply schema and data changes to PostgreSQL in production safely and reliably.
You’ll learn how to plan and execute these modifications with confidence and minimal risk.

The goal is simple: to help you implement DDL and DML changes in PostgreSQL with limited downtime and no unpleasant surprises.

Register

What You’ll Learn

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

Next course date:

Tue 14 August 13:00-16:00 CEST

Cost: €150 before taxes.

  • Session will be conducted in English via Zoom.

  • Participants must have the latest version of Zoom installed on their computer.

  • Session will not be recorded.

  • There are no scheduled breaks during the session.

  • 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!

*By providing your information, you consent to its processing as described in our Privacy Policy and agree to receive updates and communications from Data Egret GmbH. You may withdraw your consent at any time.

Course duration: 1 session; 3 hours 

Course cost: €150 before taxes

 

📝 Following form submission: You’ll receive payment instructions via email.

💳 Payment Methods: Credit card or direct bank transfer.

⚠️ Important: Your spot is only confirmed once payment is received.

Instructors

Daria Nikolaenko is a database specialist with a strong focus on monitoring, high availability, performance tuning, and scalable system architecture. She has hands-on experience with PostgreSQL exporters and metric analysis, and brings deep expertise in building robust data infrastructures.
With a background in banking, finance, and telecommunications, Daria combines technical precision with real-world reliability.
Daria Nikolaenko
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.

Ilya Kosmodemiansky
CEO, Founder, Data Egret GmbH & PostgreSQL Consultant

© 2025 All Rights Reserved.