Trending Courses

Vendors

Skip Navigation Links

Overview

This course teaches developers how to create application using the SQL API and SDK for Azure Cosmos DB. Students will learn how to write efficient queries, create indexing policies, manage and provisioned resources, and perform common operations with the SDK.
img-course-overview.jpg

What You'll Learn

  • Evaluate whether Azure Cosmos DB for NoSQL is the right database for your application.
  • Describe how the features of the Azure Cosmos DB for NoSQL are appropriate for modern applications.
  • Create a new Azure Cosmos DB for NoSQL account
  • Create database, container, and item resources for an Azure Cosmos DB for NoSQL account
  • Evaluate various requirements of your application
  • Compare the various service and throughput offerings for Azure Cosmos DB
  • Migrate between standard and autoscale throughput
  • Migrate data using Azure services
  • Migrate data using Spark or Kafka
  • Integrate the Microsoft.Azure.Cosmos SDK library from NuGet
  • Connect to an Azure Cosmos DB for NoSQL account using the SDK and .NET
  • Configure the SDK for offline development
  • Troubleshoot common connection errors
  • Implement parallelism in the SDK
  • Configure logging using the SDK
  • Perform CRUD operations using the SDK
  • Configure TTL for a specific item
  • Create a transactional batch and review results
  • Implement optimistic concurrency control for an operation
  • Use C# task asynchronous programming model and "bulk" support in the Azure Cosmos DB for NoSQL .NET SDK
  • Create and execute a SQL query
  • Project query results
  • Use built-in functions in a query
  • Implement a correlated subquery
  • Create a cross-product query
  • Create and execute a SQL query
  • Project query results
  • Use built-in functions in a query
  • Implement a correlated subquery
  • Create a cross-product query
  • Create a change feed processor in the .NET SDK
  • Author a delegate to handle a batch of changes in a client-side application
  • Create an Azure Function using the Azure Cosmos DB trigger
  • Create an indexer to migrate data from Azure Cosmos DB for NoSQL to an Azure Cognitive Search index
  • Determine access patterns for data.
  • Apply data model and partitioning strategies to support an efficient and scalable NoSQL database.
  • Manage relationships between data entities by using advanced modeling and partitioning strategies.
  • Maintain the referential integrity of your data by using change feed.
  • Implement pre-aggregating and denormalizing data strategies to improve data-model performance and scaling.
  • Optimizing storage and compute by mixing entity types in a single container
  • Distribute data across global data centers
  • Configure automatic failover and perform a manual failover
  • Configure the Azure Cosmos DB for NoSQL .NET SDK to use a specific region
  • Configure default consistency level for an Azure Cosmos DB account
  • Change the consistency level on a per-request basis
  • Configure Azure Cosmos DB for multi-region write
  • Use the .NET SDK to select a write region for operations.
  • Customize an indexing policy for read-heavy workloads
  • Customize an indexing policy for write-heavy workloads
  • Tune an indexing policy for specific queries
  • Measure the cost for a query or operation
  • Implement the integrated cache
  • Configure integrated cache options
  • Understand how Azure Cosmos DB uses Azure Monitor to monitor server-side metrics.
  • Measure Cosmos DB's throughput
  • Observe rate-limiting events.
  • Query telemetry logs
  • Measure cross-partition storage distribution throughput
  • Review common response codes
  • Understand transit errors
  • Review rate-limiting errors
  • Configure Alerts
  • Audit Security
  • Understand the different backup and restore options Azure Cosmos DB provides.
  • Evaluate periodic backups.
  • Configure continuous backups.
  • Do point in time recovery.
  • Implement network level access control
  • Review data encryption options
  • Use role-based access control (RBAC)
  • Access Account Resources using Microsoft Entra ID
  • Understand Always Encrypted
  • View arguments, groups, and subgroups for a specific CLI command
  • Create Azure Cosmos DB accounts, databases, and containers using the CLI
  • Manage an indexing policy using the CLI
  • Configure database or container throughput using the CLI
  • Initiate failovers and manage failover regions using the CLI
  • Identify the three most common resource types for Azure Cosmos DB for NoSQL accounts
  • Create and deploy a JSON Azure Resource Manager template for an Azure Cosmos DB for NoSQL account, database, or container
  • Create and deploy a Bicep template for an Azure Cosmos DB for NoSQL account, database, or container
  • Manage throughput and index policies using JSON or Bicep templates
  • Author stored procedure
  • Rollback stored procedure transactions
  • Create user-defined functions
  • Create triggers

Who Should Attend

