COURSE

Provision An Azure Database for MySQL Database

Course

In this IT Pro Challenge virtual lab, you will get hands-on experience using Microsoft Azure to provision, configure, and use an Azure database for MySQL server. This lesson simulates a cloud migration strategy that you might implement for moving web apps to the cloud. These skills are essential for an Azure administrator, architect, or engineer.

Full access included with 
Insider Pro
 and 
Teams

H

45

M
Time

Beginner

i
Designed for learners who have no prior work experience in IT or Cybersecurity, but are interested in starting a career in this exciting field.
Designed for learners with prior cybersecurity work experience who are interested in advancing their career or expanding their skillset.
Designed for learners with a solid grasp of foundational IT and cybersecurity concepts who are interested in pursuing an entry-level security role.
Experience Level

Enrollees

XP

1

i

Earn qualifying credits for certification renewal with completion certificates provided for submission.
CEU's

Learners at 96% of Fortune 1000 companies trust Cybrary

About this course

Read More

Skills you'll gain

Course Outline

No items found.
No items found.
No items found.
No items found.
Course Description

Lab Overview:

This hands-on lab provides an Azure administrator with an understanding of how to implement Microsoft Azure’s database for MySQL server. You will gain the exposure required to understand how an on-premise web app with MySQL database dependencies can be migrated to a serverless application cloud environment. As part of this lesson, you’ll also learn how to use the Azure Cloud Shell to manage your MySQL database. These skills are essential for someone pursuing a career path as an Azure administrator, architect, or engineer.

Understand the scenario

You are a system administrator for a company that is migrating its primary web app from their on-premise data center to Microsoft’s Azure cloud. You need to configure a MySQL database in Azure that will be used by a serverless web application. First, you will create an Azure Database for MySQL server, and then you will define the database and populate it with sample data. Finally, you will test the database using a test page provided within the web app.

Create an Azure Database for MySQL server:

Microsoft’s Azure Database for MySQL is a relational database service that uses the MySQL Community Edition database engine. Since it is a fully managed service, you don’t have to worry about infrastructure, maintenance, updates, backups, or infrastructure security. This capability drastically reduces the overhead associated with managing databases. In this section, you will provision a MySQL database, assign credentials, and enable the Azure services to access the database.

Provision a storage account and open a Cloud Shell session:

Azure Cloud Shell is an interactive, authenticated, browser-accessible shell for managing Azure resources. It is accessed directly through the Azure Portal. You can choose between Bash or PowerShell, based on your shell experience and preference. A Cloud Shell requires access to a Storage Account to operate. You will provision a storage account, then configure a file share for Cloud Shell on your storage account, and then launch a Bash Cloud Shell using those resources.

Create and populate a MySQL database:

For this task, you will use common MySQL commands to create and populate a dummy database. You will become familiar with the MySQL commands: CREATE DATABASE, USE, CREATE TABLE, and INSERT INTO. You are provided hints along the way, so don’t worry if your MySQL skills are less than polished.

Test the connection to the database from the web application:

To enable your web application to connect to the database, you need to provide a specifically formatted connection string. You will become familiar with locating this information within the Azure portal, then using that information to test your web app’s access to the database. For this lesson, you are provided a web application with a test page that will confirm the configuration is correct.

Lab Summary Conclusion:

In this hands-on virtual lab, you will learn how to provision, configure, and populate an Azure database for MySQL server. Once the database is set up, you will test accessibility by a web application. This lesson is meant to simulate a migration of your web application from an on-premise data center to Microsoft’s Azure cloud platform. These are essential skills for someone pursuing a career path as an Azure administrator, architect, or engineer.

Other Challenges in this series

  • Guided Challenge - Configuring Blob Storage with Public Access
  • Advanced Challenge - Can you Provision Relational Databases for a Web App?

Train Your Team

Cybrary’s expert-led cybersecurity courses help your team remediate skill gaps and get up-to-date on certifications. Utilize Cybrary to stay ahead of emerging threats and provide team members with clarity on how to learn, grow, and advance their careers within your organization.

Included in a Path

No items found.

Instructors

No items found.
Learn

Learn core concepts and get hands-on with key skills.

Practice

Exercise your problem-solving and creative thinking skills with security-centric puzzles

Prove

Assess your knowledge and skills to identify areas for improvement and measure your growth

Get Hands-on Learning

Put your skills to the test in virtual labs, challenges, and simulated environments.

Measure Your Progress

Track your skills development from lesson to lesson using the Cybrary Skills Tracker.

Connect with the Community

Connect with peers and mentors through our supportive community of cybersecurity professionals.

Success from Our Learners

"Cybrary really helped me get up to speed and acquire a baseline level of technical knowledge. It offers a far more comprehensive approach than just learning from a book. It actually shows you how to apply cybersecurity processes in a hands-on way"

Don Gates

Principal Systems Engineer/SAIC

"Cybrary’s SOC Analyst career path was the difference maker, and was instrumental in me landing my new job. I was able to show the employer that I had the right knowledge and the hands-on skills to execute the role."

Cory

Cybersecurity analyst/

"I was able to earn my CISSP certification within 60 days of signing up for Cybrary Insider Pro and got hired as a Security Analyst conducting security assessments and penetration testing within 120 days. This certainly wouldn’t have been possible without the support of the Cybrary mentor community."

