Lab
A Cloud Guru

Deploying an Azure SQL Database

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.

Try for free Contact sales

Path Info

Level

Beginner

Duration

15m

Published

Jun 05, 2020

Challenge

Log in to the Azure Portal

Log in to the Azure Portal using the provided credentials.
Challenge

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.

Author

A Cloud Guru

The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!

What's a lab?

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.