Software engineers tasked with authoring cloud-native solutions that leverage Azure Cosmos DB SQL API and its various SDKs. They are familiar with C#, Python, Java, or JavaScript. They also have experience writing code that interacts with a SQL or NoSQL database platform.
img-who-should-learn.png

Prerequisites

Please review the prerequisites listed for each module in the course content and click on the provided links for more information.

Learning Journey

Want to boost your career in Microsoft? Click on the roles below to see the learning pathways, specially designed to give you the skills to succeed.

1. Introduction to Azure Cosmos DB for NoSQL

Learn about the Azure Cosmos DB for NoSQL and determine if it is a good fit for your application.

Click here to know more

2. Try Azure Cosmos DB for NoSQL

Learn how to use the Azure Cosmos DB for NoSQL to create an account, and then use the account to create Cosmos DB resources.

Click here to know more

3. Plan Resource Requirements

Familiarize yourself with the various configuration options for a new Azure Cosmos DB for NoSQL account.

Click here to know more

4. Configure Azure Cosmos DB for NoSQL database and containers

Select between the various throughput offerings in Azure Cosmos DB for NoSQL.

Click here to know more

5. Move data into and out of Azure Cosmos DB for NoSQL

Migrate data into and out of Azure Cosmos DB for NoSQL using Azure services and open-source solutions.

Click here to know more

6. Use the Azure Cosmos DB for NoSQL SDK

Learn about the Microsoft.Azure.Cosmos library, and then download the library to use in a .NET application.

Click here to know more

7. Configure the Azure Cosmos DB for NoSQL SDK

Learn how to configure the Azure Cosmos DB for NoSQL SDK in various ways including how to integrate with the emulator, implement parallelism, and create a custom logger.

Click here to know more

8. Implement Azure Cosmos DB for NoSQL point operations

Write code to create, read, update, and delete items in Azure Cosmos DB for NoSQL.

Click here to know more

9. Perform cross-document transactional operations with the Azure Cosmos DB for NoSQL

Perform operations on multiple items in single logical units of work.

Click here to know more

10. Process bulk data in Azure Cosmos DB for NoSQL

Perform bulk operations on Azure Cosmos DB in bulk from code using the SDK.

Click here to know more

11. Query the Azure Cosmos DB for NoSQL

Author queries for Azure Cosmos DB for NoSQL using the SQL query language.

Click here to know more

12. Author complex queries with the Azure Cosmos DB for NoSQL

Create SQL queries for Azure Cosmos DB for NoSQL that uses subqueries or cross-products.

Click here to know more

13. Define indexes in Azure Cosmos DB for NoSQL

Discover indexes and indexing policies in Azure Cosmos DB for NoSQL.

Click here to know more

14. Customize indexes in Azure Cosmos DB for NoSQL

Customize indexing policies for a container in Azure Cosmos DB for NoSQL.

Click here to know more

15. Consume an Azure Cosmos DB for NoSQL change feed using the SDK

Process change feed events using the change feed processor in the Azure Cosmos DB for NoSQL .NET SDK.

Click here to know more

16. Handle events with Azure Functions and Azure Cosmos DB for NoSQL change feed

Use Azure Functions bindings to integrate a function with Azure Cosmos DB for NoSQL.

Click here to know more

17. Search Azure Cosmos DB for NoSQL data with Azure Cognitive Search

Index Azure Cosmos DB for NoSQL data with Azure Cognitive Search.

Click here to know more

18. Implement a non-relational data model

Identify an application’s key access patterns. Define the entities’ data model, along with containers to store the data with a partition key that will result in an efficient and scalable data store for the application.

Click here to know more

19. Design a data partitioning strategy

Identify strategies for managing relationships between data entities, such as customers and sales data. Improve data-model performance and scaling by pre-aggregating and denormalizing your data. Use change-feed to maintain your data's referential integrity.

Click here to know more

20. Configure replication and manage failovers in Azure Cosmos DB

Replicate data across the globe and manage automatic or manual failovers in Azure Cosmos DB.

Click here to know more

21. Use consistency models in Azure Cosmos DB for NoSQL

Configure consistency on a sliding scale for Azure Cosmos DB for NoSQL.

Click here to know more

22. Configure multi-region write in Azure Cosmos DB for NoSQL

Write data to multiple regions using Azure Cosmos DB for NoSQL.

Click here to know more

23. Customize an indexing policy in Azure Cosmos DB for NoSQL

Tune the indexing policy based on your SQL queries in Azure Cosmos DB for NoSQL.

Click here to know more

24. Measure index performance in Azure Cosmos DB for NoSQL

