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
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.