Learn on Demand IT Pro Challenges

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.

Start Course
Start course for free
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

94

Enrollees

20

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.

Cybrary For Business

Included in a Path

No items found.
Microsoft Azure Administrator (AZ-104)

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.

courses

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.

4
Share
Start CourseSubscribe for UpdatesNeed to train your team? Learn more
Start Course for FreeNeed to train your team? Learn more
1
H 
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

Coming mid-July
Cybrary Reimagined.
Level up with structured, role-aligned career paths.
ALL NEW!
Cybrary Reimagined.
Celebrate Cybersecurity Awareness Month with our buy 2, get 1 offer!
Level up with structured, role-aligned career paths.
Valid until October 31. Elevate your skills today!
Start Now
This is the default text value
career-paths
career-path

Heading

Heading 1

Heading 2

Heading 3

Heading 4

Heading 5
Heading 6

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Block quote

Ordered list

  1. Item 1
  2. Item 2
  3. Item 3

Unordered list

  • Item A
  • Item B
  • Item C

Text link

Bold text

Emphasis

Superscript

Subscript

Start CourseNeed to train your team? Learn More
Start Path for FreeNeed to train your team? Learn More
This is some text inside of a div block.
Share

Purpose Statement

Cybrary Career Paths are comprehensive training programs designed to prepare you for the most in-demand roles in the cybersecurity workforce. Each path follows a Learn, Practice, Prove model and includes different activity types aligned to key topics within the path’s security domain. As you progress through the path, your progress will be measured in real time using Experience Points (XP) that serve as a comprehensive capability score for each topic. Upon completing all of the requirements for a path, you will be rewarded with a shareable digital badge via Credly.
This is some text inside of a div block.
H 
This is some text inside of a div block.
M
Time
This is some text inside of a div block.
difficulty
This is some text inside of a div block.
ceu/cpe

Overview

Heading 1

Heading 2

Heading 3

Heading 4

Heading 5
Heading 6

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Block quote

Ordered list

  1. Item 1
  2. Item 2
  3. Item 3

Unordered list

  • Item A
  • Item B
  • Item C

Text link

Bold text

Emphasis

Superscript

Subscript

Frequently Asked Questions
No items found.
What Will I Learn?
Foundations
Focused on the core IT competencies that cybersecurity professionals need to succeed in any career path.
Defensive Security
Focused on trying to find the bad guys. Topics such as threat intelligence, threat hunting, network monitoring, incident response. Defensive security is a reactive measure taken once a vulnerability is found through prevention, detection, and response.
Engineering and Operations
Focused on building and operating information systems.
Governance, Risk, and Compliance
Focused on the core IT competencies that cybersecurity professionals need to succeed in any career path.
Leadership and Management
Focused on program design and oversight. Covers project and program management.
Offensive Security
Focused on validating security controls by trying to break them (i.e. penetration testing or ethical hacking). Topics such as Kali Linux, metasploit, scanning, and privilege escalation. Offensive security seeks out the problem or vulnerability through ethical hacking and finds a solution to disable the operation.
Offensive Security
Focused on the core IT competencies that cybersecurity professionals need to succeed in any career path.
Path Outline

Heading 1

Heading 2

Heading 3

Heading 4

Heading 5
Heading 6

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Block quote

Ordered list

  1. Item 1
  2. Item 2
  3. Item 3

Unordered list

  • Item A
  • Item B
  • Item C

Text link

Bold text

Emphasis

Superscript

Subscript

Course Outline

What Our Learners Are Saying

Join 3 million+ users, including 96% of Fortune 1000 companies who use our platform to upskill their teams. See what the buzz is about - start learning for free!

No items found.
This is some text inside of a div block.
threat-actor-campaigns
threat-actor-campaigns