Provision Azure SQL Databases

15 minutes
  • 2 Learning Objectives

About this Hands-on Lab

In this hands-on lab scenario, your organization, Awesome Company, is reducing its on-site footprint and moving as many databases as possible to the cloud. Part of this project involves migrating multiple local SQL Server databases to Azure. As Database Administrator, it’s your responsibility to set up the Azure SQL Database resources necessary for this migration. By performing the actions of this lab, you become familiar with creating an Azure SQL Server, creating a single Azure SQL Databases, and creating an Azure SQL Elastic Pool.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create the HR Database and Its Server
  1. Once you’re logged into the Azure portal, click on the three-bar menu create a resource.
  2. Click SQL Database, on this page type:
    • Resource Group: Select pre-existing group in list
    • Database name: HR
    • Server: Create new
    • Server name: acsql-7777
    • Server admin login: Delmar
    • Password and Confirm password: input a password
    • Click OK.
  3. Select Configure database.
  4. Select basic, standard premium.
  5. Standard is selected by default, click Apply.
  6. Click review and create and click create.

    Note: This will take a moment to complete.

  7. Select go to resource to see the HR database.
Create the Development Databases and Their Elastic Pool

We create three development databases (DEV1, DEV2, DEV3) and an elastic pool to allow them to share resources.

Note: When creating these database it may take some time for the dropdowns to have your select. Refresh the page if you encounter this.

  1. Select the three-line menu and select create a resource and click SQL Database.

    • Resource Group: Select pre-existing group in list
    • Database name: DEV1
    • Server: acsql-777
    • Want to use SQL elastic pool? select yes
    • Elastic pool: create new
    • Enter an elastic pool name: Dev Pool and click OK
    • Click Configure elastic pool
    • Select basic, standard premium.
    • Standard is selected by default, click Apply.
  2. Click review and create and click create.

    Note: This will take a moment to complete.

  3. Select the three-line menu and select create a resource and click SQL database.

    • Database name: DEV2
    • Elastic pool: select DEV Pool
  4. Click review and create and click create.

    Note: This will take a moment to complete.

  5. Select the three-line menu and select create a resource and click SQL database.

    • Database name: DEV3
    • Elastic pool: select DEV Pool
  6. Click review and create and click create.

    Note: This will take a moment to complete.

  7. Select the three-line menu and select SQL databases.

  8. Take notice on this page of all the SQL databases that you have provisioned. There should be four databases listed (three DEVs and one HR Database).

Additional Resources

In this hands-on lab scenario your organization, Awesome Company, is reducing its onsite footprint and moving as many databases as possible to the cloud. Part of this project involves migrating multiple local SQL Server databases to Azure. As the Database Admin, it's your responsibility to set up the Azure SQL Database resources necessary for this migration.

To satisfy the requirements of your company, the following will need to be provisioned:

  • A single Azure SQL Database named HR.
  • A server to host the HR database named "acsql-****" (use a unique value). It should use the Standard tier.
  • An elastic pool named Dev Pool to group the variable workloads of your development databases. It should use the Basic tier and be located on the same Azure SQL Server.
  • Three development databases in the elastic pool named DEV1, DEV2, and DEV3.

Note: As you work through the configuration of these resources pay special attention to the purchasing models, service tiers, and key properties available.

Feel free to follow step-by-step instructions in the lab guide, view the solution video, or jump right in on your own. Use the method that is most helpful for you as a learner.

Log in to the Azure portal using the credentials in this lab and the Open Azure Portal button.

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!

Psst…this one if you’ve been moved to ACG!