Learn AI, Data Science & Business — Earn Certificates That Get You Hired
Power BI Fundamentals - Create visualizations and dashboards from scratch
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Explore effective PostgreSQL change management strategies for Agile DBAs in this 52-minute conference talk from PGConf NYC 2021. Discover SQL-centric approaches to manage PostgreSQL as code, test changes, and deploy updates efficiently. Learn about tools like Sqitch, FlywayDB, pyrseas, and PostgresCompare to streamline schema and code changes. Gain insights into transforming your workflow, from database creation to deploying updates, and overcome common challenges faced by DBAs in Agile, Sprint-based teams. By the end, acquire the knowledge to tame rogue PostgreSQL databases, manage migrations with ease, and become an invaluable asset to your development team.
Syllabus
Introduction
Other presentations
What will be covered
The problem
Getting involved
Learning the team
What is devops
State of change management
Manual process
Join the circus
Current State of Database Change Management
Manual State
PostgreSQL Compare
StateBased
ORM
SQL migrations
Migration tools
Sketch
Conclusion
Taught by
Confreaks