COURSE

Provision Relational Databases for a Web App

Course

This IT Pro Challenge lab shows learners how to provision an Azure SQL database and an Azure Database for MySQL, use a data export file, create data structures, and configure a web app to use two different databases. As proof of concept, learners will test their work using a provided web application.

Full access included with 
Insider Pro
 and 
Teams

1

H

M
Time

Intermediate

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

In this IT Pro Challenge, learners will understand how to use the Azure Cloud Shell Command Line Interface (CLI) in Azure Portal to create and configure an Azure SQL database, use a SQL server data export BACPAC file to create an Azure SQL database, define and populate a MySQL database, create data structures, configure connection strings for different databases for a web application, and test their configurations. The skills acquired in this lab are useful for a career as a network or a system administrator.

Overview

The scenario for this lab is that you are a system administrator, and your company is migrating its primary web app that uses both SQL Server and MySQL databases from their datacenter to Azure. To do this, you will provision an Azure SQL database from a data export BACPAC file. Then you will provision an Azure Database for MySQL, use the MySQL Command Line Interface (CLI) to create data structures, and configure the web app to use the new databases.

The Azure portal contains Azure Cloud Shell, a shell environment you can access from a browser. By default, Azure Cloud Shell contains the Command-Line Interfaces (CLI), PowerShell (Windows), and Bash (Linux). The Bash Cloud Shell contains the full MySQL CLI.

NOTE: If you use the Bash Cloud Shell, you must first provision a storage account, and then use the advanced option when launching the Bash Cloud Shell to specify the storage account that you created.

Provision an Azure SQL server and import a SQL Server database

To begin the lab, you will sign in to the Azure portal, create (provision) a SQL server logical server, and use a BACPAC file to create a SQL Server database (CorpData). A BACPAC (.bacpac) file is a Windows file containing schema and database data that allows you to move a database from one server to another. Essentially, the BACPAC file contains exported database data that you can then import to another server.

Provision an Azure Database for MySQL server

Azure Database for MySQL Server is a fully managed relational database service powered by the MySQL community edition.

In this step of the lab, you will provision an Azure Database for MySQL server (mysql12521509) and configure the database security to allow access to Azure Services.

Define and populate a MySQL database

Now you will create a database (customerData) on the MySQL Server that you created in the last step (mysql12521509). Then you will add a table (customer) that has two columns (id, name) and populate the table with at least a few rows of test data.

Configure the web app to use the databases

Your last task is to configure two connection strings (CorpDataConnectionString, CustomerDataConnectionString) for the provided web app. The first connection string is for the CorpData SQL server database, and the second is for the customerData MySQL database.

Test the web application

Finally, you will test your work using a provided test page. You will see sample data from both databases that you created and a success message if you set up the two connection strings properly.

Summary Conclusion

By taking this lab, you will learn how to provision an Azure SQL server, use a BACPAC file to import a SQL Server database, provision an Azure Database for MySQL server, create data structures in a MySQL database, configure a web app to use the databases you created, and verify that a web app can access these databases.

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 Relational Databases for a Web App

This IT Pro Challenge lab shows learners how to provision an Azure SQL database and an Azure Database for MySQL, use a data export file, create data structures, and configure a web app to use two different databases. As proof of concept, learners will test their work using a provided web application.

1
M
Time
Intermediate
difficulty
1
ceu/cpe

Course Content

Course Description

In this IT Pro Challenge, learners will understand how to use the Azure Cloud Shell Command Line Interface (CLI) in Azure Portal to create and configure an Azure SQL database, use a SQL server data export BACPAC file to create an Azure SQL database, define and populate a MySQL database, create data structures, configure connection strings for different databases for a web application, and test their configurations. The skills acquired in this lab are useful for a career as a network or a system administrator.

Overview

The scenario for this lab is that you are a system administrator, and your company is migrating its primary web app that uses both SQL Server and MySQL databases from their datacenter to Azure. To do this, you will provision an Azure SQL database from a data export BACPAC file. Then you will provision an Azure Database for MySQL, use the MySQL Command Line Interface (CLI) to create data structures, and configure the web app to use the new databases.

The Azure portal contains Azure Cloud Shell, a shell environment you can access from a browser. By default, Azure Cloud Shell contains the Command-Line Interfaces (CLI), PowerShell (Windows), and Bash (Linux). The Bash Cloud Shell contains the full MySQL CLI.

NOTE: If you use the Bash Cloud Shell, you must first provision a storage account, and then use the advanced option when launching the Bash Cloud Shell to specify the storage account that you created.

Provision an Azure SQL server and import a SQL Server database

To begin the lab, you will sign in to the Azure portal, create (provision) a SQL server logical server, and use a BACPAC file to create a SQL Server database (CorpData). A BACPAC (.bacpac) file is a Windows file containing schema and database data that allows you to move a database from one server to another. Essentially, the BACPAC file contains exported database data that you can then import to another server.

Provision an Azure Database for MySQL server

Azure Database for MySQL Server is a fully managed relational database service powered by the MySQL community edition.

In this step of the lab, you will provision an Azure Database for MySQL server (mysql12521509) and configure the database security to allow access to Azure Services.

Define and populate a MySQL database

Now you will create a database (customerData) on the MySQL Server that you created in the last step (mysql12521509). Then you will add a table (customer) that has two columns (id, name) and populate the table with at least a few rows of test data.

Configure the web app to use the databases

Your last task is to configure two connection strings (CorpDataConnectionString, CustomerDataConnectionString) for the provided web app. The first connection string is for the CorpData SQL server database, and the second is for the customerData MySQL database.

Test the web application

Finally, you will test your work using a provided test page. You will see sample data from both databases that you created and a success message if you set up the two connection strings properly.

Summary Conclusion

By taking this lab, you will learn how to provision an Azure SQL server, use a BACPAC file to import a SQL Server database, provision an Azure Database for MySQL server, create data structures in a MySQL database, configure a web app to use the databases you created, and verify that a web app can access these databases.

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 Relational Databases for a Web App Certificate of Completion