Chat with us, powered by LiveChat

DevOps for Databases in Azure

On-Demand / 25 minutes

5.0

Learn how to deploy database changes and updates using DevOps patterns and practices with MySQL, Terraform, and Azure.

Course Instructor: Michael Levan

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
course author

Course Outline


DevOps for Databases

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.

Creating a MySQL Database in Azure with Terraform

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.

Running the Terraform Creation in Azure DevOps

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.

Storing SQL Code in GitHub

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.

Running a SQL Query in Azure DevOps

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.

Testing the SQL Query in Azure DevOps

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.

Buy Now for $27

Already a member? Watch Now

Join the #1 Cloud & DevOps Global Community

Feedback from active members of the CloudSkills Community

Both trainings were a great experience! Mike gathered some big names in the industry to speak on their specialties, I was truly honored to be able to learn from them.
Great training from experienced and knowledgeable trainers. The training material and demos mix the content with real-world scenarios which really accelerated my understanding.
Mike has done a fantastic job of assembling a group of subject matter experts to help guide you from the basics.
If you are serious and really want to go to next level of your career, I highly recommend to be part of CloudSkills.io.

Frequently Asked Questions

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.


"Nothing short of amazing in a few ways"

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
derek