Deploying Docker for Database DevOps Dominance

Learn techniques to automate database testing and deployment using Docker in this conference talk from NDC Sydney 2020. Discover how to integrate databases into existing DevOps pipelines, accelerate feature deployment, and catch regression issues early. Explore the advantages of Continuous Integration and Continuous Deployment for databases, and understand the use of Docker and Kubernetes in database DevOps. Gain insights on unit testing, build servers, and DevOps pipelines specific to databases. Delve into topics such as integration tests, mocking databases, and handling lookup tables. Address challenges in database deployment, including data replication and rollback strategies. Equip yourself with knowledge to modernize database practices and achieve DevOps dominance in database management.

Introduction
Why Database DevOps
Definitions
Advantages
Docker
Kubernetes
Visual Studio
Unit Testing
Build Server
DevOps Pipeline
Additional Work
Integration Tests vs Database Tests
Mocking Databases
Lookup Tables
Additional Thoughts
Database Deployment
Replicating Data
The Real Challenge
Rolling Back
Questions