Creating Azure SQL Databases Using PowerShell

30 minutes
  • 3 Learning Objectives

About this Hands-on Lab

In this lab, we walk through using Azure PowerShell to create a SQL Database. This beginner-level hands-on lab covers several concepts, including the following.

* Creating variables to store key parameters.
* Identifying the proper cmdlets to create an Azure SQL Server and Azure SQL Database.
* Creating the Azure SQL Server and Database using the correct parameters.

This hands-on lab uses the Azure Cloud Shell, so there’s no need to install any software. This way it’s possible to follow along at work or home using the web browser.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create the Variables for the SQL Server and Database

Use the instructions below as a guide. Refer to the video for complete steps.

Note: The resource group and subscription have already been created.

  1. Log in to the Azure Portal using the provided credentials.
  2. Navigate to the Cloud Shell, using the >_ icon in the toolbar.
  3. Use PowerShell in the Cloud Shell.
  4. Identify the existing resource group with Get-AzResourceGroup.
  5. Set a variable for the existing resource group name.
  6. Set a variable for the location.
  7. Set a variable for the SQL Server name you will be creating.
Create the Azure SQL Server

Create the Azure SQL Server using New-AzSQLServer with the following parameters.

  • Resource group: Use the variable created in the previous task.
  • Server name: Use the variable created in the previous task.
  • Location: Use the variable created in the previous task.
  • Server version: 12.0
  • SQL administrator credentials: Use Get-Credentials.
Create the SQL Database

Create the Azure SQL Database using New-AzSQLDatabase with the following parameters.

  • Resource group: Use the previously-created variable.
  • Server name: Use the previously-created variable.
  • Database name: Use the previously-created variable.

Additional Resources

Please go ahead and log in to the live Azure hands-on lab environment using the credentials provided.

NOTE: Use West US as the region for any created resources, including the configuration of the Cloud Shell.

The following information will help throughout this hands-on lab:

  • This lab uses the Cloud Shell within the Azure Portal, but Azure PowerShell will work for users who have it installed.

  • Once familiar with the process, consider completing the lab using the steps first. Then use the videos to verify the solution. The videos contain the complete commands.

  • If necessary, expand the objectives to see more information on the tasks this lab undertakes.

  • To view the diagram, access this using the Diagram button on the upper-right-hand side of this hands-on lab.

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.

Sign In
Welcome Back!

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

Get Started
Who’s going to be learning?