Working with Azure Cosmos DB: Loading Data

Azure    |    Intermediate
  • 9 videos | 1h 13m 2s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 5 users Rating 4.6 of 5 users (5)
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 49s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 10m 14s
    In 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
  • Locked
    3.  Querying Items in a Container
    10m 3s
    During this video, you will learn how to execute basic queries on data in a Cosmos DB container. FREE ACCESS
  • Locked
    4.  Querying on Nested Attributes
    3m 35s
    In this video, you will run queries against nested JSON data and arrays and explore intra-document joins. FREE ACCESS
  • Locked
    5.  Setting up an Azure Data Factory Instance
    11m 11s
    Find out how to create an Azure Data Factory instance to set up a migration into Cosmos DB. FREE ACCESS
  • Locked
    6.  Creating an Azure SQL Database
    10m 39s
    In 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
  • Locked
    7.  Loading Data into an Azure SQL Database
    9m 8s
    In 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
  • Locked
    8.  Configuring the Migration to Cosmos DB
    12m 10s
    Discover how to assemble the different components for a migration from Azure SQL Database to Cosmos DB and launch the migration pipeline. FREE ACCESS
  • Locked
    9.  Course Summary
    4m 15s
    In 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

Course Developing Solutions for Microsoft Azure: Cosmos DB Storage
Rating 4.5 of 25 users Rating 4.5 of 25 users (25)
Course Azure Data Fundamentals: Azure Analytics Workloads
Rating 4.8 of 32 users Rating 4.8 of 32 users (32)
Course Developing Solutions for Microsoft Azure: Azure Functions Triggers
Rating 4.6 of 24 users Rating 4.6 of 24 users (24)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Engineering on Microsoft Azure: Data Storage Monitoring
Rating 4.8 of 18 users Rating 4.8 of 18 users (18)
Course Azure Fundamentals: Database Solutions
Rating 4.6 of 119 users Rating 4.6 of 119 users (119)
Course Microsoft Azure Administrator: Management Groups & Resource Groups
Rating 4.7 of 35 users Rating 4.7 of 35 users (35)