hands-on lab

Getting Started with Azure SQL Database

Difficulty: Beginner
Duration: Up to 45 minutes
Students: 1,776
Rating: 4.5/5
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.

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

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

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