Skip to content
hands-on lab

Getting Started with Azure SQL Database

Difficulty: Beginner
Duration: Up to 45 minutes
Students: 2,575
Rating: 4.5/5
Start lab
On average, students complete this lab in25m
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.
About
Author

Description

Azure SQL Databases allow cloud engineers and developers to quickly spin up fully managed SQL environments without the hassle of managing the underlying hardware and configuration. SQL Databases are also scalable with massive scaling using the hyperscale feature. Azure also provides AI-powered performance tuning for databases that increase performance the longer the database is used.

In this lab, you will explore the main features of Azure SQL and learn how to deploy and manage the service by connecting to the database and assigning user access.

Learning Objectives

Upon completion of this Lab you will be able to:

  • Create an Azure SQL server and database
  • Connect to an Azure SQL database through Cloud Academy's hosted web terminal
  • Create a new user and assign permissions to a database

Intended Audience

This lab is intended for:

  • Those studying for the DP-300 exam
  • Anyone interested in using Azure SQL

Prerequisites

You should possess:

  • Basic understanding of Azure fundamentals
  • Understanding of SQL and what it is

The following content is sufficient to fulfill these prerequisites:

Updates

March 5th, 2025 - Updated the lab instruction to fix the IP whitelisting issue

December 9th, 2022 - Updated the lab to use Cloud Academy's hosted web terminal

September 19th, 2022 - Updated the instructions and screenshots to reflect the latest UI

June 6th, 2022 - Updated screenshots for accuracy

August 30th, 2021 - Updated the SQL Database creation instructions to match the latest portal experience

Environment before

Environment after

Covered topics

Microsoft Azure
Databases for Azure
Azure SQL Database
SQL for Azure
SQL
Databases
Hands-on Lab UUID

Lab steps

Logging in to the Microsoft Azure Portal
Creating an Azure SQL DB
Logging In to the Azure CLI in the Web Terminal
Connecting to an Azure SQL DB

Lab Rules