In order to view all SKUs that contain Standard_D2s in their name, for example, type:

az vm list-skus -o table --query "[?contains(name,'Standard_D2s')].name"

There are times when you need to know what are all the SKUs available in the Azure portal. In order to achieve that, use:

az vm list-skus