Disclosure: when you buy through links on our site, we may earn an affiliate commission.

DevOps for Databases in Azure

Project-Focused: Deploy database changes and updates using DevOps patterns & practices with MySQL, Terraform, & Azure.
0.0
0.0/5
(0 reviews)
56 students
Created by Mike Pfeiffer

8.9

CourseMarks Score®

10.0

Freshness

N/A

Feedback

7.4

Content

Platform: Udemy
Price: $11.99
Video: 32m
Language: English
Next start: On Demand

Top Microsoft Azure DevOps courses:

Detailed Analysis

CourseMarks Score®

8.9 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

10.0 / 10
This course was last updated on 3/2021.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

We analyzed factors such as the rating (0.0/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

7.4 / 10
Video Score: 7.6 / 10
The course includes 32m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
Detail Score: 9.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 5.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
0 resource.
0 exercise.
0 test.

Table of contents

Description

Learn how to deploy database changes and updates using DevOps patterns and practices with MySQL, Terraform, and Azure in this hands-on project focused course:

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.
•Source control with MySQL queries
•CI/CD and MySQL queries
•DevOps workflow

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.
•Resources to use in Terraform for Azure
•Create a MySQL database
•Create a firewall rule for the MySQL database
•Clean up your environment

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.
•Set up a YAML pipeline
•Use specific Terraform tasks
•Create variables and secrets
•Run the pipeline

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.
•Write a SQL query to create a database, table, and users
•Store the code in GitHub

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.
•Set up a YAML pipeline to run MySQL code
•Use specific MySQL tasks
•Create variables and secrets
•Run the MySQL query via a CI/CD pipeline

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.
•Create a MySQL test using Python
•Create a pipeline for the test
•Run the test in CI/CD

Requirements

• 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.

You will learn

✓ DevOps for Databases
✓ DevOps Workflow
✓ Terraform Basics & Infrastructure as Code

This course is for

• Beginner DevOps engineers working in the Azure cloud.

How much does the DevOps for Databases in Azure course cost? Is it worth it?

The course costs $11.99. And currently there is a 40% discount on the original price of the course, which was $19.99. So you save $8 if you enroll the course now.

Does the DevOps for Databases in Azure course have a money back guarantee or refund policy?

YES, DevOps for Databases in Azure has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the DevOps for Databases in Azure course, but there is a $8 discount from the original price ($19.99). So the current price is just $11.99.

Who is the instructor? Is Mike Pfeiffer a SCAM or a TRUSTED instructor?

Mike Pfeiffer has created 6 courses that got 9 reviews which are generally positive. Mike Pfeiffer has taught 791 students and received a 4.7 average review out of 9 reviews. Depending on the information available, Mike Pfeiffer is a TRUSTED instructor.

More info about the instructor, Mike Pfeiffer

Founder & CEO of CloudSkills.io / Azure MVP / Ex-AWS
Mike Pfeiffer is Founder and CEO of CloudSkills and a twenty-year tech industry veteran who’s worked for some of the largest technology companies in the world including Microsoft and Amazon Web Services (AWS). Mike is a published author, international conference speaker, Microsoft Azure MVP, and host of the CloudSkills FM podcast.

8.9

CourseMarks Score®

10.0

Freshness

N/A

Feedback

7.4

Content

Platform: Udemy
Price: $11.99
Video: 32m
Language: English
Next start: On Demand

Students are also interested in

Get this widget on your website (for course creators):

DevOps for Databases in Azure rating
Copy this code and paste it to your website:
<a href="https://coursemarks.com/course/devops-for-databases-in-azure/" target="_blank" title="DevOps for Databases in Azure on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/89.svg" width="200px" alt="DevOps for Databases in Azure rating"/></a>