Working with Azure Cosmos DB: Loading Data
Azure
| Intermediate
- 9 videos | 1h 13m 2s
- Includes Assessment
- Earns a Badge
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 Azure's 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.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Use the cosmos db web console to add items to a container and apply different schemas to the items
Execute basic queries on data in a cosmos db container
Run queries against nested json data and arrays and explore intra-document joins
Create an azure data factory instance to set up a migration into cosmos db -
Set up an azure sql relational database to serve as the source for a migration to cosmos db
Use the sql server import extension in azure data studio to load data from a csv file into an azure sql database
Assemble the different components for a migration from azure sql database to cosmos db and launch the migration pipeline
Summarize the key concepts covered in this course
IN THIS COURSE
-
1m 49sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
10m 14sIn this video, find out how to use the Cosmos DB web console to add items to a container and apply different schemas to the items. FREE ACCESS
-
3. Querying Items in a Container10m 3sDuring this video, you will learn how to execute basic queries on data in a Cosmos DB container. FREE ACCESS
-
4. Querying on Nested Attributes3m 35sIn this video, you will run queries against nested JSON data and arrays and explore intra-document joins. FREE ACCESS
-
5. Setting up an Azure Data Factory Instance11m 11sFind out how to create an Azure Data Factory instance to set up a migration into Cosmos DB. FREE ACCESS
-
6. Creating an Azure SQL Database10m 39sIn this video, discover how to set up an Azure SQL relational database to serve as the source for a migration to Cosmos DB. FREE ACCESS
-
7. Loading Data into an Azure SQL Database9m 8sIn this video, find out how to use the SQL Server Import extension in Azure Data Studio to load data from a CSV file into an Azure SQL database. FREE ACCESS
-
8. Configuring the Migration to Cosmos DB12m 10sDiscover how to assemble the different components for a migration from Azure SQL Database to Cosmos DB and launch the migration pipeline. FREE ACCESS
-
9. Course Summary4m 15sIn this video, we will summarize the key concepts covered in this course. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE
Rating 4.7 of 35 users
(35)
