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 CTO & Senior Partner at CloudSkills.io, a Cloud & DevOps Enablement consulting/training firm, where he 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 subscription. 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
Enjoy unlimited access to all of the courses in our video library. This includes new content every single month, plus live community calls for Q&A and professional networking.
Become part of our online Slack community and engage with your peers, network with like-minded people, and get mentorship from others who are further along in their careers.
Your CloudSkills.io subscription includes access to monthly office hours calls so you can engage with your peers and get your questions answered. Get feedback from Microsoft MVP's and other industry experts.
Join our bi-monthly community livestreams for career coaching and mentoring. Career success requires soft-skills too. Get personalized career advice from peers, mentors, and industry experts that will help you build your communication and leadership skills, along with helping your focus and productivity.