Getting Started with Azure SQL Database

Lab Steps

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

Ready for the real environment experience?

DifficultyBeginner
Time Limit45m
Students913
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 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
PREVIEW
arrow_forward
Environment after
PREVIEW
About the Author
Students14363
Labs46
Courses1
Learning paths5

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.