Azure CLI Extended

• Azure CLI returns the data in the json format and the output for the json can be queried using JMES Path Refer Here by adding –query section
• Ensure you go through the tutorial
• Lets get list of the resource groups

az group list

• Copy the output the tree viewer
• JMES Path is all about navigating this tree
• Slicing Items
• Lets try to show name and location of the resource group
• Show the name and provisioningState of east us resources

Azure Powershell

• Azure Powershell has inbuilt Where and Select conditions

Activity

• Create an Azure SQL Database with Serverless Provisioning using CLI and Powershell
• Refer Here for the Azure CLI script to create a database in server less
• Lets configure the geo replication for the ‘qtecommerce02’
• Refer Here for the changeset
• Now lets look at how to failover Refer Here
• Clean up the resources => delete the resource group

Exercise:

1. Create an Azure SQL for MySQL DB from azure CLI
2. Create an Azure SQL for Postgres DB from azure powershell