In this training, you’ll learn how to couple Postgres artifacts -such as schemas, tables, and procedures - with client application code as part of the inner and outer loops of your team's development workflows, for both Azure and open-source PostgreSQL.
You will learn about local development during the inner loop, addressing schema evolution, testing, and query optimization with commonly used OSS tools and programming frameworks like Visual Studio Code, Python, Node.JS, .NET and more.
Then you'll focus on how the outer loop encompasses deployment, monitoring, and scaling, emphasizing CI/CD practices and scaling strategies for both traditional on-premises and cloud environments.
Next, you'll cover tools and techniques to automate deployment of both infrastructure (Infrastructure as Code with Terraform, Bicep and other options) and application plus database artifacts using tools like GitHub Actions and more, with best practices for maintaining a secure, robust, integrated development workflow using Azure Database for PostgreSQL as a reference.