Working with Azure Cosmos DB: Loading Data

In this course you will examine how data is loaded into Cosmos DB including data migration from a relational database and how to query that data. Begin by using the Cosmos DB web console to load items into a container focusing on the types of data that can be loaded like arrays and nested JSON structures. Then you will query these items using an SQL-like syntax and explore array indexing in-partition and cross-partition queries as well as intra-document joins in order to unpack arrays. Then you will migrate data from a relational Azure SQL Database to Cosmos DB using Azures Data Factory service which allows you to define and launch a pipeline for a migration using an intuitive web UI. Finally you will define a step to copy specific data from a source database and then migrate it over to a Cosmos DB container assembling all the little pieces required for such a pipeline.