Getting Started with Azure SQL Database

Lab Steps

lock
Logging in to the Microsoft Azure Portal
lock
Creating an Azure SQL DB
lock
Starting an Azure Cloud Shell
lock
Connecting to an Azure SQL DB

The hands-on lab is part of these learning paths

Ready for the real environment experience?

DifficultyBeginner
Time Limit30m
Students420
Ratings
4.7/5
starstarstarstarstar-half

Description

Azure SQL Databases allow cloud engineers and developers to quickly spin up fully managed SQL environments with 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 Azure Cloud Shell
  • 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

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

Environment before
PREVIEW
arrow_forward
Environment after
PREVIEW
About the Author
Students5763
Labs45
Courses1
Learning paths3

Luke is a Site Reliability Engineer at Microsoft. His background is infrastructure development using Terraform and in 2021 he was awarded the HashiCorp Ambassador award. He is an Azure DevOps Engineer Expert, Azure Administrator Associate, and HashiCorp Certified - Terraform Associate.