Deploying an Azure SQL Database

Get Started
15 minutes
  • 2 Learning Objectives

About this Hands-on Lab

One great advantage of the cloud is the ability to utilize Platform as a Service (PaaS) offerings to offload server and database administration, freeing you to focus on what drives success for your business. Azure SQL Database is one such offering. In this scenario, you are the DBA for Awesome Company. You have been tasked with delivering a database backend for a new cloud-native app. This solution should both integrate closely with Azure services and require as little hands-on maintenance as possible, allowing your team to focus on other tasks. Performing the actions of this lab will help you become familiar with how to provision an Azure SQL database.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Log in to the Azure Portal

Log in to the Azure Portal using the provided credentials.

Create an Azure SQL Database
  1. In the search box at the top of the page, search for "Azure SQL", and click on Azure SQL under Services.
  2. Click Create Azure SQL resource.
  3. Under SQL databases, leave Single database as the selection and click Create.
  4. Select the resource group the lab created for you.
  5. Provide a database name.
  6. Under Server, click Create new.
  7. Provide a server name (which must be globally unique), server admin login, and password.
  8. Set the location as (US) West US.
  9. Click OK.
  10. Under Compute + storage, click Configure database.
  11. At the top left, click Looking for basic, standard, premium?.
  12. Select Basic and click Apply.
  13. Click Review + create.
  14. Verify all is well and click Create.
  15. Once the deployment is complete, click Go to resource.

Congratulations! You now have a fully operational SQL Database that is tightly integrated with other Azure services, has its infrastructure fully managed by Microsoft, and has a number of advanced features built right in.

Additional Resources

You are the DBA for Awesome Company. You have been tasked with delivering a database backend for a new cloud-native app. This solution should both integrate closely with Azure services and require as little hands-on maintenance as possible, allowing your team to focus on other tasks.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Get Started
Who’s going to be learning?

How many seats do you need?

  • $499 USD per seat per year
  • Billed Annually
  • Renews in 12 months

Ready to accelerate learning?

For over 25 licenses, a member of our sales team will walk you through a custom tailored solution for your business.


$2,495.00

Checkout
Sign In
Welcome Back!
Thanks for reaching out!

You’ll hear from us shortly. In the meantime, why not check out what our customers have to say about ACG?