Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.
  • Labs icon Lab
  • A Cloud Guru
Azure icon
Labs

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
Azure icon
Labs

Path Info

Level
Clock icon Beginner
Duration
Clock icon 15m
Published
Clock icon Jun 05, 2020

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Table of Contents

  1. Challenge

    Log in to the Azure Portal

    Log in to the Azure Portal using the provided credentials.

  2. 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.

A Cloud Guru - Labs - Deploying an Azure SQL Database
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.

Provided environment for hands-on practice

We will provide the credentials and environment necessary for you to practice right within your browser.

Guided walkthrough

Follow along with the author’s guided walkthrough and build something new in your provided environment!

Did you know?

On average, you retain 75% more of your learning if you get time for practice.

Start learning by doing today

View Plans