On-Demand / 25 minutes
Learn how to deploy database changes and updates using DevOps patterns and practices with MySQL, Terraform, and Azure.
Michael Levan is a Cloud & DevOps Enablement consulting/training pro who spends his time creating real-world based content and consulting for customers around the globe.@TheNJDevOpsGuy
To kick off the DevOps for Databases project-focused course, we're going to talk about why practicing DevOps for databases is very-much the same as practicing DevOps with developer or infrastructure code.
When you're creating a database, the best way to do it is with code. That way, you aren't manually clicking through a UI. The best place to start is with Terraform, an infrastructure-as-code language. You use Hashicorp Configuration Language HCL to write the code to create a MySQL database in Azure and a firewall rule.
Taking the code that you wrote in video 2, you'll follow the same practices, but with a twist using CI/CD in Azure DevOps. The Terraform config files will be deployed via Azure DevOps to create a fully-functional pipeline that creates a database.
No code is ready to be used until you store it in source control. Once code is stored in source control, others can collaborate on it and see it so they understand what's happening in the environment. This same workflow is no different with SQL code.
Once code is committed to source control, which you learned about in video 4, you can take the same approach as developers take to run their code in a CI/CD pipeline. Using Azure DevOps, you will create a pipeline that will be used to deploy a MySQL query.
Code should always be tested, regardless of if it's application code, automation code, or even SQL code. The last video in this project-focused course shows you how to create a test using Python. Once the test is created, you use an Azure DevOps pipeline to run the test.
Feedback from active members of the CloudSkills Community
Wondering if training with CloudSkills.io is
going to be the right fit?
Here are answers to common questions.
What the prerequisites for this course?
We recommend that you have basic sysadmin skills, along with a high-level understanding of software development. You do not need to be a programmer to succeed in this course.
Who is this for?
CloudSkills is for anyone looking to build the technical and soft-skills required to succeed in the tech industry today. We welcome everyone, regardless if you come from an "ops" or "dev" background, or even if you're switching careers.
Do I need access to public cloud platforms?
We are big believers in hands-on practice, however, having immediate access to a public cloud platform is not a requirement for this course. Sit back and watch, and feel free to follow along if you'd like.
How long will I have access to the course?
You will have full access to the recordings with your purchase. You watch videos, follow our proven step-by-step process, get results.
The network of individuals I have connected with because of CloudSkills.io is outstanding. The value of the classes, both for networking and for course content was very good. The opportunities I have had because I was enrolled have been astounding to me.@derekschauland