Work with NoSQL data in Azure Cosmos DB

In this module, you will:

• Create a NoSQL database with Azure Cosmos DB
• Set the initial throughput volume for your database using request units
• Choose a partition key
• Create a database and container in Azure Cosmos DB

At the end of this module, you will be able to:

• Explain the features of Core (SQL)
• Explain the features of MongoDB
• Explain the features of the Cassandra
• Explain the features of the Azure Table
• Explain the features of the Gremlin (graph)
• Choose the appropriate API for your Azure Cosmos DB account

In this module, you will:

• Create product catalog documents in the Data Explorer
• Perform Azure Cosmos DB queries
• Create and run operations on your documents by using stored procedures

In this module, you will:

• Determine if a graph database fits the data needs of your application
• Store data in a graph database from an application using the Gremlin API
• Query data in a graph database from an application using the Gremlin API

At the end of this module, you will be able to:

• Describe the advantages of Table Storage and Azure Cosmos DB
• Modify an existing Table API application to use Azure Cosmos DB

In this module, you will:

• Create an application to store and query data in Azure Cosmos DB
• Use the Integrated Terminal in Visual Studio Code to quickly create a console application
• Add Azure Cosmos DB functionality with the help of the Azure Cosmos DB extension for Visual Studio Code

In this module, you will:

• Measure the throughput of your Azure Cosmos DB database.
• Identify a partition strategy for your Azure Cosmos DB data.
• Measure the impact of different indexing strategies.

In this module, you will:

• Learn about the benefits of writing and replicating data to multiple regions around the world
• Change the read and write priorities for the regions in which your data is located
• Change the consistency setting for your database

• Introduction
• Exercise - Create an Azure Cosmos DB account in the Azure portal
• What is a request unit?
• Choose a partition key in Azure Cosmos DB
• Exercise - Create a database and container in Azure Cosmos DB using the portal
• Exercise - Create a database and container in Azure Cosmos DB programmatically
• Summary and cleanup

• Introduction
• Identify the technology options
• Analyze the decision criteria
• Use Core (SQL) to store a product catalog
• Use the Gremlin (graph) API as a recommendation engine
• Use MongoDB to import historical order data
• Use Cassandra for web analytics
• Use the Azure Table API to store IoT data
• Knowledge check
• Summary

• Introduction
• Exercise - Set up your Azure Cosmos DB database and container
• Exercise - add data using Data Explorer
• Explore SQL query types
• Exercise - run queries using Data Explorer
• Define stored procedures and user-defined functions
• Exercise - run complex operations on your data
• Summary

• Introduction
• Determine if a graph database fits the data needs of your application
• Build an application that stores graph data using the Gremlin API
• Exercise - Build an application that stores graph data using the Gremlin API
• Query graph data from an application using Gremlin API
• Exercise - Query graph data from an application using Gremlin API
• Knowledge check
• Summary

• Introduction
• Move an app to Azure Cosmos DB table storage
• Exercise - Move an app to Azure Cosmos DB table storage
• Summary

• Introduction
• Exercise - Create Azure Cosmos DB resources in Visual Studio Code
• Exercise - Set up your app in Visual Studio Code
• Exercise - Create, read, update, and delete NoSQL data programmatically
• Exercise - Query using the Azure Cosmos DB .NET SDK
• Exercise - Create and run stored procedures from your app
• Summary

• Introduction
• Measure the rate of data processing in Request Units
• Exercise - Create and populate your Azure Cosmos DB collections
• Exercise - Monitor and measure your Azure Cosmos DB database
• Identify a partition strategy for your Azure Cosmos DB data
• Exercise - Measure the impact of partition key choice
• Identify indexing strategies for your Azure Cosmos DB data
• Exercise - Measure the impact of index policy choice
• Summary

• Introduction
• Exercise - Distribute data globally
• Write to multiple regions
• Exercise - Change global read and write priorities
• Choose a consistency level
• Summary and cleanup