DevOps for Databases in Azure with MySQL and Terraform
26mIntermediate2021-10-11
Authors
CloudSkills.io
Cloud and DevOps Training and Consulting Firm
Michael Levan
Cloud and DevOps Training Professional
Course details
If you’re already familiar with DevOps practices and are wondering if these methods can apply to databases as well, this is the course for you. In this project-focused course from CloudSkills, instructor Michael Levan reveals how DevOps for databases is not all that different from what you might already be doing. Michael starts off with some basics of DevOps for databases, like why it’s important, and the tools you use in DevOps today that can be used with databases. He then gets into the project, showing how to create a MySQL database with Terraform, and how to take that same Terraform configuration and automate, via CI/CD, the MySQL dataset creation with Azure DevOps. If you’ve been wondering why you might want to use DevOps for databases, this course provides some answers—you no longer have to hold up app delivery; collaboration between teams means better deployment outcomes, procedures, and automation—along with a project you can work on that illustrates these benefits.
Skills covered
Data CentersDevOps ToolsDatabase DevelopmentDevOpsDatabase ManagementAzureCloud ServicesProjectCloud ComputingMicrosoftSoftware Development
Concepts
0. Introduction
- 01 - DevOps for databases
1. DevOps for Databases
- 02 - Creating a MySQL database in Azure with Terraform
- 03 - Running the Terraform creation in Azure DevOps
- 04 - Storing SQL code in GitHub
- 05 - Running a SQL query in Azure DevOps
- 06 - Testing the SQL query in Azure DevOps