You can go to create a resource à Databases à click the Azure Cosmos DB

The Azure Cosmos DB new account window will be opened and you can enter the following details are required for the screenshots. Then, click the Create button.

• ID
• API 
• Subscription Name
• Resource Group Name
• Location

Now, you can see the notification window displaying the deployment in progress notification. Once it is completed you will get the deployment succeeded notification in the notification window. Then, click Go to resource button.

After successfully Azure Cosmos DB account is created, the Congratulations! Your Azure Cosmos DB account was created window will be opened in the following screenshot.

How to create a new database and collection using Azure

You can learn in this section, how to create a new database and collection in Data Explorer using Azure portal at the following guidelines.

You can go to Data Explorer à click the New Collections

The Add Collection window will be opened and you can enter the following details are required for the screenshots. Then, click the OK button.

• Database Id
• Collection Id
• Storage Capacity 
• Throughput

You can see the new database and collection looks at the following screenshot.

How to add data to the collection using Data Explorer

You can learn in this section, how to add sample data to the collection in Data Explorer using Azure portal at the following guidelines.

You can go to Data Explorer à Expand the Table collection in the Collection window, click the Documents à click the New Document.

The new document window will be opened and add the data to the collection with the following format.

JSON
{
      “Id”: “1”,
      “TableName”: “Table A”,
      “Location”: “Front Row”,
      “Status”: “Available”,
      “Date”: “28-02-2018”
}

Once you have added JSON data to the document and click the Save button.

After successfully added records to the collection looks like the following screenshot

How to use SQL Query to the collection using Data Explorer

You can learn in this section, how to use SQL query to the collection in Data Explorer using Azure portal at the following guidelines.

You can go to Data Explorer à Expand the Table collection in the Collection window, click the New SQL Query

The Query window will be opened as below screenshot

Once you have executed query by clicking Execute Query button

you can use Where condition and Order By for the select statement on SQL Query window in the Azure Cosmos DB as below screenshots

How to get Cosmos DB connection string from Azure

You can learn in this section, how to get the Cosmos DB connection string in Keys using the Azure portal at the following guidelines.

You can go to Settings à click the Keys

Now you can copy the URI and Primary Key into your web.config file in your project.

Reference

• https://docs.microsoft.com/en-us/azure/cosmos-db/