SQL Database Hands-on lab

Experience SQL Database which is relational Database-as-a-Service offering from Azure

Architecture

Prerequisites

• Your own laptop

  • (Windows or Mac)

• Azure subscription as:

  • Subscription contributor
  • Resource group onwer

• Azure Data Studio

  • Install Azure Data Studio

• (Optional) Cloud Shell

Agenda

0. Setup Lab Environment

1. Create SQL DB

   Provision a SQL DB from Azure Portal

2. Configure

   See available options for SQL DB Settings

3. Run Queries

   Run sample queries from Visual Studio Code

4. Secure and Protect

   See available options to protect your data

5. Intelligent Performance

   Monitor database performace

6. Business Continuity

   Backup and recovery Database

Query Samples

Referenced from sql-server-samples