Working with Azure Cosmos DB: Advanced Topics

Azure    |    Intermediate
  • 13 videos | 1h 49m 27s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Begin this course by exploring index policies in Cosmos DB and how these influence the performance of queries, as well as how many request units are consumed by them. Next, you will modify the default index policy and explicitly define the fields of the items which must be included in the index and how fields can be left out of it. Then, you will focus on composite indexes and run various types of queries against your data, including aggregation queries. You will build a Python application that can connect to and query a Cosmos DB container using the azure-cosmos package and various interfaces, such as a DatabaseProxy and ContainerProxy. Finally, you will create a new Cosmos DB account, this time using the MongoDB API, in order to observe the similarities between MongoDB API and MongoDB server.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    View the default container for a cosmos db index policy
    Recall the influence of a container index policy on the request units consumed by queries
    Recognize the need for composite indexes in cosmos db and how these can be defined in the index policy
    Enable various order by queries on a container by defining multiple composite indexes
    Recall the specific syntax and output of aggregation queries on a cosmos db container
    Disable indexes for a container and recognize the effect that has on queries
  • Install the required libraries to build a python app that can interact with a cosmos db instance
    Use the cosmos db client to query for items in a container
    Set up a cosmos db account with the mongodb api and provision a database and collection within that
    Use the cosmos db web console to interact with a database using the mongodb api
    Recognize the similarities when working with cosmos db using the mongodb api and interacting with a mongodb server
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 2m 10s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 11m 34s
    In this video, you will learn how to view the default container for a Cosmos DB index policy. FREE ACCESS
  • Locked
    3.  Exploring the Effects of a Container Index Policy
    12m
    Upon completion of this video, you will be able to recall the influence of a container index policy on the request units consumed by queries. FREE ACCESS
  • Locked
    4.  Building a Composite Index
    9m 32s
    After completing this video, you will be able to recognize the need for composite indexes in Cosmos DB and how these can be defined in the index policy. FREE ACCESS
  • Locked
    5.  Adding Multiple Composite Indexes
    7m 50s
    Find out how to enable various order by queries on a container by defining multiple composite indexes. FREE ACCESS
  • Locked
    6.  Performing Aggregations in Queries
    7m 8s
    Upon completion of this video, you will be able to recall the specific syntax and output of aggregation queries on a Cosmos DB container. FREE ACCESS
  • Locked
    7.  Working Without Indexes
    5m 8s
    During this video, you will learn how to disable indexes for a container and recognize the effect that has on queries. FREE ACCESS
  • Locked
    8.  Connecting to Cosmos DB from a Python App
    11m 1s
    In this video, find out how to install the required libraries to build a Python app that can interact with a Cosmos DB instance. FREE ACCESS
  • Locked
    9.  Querying Cosmos DB from a Python App
    9m 53s
    Discover how to use the Cosmos DB client to query for items in a container. FREE ACCESS
  • Locked
    10.  Creating a Cosmos DB Account with the MongoDB API
    10m 31s
    Learn how to set up a Cosmos DB account with the MongoDB API and provision a database and collection within that. FREE ACCESS
  • Locked
    11.  Querying the Cosmos DB Account as a MongoDB Database
    7m 58s
    In this video, discover how to use the Cosmos DB web console to interact with a database using the MongoDB API. FREE ACCESS
  • Locked
    12.  Querying Cosmos DB Using MongoDB Syntax
    10m 33s
    After completing this video, you will be able to recognize the similarities when working with Cosmos DB using the MongoDB API and interacting with a MongoDB server. FREE ACCESS
  • Locked
    13.  Course Summary
    4m 7s
    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 Microsoft Azure Infrastructure Solutions: Data Solutions
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Course Developing Solutions for Microsoft Azure: Cosmos DB Containers
Rating 4.5 of 22 users Rating 4.5 of 22 users (22)
Course Microsoft Azure Fundamentals: Cloud Computing
Rating 5.0 of 3 users Rating 5.0 of 3 users (3)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Functions in Python: Working with Advanced Features of Python Functions
Rating 4.6 of 301 users Rating 4.6 of 301 users (301)
Course Data Visualization in Python Bootcamp: Session 3 Replay
Rating 4.4 of 26 users Rating 4.4 of 26 users (26)
Course Microsoft Security: Azure AD Authentication, Access, & Identity
Rating 4.2 of 12 users Rating 4.2 of 12 users (12)