Activity 1: Create an Azure SQL Database

• Steps:
  • To create a new resource group
  • Refer Here for cli reference
  • Create an azure sql server
  • Create an azure sql database with capacity specifications

az group create --name 'activity1' --location 'eastus'

az sql server create --name 'qtactivity1' --resource-group 'activity1' --admin-user 'qtdevops' --admin-password 'india@12345' --enable-public-network true 

az sql db create --name 'qtemployees' --resource-group 'activity1' --server 'qtactivity1' --sample-name 'AdventureWorksLT' --capacity 5 --edition 'Basic'

Exercises 2:

• Create a replication of the database
• Create an elastic pool ans add the existing database to elastic pool
• delete all the databases created by deleting resource group.