Mike

Security Engineer and Pentester/

"Cybrary really helped me get up to speed and acquire a baseline level of technical knowledge. It offers a far more comprehensive approach than just learning from a book. It actually shows you how to apply cybersecurity processes in a hands-on way"

Don Gates

Principal Systems Engineer/SAIC

"Cybrary’s SOC Analyst career path was the difference maker, and was instrumental in me landing my new job. I was able to show the employer that I had the right knowledge and the hands-on skills to execute the role."

Cory

Cybersecurity analyst/

"I was able to earn my CISSP certification within 60 days of signing up for Cybrary Insider Pro and got hired as a Security Analyst conducting security assessments and penetration testing within 120 days. This certainly wouldn’t have been possible without the support of the Cybrary mentor community."

Mike

Security Engineer and Pentester/

"Becoming a Cybrary Insider Pro was a total game changer. Cybrary was instrumental in helping me break into cybersecurity, despite having no prior IT experience or security-related degree. Their career paths gave me clear direction, the instructors had real-world experience, and the virtual labs let me gain hands-on skills I could confidently put on my resume and speak to in interviews."

Cassandra

Information Security Analyst/Cisco Systems

"I was able to earn both my Security+ and CySA+ in two months. I give all the credit to Cybrary. I’m also proud to announce I recently accepted a job as a Cyber Systems Engineer at BDO... I always try to debunk the idea that you can't get a job without experience or a degree."

Casey

Cyber Systems Engineer/BDO

"Cybrary has helped me improve my hands-on skills and pass my toughest certification exams, enabling me to achieve 13 advanced certifications and successfully launch my own business. I love the practice tests for certification exams, especially, and appreciate the wide-ranging training options that let me find the best fit for my goals"

Angel

Founder,/ IntellChromatics.

Provision An Azure Database for MySQL Database

In this IT Pro Challenge virtual lab, you will get hands-on experience using Microsoft Azure to provision, configure, and use an Azure database for MySQL server. This lesson simulates a cloud migration strategy that you might implement for moving web apps to the cloud. These skills are essential for an Azure administrator, architect, or engineer.

45
M
Time
Beginner
difficulty
1
ceu/cpe

Course Content

Course Description

Lab Overview:

This hands-on lab provides an Azure administrator with an understanding of how to implement Microsoft Azure’s database for MySQL server. You will gain the exposure required to understand how an on-premise web app with MySQL database dependencies can be migrated to a serverless application cloud environment. As part of this lesson, you’ll also learn how to use the Azure Cloud Shell to manage your MySQL database. These skills are essential for someone pursuing a career path as an Azure administrator, architect, or engineer.

Understand the scenario

You are a system administrator for a company that is migrating its primary web app from their on-premise data center to Microsoft’s Azure cloud. You need to configure a MySQL database in Azure that will be used by a serverless web application. First, you will create an Azure Database for MySQL server, and then you will define the database and populate it with sample data. Finally, you will test the database using a test page provided within the web app.

Create an Azure Database for MySQL server:

Microsoft’s Azure Database for MySQL is a relational database service that uses the MySQL Community Edition database engine. Since it is a fully managed service, you don’t have to worry about infrastructure, maintenance, updates, backups, or infrastructure security. This capability drastically reduces the overhead associated with managing databases. In this section, you will provision a MySQL database, assign credentials, and enable the Azure services to access the database.

Provision a storage account and open a Cloud Shell session:

Azure Cloud Shell is an interactive, authenticated, browser-accessible shell for managing Azure resources. It is accessed directly through the Azure Portal. You can choose between Bash or PowerShell, based on your shell experience and preference. A Cloud Shell requires access to a Storage Account to operate. You will provision a storage account, then configure a file share for Cloud Shell on your storage account, and then launch a Bash Cloud Shell using those resources.

Create and populate a MySQL database:

For this task, you will use common MySQL commands to create and populate a dummy database. You will become familiar with the MySQL commands: CREATE DATABASE, USE, CREATE TABLE, and INSERT INTO. You are provided hints along the way, so don’t worry if your MySQL skills are less than polished.

Test the connection to the database from the web application:

To enable your web application to connect to the database, you need to provide a specifically formatted connection string. You will become familiar with locating this information within the Azure portal, then using that information to test your web app’s access to the database. For this lesson, you are provided a web application with a test page that will confirm the configuration is correct.

Lab Summary Conclusion:

In this hands-on virtual lab, you will learn how to provision, configure, and populate an Azure database for MySQL server. Once the database is set up, you will test accessibility by a web application. This lesson is meant to simulate a migration of your web application from an on-premise data center to Microsoft’s Azure cloud platform. These are essential skills for someone pursuing a career path as an Azure administrator, architect, or engineer.

Other Challenges in this series

  • Guided Challenge - Configuring Blob Storage with Public Access
  • Advanced Challenge - Can you Provision Relational Databases for a Web App?
This course is part of a Career Path:
No items found.

Instructed by

Provider
Cybrary Logo
Certification Body
Certificate of Completion

Complete this entire course to earn a Provision An Azure Database for MySQL Database Certificate of Completion