Measure the performance of an indexing policy in Azure Cosmos DB for NoSQL.

Click here to know more

25. Implement integrated cache in Azure Cosmos DB for NoSQL

Implement, configure, and monitor integrated cache in Azure Cosmos DB for NoSQL.

Click here to know more

26. Measure performance in Azure Cosmos DB for NoSQL

We learn to use Azure Monitor to create and analyze monitoring data for Azure Cosmos DB.

Click here to know more

27. Monitor responses and events in Azure Cosmos DB for NoSQL

We will learn to use a rich set of REST response codes returned by Azure Cosmos DB request to help you analyze potential issues.

Click here to know more

28. Implement backup and restore for Azure Cosmos DB for NoSQL

We'll learn to use the two backup models Azure Cosmos DB provides.

Click here to know more

29. Implement security in Azure Cosmos DB for NoSQL

We will learn the different security models that Azure Cosmos DB uses.

Click here to know more

30. Write management scripts for Azure Cosmos DB for NoSQL

Learn how to manage Azure Cosmos DB for NoSQL accounts, databases, and containers using the Azure CLI.

Click here to know more

31. Create resource template for Azure Cosmos DB for NoSQL

Learn about automated Azure Cosmos DB for NoSQL resource deployments using the Azure Resource Manager with JSON and Bicep templates.

Click here to know more

32. Build multi-item transactions with the Azure Cosmos DB for NoSQL

Author stored procedures using JavaScript in Azure Cosmos DB for NoSQL.

Click here to know more

33. Expand query and transaction functionality in Azure Cosmos DB for NoSQL

Author user-defined functions and triggers using JavaScript in Azure Cosmos DB for NoSQL.

Click here to know more

Skills Measured

  • Design and implement data models
  • Design and implement data distribution
  • Integrate an Azure Cosmos DB solution
  • Optimize an Azure Cosmos DB solution
  • Maintain an Azure Cosmos DB solution

Frequently Asked Questions (FAQs)

  • Why get Microsoft certified?

    Microsoft certifications validate your skills and expertise in Microsoft technologies and solutions, demonstrating your ability to design, implement, and manage cutting-edge technologies.

    These certifications are globally recognized and highly sought after by employers, as they signify your proficiency in using Microsoft products and services to drive innovation and solve business challenges.

    Microsoft-certified professionals are in high demand, opening doors to new career opportunities and higher earning potential.

  • What to expect for the examination?

    Microsoft certification exams are designed to assess your knowledge and skills in specific Microsoft technologies and solutions.

    Exams typically consist of multiple-choice, multiple-select, and case study questions, and some may include lab simulations to evaluate your practical skills.

    Note: Certification requirements and policies may be updated by Microsoft from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • How long is Microsoft certification valid for?

    Most Microsoft role-based and specialty certifications are valid for one year from the date of passing the exam.

    To maintain your certification, you will need to renew it annually by passing a free online assessment on Microsoft Learn.

    However, Microsoft Applied Skills credentials and Fundamentals certifications do not expire.

    Note: Certification requirements and policies may be updated by Microsoft from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • Why take this course with Trainocate?

    Here’s what sets us apart:

    - Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).

    - Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.

    - Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.

    - Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.

    - Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.

    - Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Course Curriculum

Training Schedule

Training Schedule

Exam & Certification

Exam & Certification

FAQs

Frequently Asked Questions

img-improve-career.jpg

Improve yourself and your career by taking this course.

More Courses By Microsoft

Browse All Courses
ms-900t01-microsoft-365-fundamentals-training
Microsoft 365 (M365)

Microsoft 365 Fundamentals

Learn the foundational knowledge on adopting cloud services and the SaaS model, with a specific focus on Microsoft 365.
ILT VILT
Course Duration 1 Day
mb-230t01-microsoft-dynamics-365-customer-service-training
Microsoft Dynamics 365

Microsoft Dynamics 365 Customer Service

Learn how to use Microsoft Dynamics 365 to impact your customers.
ILT VILT
Course Duration 4 Days
mb-210t01-microsoft-dynamics-365-sales-training
Microsoft Dynamics 365

Microsoft Dynamics 365 Sales

Learn to manage customer, organizations, automate and best practices in this 1-day Microsoft Dynamics 365 Sales course.
ILT VILT
Course Duration 2 Days
img-get-info.jpg

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name
Email
Phone
I'm inquiring for

Inquiry Details

By providing your contact details, you agree to our Privacy Policy.

Stay Connected. Be the first to Know.

Company

Vendors

Services

Customer Service

© Copyright Trainocate 2024. All rights reserved.