Getting Started With Cosmos DB NoSQL Development DP3015 Training - Taiwan, Province of China

Getting Started with Cosmos DB NoSQL Development (DP-3015) Training Course Outline

Module 1: Introduction to Azure Cosmos DB for NoSQL

• Introduction
• What is Azure Cosmos DB for NoSQL
• How does Azure Cosmos DB for NoSQL Work?
• When Should You Use Azure Cosmos DB for NoSQL

Module 2: Try Azure Cosmos DB for NoSQL

• Introduction
• Explore Resources
• Review Basic Operations
• Exercise: Create an Azure Cosmos DB for NoSQL Account

Module 3: Plan Resource Requirements

• Introduction
• Understand Throughput
• Evaluate Throughput Requirements
• Evaluate Data Storage Requirements
• Time-to-live (TTL)
• Plan for Data Retention with Time-to-live (TTL)

Module 4: Configure Azure Cosmos DB for NoSQL Database and Containers

• Introduction
• Serverless
• Compare Serverless vs. Provisioned Throughput
• Autoscale Throughput
• Compare Autoscale vs. Standard (Manual) Throughput
• Migrate Between Standard (Manual) and Autoscale Throughput
• Exercise: Configure Throughput for Azure Cosmos DB SQL API with the Azure Portal

Module 5: Move Data into and out of Azure Cosmos DB for NoSQL

• Introduction
• Move Data by Using Azure Data Factory
• Move Data by Using a Kafka Connector
• Move Data by Using Stream Analytics
• Move Data by Using the Azure Cosmos DB Spark Connector
• Exercise: Migrate Existing Data Using Azure Data Factory

Module 6: Use the Azure Cosmos DB for NoSQL SDK

• Introduction
• Understand the SDK
• Import from Package Manager
• Connect to an Online Account
• Implement Client Singleton
• Configure Connectivity Mode
• Exercise: Connect to Azure Cosmos DB for NoSQL with the SDK

Module 7: Configure the Azure Cosmos DB for NoSQL SDK

• Introduction
• Enable Offline Development
• Handle Connection Errors
• Implement Threading and Parallelism
• Configure Logging
• Exercise: Configure the Azure Cosmos DB for NoSQL SDK for Offline Development

Module 8: Implement Azure Cosmos DB for NoSQL Point Operations

• Introduction
• Understand Point Operations
• Create Documents
• Read a Document
• Update Documents
• Configure Time-to-live (TTL) Value for a Specific Document
• Delete Documents
• Exercise: Create and Update Documents with the Azure Cosmos DB for NoSQL SDK

Module 9: Perform Cross-document Transactional Operations with the Azure Cosmos DB for NoSQL

• Introduction
• Create a Transactional Batch with the SDK
• Review Batch Operation Results with the SDK
• Exercise: Batch Multiple Point Operations Together with the Azure Cosmos DB for NoSQL SDK
• Implement Optimistic Concurrency Control

Module 10: Process Bulk Data in Azure Cosmos DB for NoSQL

• Introduction
• Create Bulk Operations with the SDK
• Review Bulk Operation Caveats
• Implement Bulk Best Practices
• Exercise: Move Multiple Documents in Bulk with the Azure Cosmos DB for NoSQL SDK

Module 11: Query the Azure Cosmos DB for NoSQL

• Introduction
• Understand SQL Query Language
• Create Queries with SQL
• Project Query Results
• Implement Type-checking in Queries
• Use Built-in Functions
• Execute Queries in the SDK
• Exercise: Execute a Query with the Azure Cosmos DB for NoSQL SDK

Module 12: Author Complex Queries with the Azure Cosmos DB for NoSQL

• Introduction
• Create Cross-product Queries
• Implement Correlated Subqueries
• Implement Variables in Queries
• Paginate Query Results
• Exercise: Paginate Cross-product Query Results with the Azure Cosmos DB for NoSQL SDK

Module 13: Define Indexes in Azure Cosmos DB for NoSQL

• Introduction
• Understand Indexes
• Understand Indexing Policies
• Review Indexing Policy Strategies
• Exercise: Review the Default Index Policy for an Azure Cosmos DB for NoSQL Container with the Portal

Module 14: Customise Indexes in Azure Cosmos DB for NoSQL

• Introduction
• Customise the Indexing Policy
• Evaluate Composite Indexes
• Exercise: Configure an Azure Cosmos DB for NoSQL Container's Index Policy with the Portal

Module 15: Consume an Azure Cosmos DB for NoSQL Change Feed Using the SDK

• Introduction
• Understand Change Feed Features in the SDK
• Implement a Delegate for the Change Feed Processor
• Implement the Change Feed Processor
• Implement the Change Feed Estimator
• Exercise: Process Change Feed Events Using the Azure Cosmos DB for NoSQL SDK

Module 16: Handle Events with Azure Functions and Azure Cosmos DB for NoSQL Change Feed

• Introduction
• Understand Azure Function Bindings for Azure Cosmos DB for NoSQL
• Configure Function Bindings
• Develop Function
• Exercise: Process Azure Cosmos DB for NoSQL Data Using Azure Functions

Module 17: Search Azure Cosmos DB for NoSQL Data with Azure Cognitive Search

• Introduction
• Create an Indexer for Data in Azure Cosmos DB for NoSQL
• Implement a Change Detection Policy
• Manage a Data Deletion Detection Policy
• Exercise: Search Data Using Azure Cognitive Search and Azure Cosmos DB for NoSQL

Module 18: Implement a Non-relational Data Model

• Introduction
• What's the Difference Between NoSQL and Relational Databases?
• Identify Access Patterns for Your App
• When to Embed or Reference Data
• Exercise: Measure Performance for Customer Entities
• Choose a Partition Key
• Model Small Lookup Entities

Module 19: Design a Data Partitioning Strategy

• Introduction
• Denormalise Data in Your Model
• Manage Referential Integrity by Using Change Feed
• Combine Multiple Entities in the Same Container
• Denormalise Aggregates in the Same Container
• Finalise the Data Model
• Exercise: Advanced Modelling Patterns

Module 20: Configure Replication and Manage Failovers in Azure Cosmos DB

• Introduction
• Understand Replication
• Distribute Data Across Regions
• Evaluate the Cost of Distributing Data Globally
• Define Automatic Failover Policies
• Perform Manual Failovers
• Configure SDK Region
• Exercise: Connect Different Regions with the Azure Cosmos DB for NoSQL SDK

Module 21: Use Consistency Models in Azure Cosmos DB for NoSQL

• Introduction
• Understand Consistency Models
• Configure Default Consistency Model in the Portal
• Change Consistency Model with the SDK
• Use Session Tokens
• Exercise: Configure Consistency Models in the Portal and the Azure Cosmos DB for NoSQL SDK

Module 22: Configure Multi-region Write in Azure Cosmos DB for NoSQL

• Introduction
• Understand Multi-region Write
• Configure Multi-region Support in the SDK
• Understand Conflict Resolution Policies
• Create Custom Conflict Resolution Policy
• Exercise: Connect Multi-region Write Account with the Azure Cosmos DB for NoSQL SDK

Module 23: Customise an Indexing Policy in Azure Cosmos DB for NoSQL

• Introduction
• Index Usage
• Review Read-heavy Index Patterns
• Review Write-heavy Index Patterns
• Exercise: Optimise an Azure Cosmos DB for NoSQL Container's Index Policy for Common Operations

Module 24: Measure Index Performance in Azure Cosmos DB for NoSQL

• Introduction
• Enable Indexing Metrics
• Analyse Indexing Metrics Results
• Measure Query Cost
• Measure Point Operation Cost
• Exercise: Optimise an Azure Cosmos DB for NoSQL Container's Index Policy for a Specific Query

Module 25: Implement Integrated Cache in Azure Cosmos DB for NoSQL

• Introduction
• Review Workloads that Benefit from the Cache
• Enable Integrated Cache
• Configure Cache Staleness

Module 26: Measure Performance in Azure Cosmos DB for NoSQL

• Introduction
• Understand Azure Monitor
• Measure Throughput
• Observe Rate-limiting Events
• Query Logs
• Exercise: Use Azure Monitor to Analyse an Azure Cosmos DB for NoSQL Account

Module 27: Monitor Responses and Events in Azure Cosmos DB for NoSQL

• Introduction
• Review Common Response Codes
• Understand Transient Errors
• Review Rate-limiting Errors
• Configure Alerts
• Audit Security
• Exercise: Troubleshoot an Application Using the Azure Cosmos DB for NoSQL SDK

Module 28: Implement Backup and Restore for Azure Cosmos DB for NoSQL

• Introduction
• Evaluate Periodic Backup
• Configure Continuous Backup and Recovery
• Perform a Point-in-time Recovery
• Exercise: Recover a Database or Container from a Recovery Point

Module 29: Implement Security in Azure Cosmos DB for NoSQL

• Introduction
• 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
• Exercise: Store Azure Cosmos DB for NoSQL Account Keys in Azure Key Vault

Module 30: Write Management Scripts for Azure Cosmos DB for NoSQL

• Introduction
• Create Resources
• Manage Index Policies
• Configure Database or Container-provisioned Throughput
• Migrate Between Standard and Autoscale Throughput
• Change Region Failover Priority
• Initiate Failovers
• Exercise: Adjust Provisioned Throughput Using an Azure CLI Script

Module 31: Create Resource Template for Azure Cosmos DB for NoSQL

• Introduction
• Understand Azure Resource Manager Resources
• Author Azure Resource Manager Templates
• Configure Database or Container Resources
• Configure Throughput with an Azure Resource Manager Template
• Manage Index Policies Through Azure Resource Manager Templates
• Exercise: Create an Azure Cosmos DB for NoSQL Container Using Azure Resource Manager Templates

Module 32: Build Multi-item Transactions with the Azure Cosmos DB for NoSQL

• Introduction
• Understand Transactions in the Context of JavaScript SDK
• Author Stored Procedures
• Rollback Transactions
• Create Stored Procedures with the JavaScript SDK
• Exercise: Create a Stored Procedure with the Azure Portal

Module 33: Expand Query and Transaction Functionality in Azure Cosmos DB for NoSQL

• Introduction
• Create User-defined Functions
• Create User-defined Functions with the SDK
• Add Triggers to an Operation
• Create and Use Triggers with the SDK
• Exercise: Implement and Use User Defined Functions with the Azure Cosmos DB SDK

Who Should Attend This Getting Started with Cosmos DB NoSQL Development (DP-3015) Training Course?

The Getting Started with Cosmos DB NoSQL Development (DP-3015) Training Course is ideal for individuals eager to expand their skills in managing scalable, globally-distributed databases using Microsoft's Azure platform. This course is particularly beneficial for:

• Database Administrators
• Software Developers
• Data Architects
• IT Professionals
• System Engineers
• Data Analysts
• Cloud Solution Architects
• IT Managers and Directors

Prerequisites of the Getting Started with Cosmos DB NoSQL Development (DP-3015) Training Course

There are no formal prerequisites for attending this Getting Started with Cosmos DB NoSQL Development (DP-3015) Training Course.

Getting Started with Cosmos DB NoSQL Development (DP-3015) Training Course Overview

Cosmos DB NoSQL Development, developed by Microsoft, focuses on scalable, globally distributed database management using Azure Cosmos DB. Its importance stems from its capability to manage extensive data with minimal latency, essential for high-availability applications worldwide. This Microsoft training enhances organisational capabilities in efficient data scaling and maintenance. Individuals gain advanced skills in a cutting-edge, high-demand technology. Career-wise, delegates position themselves for top-tier roles in tech, leveraging expertise in a leading Microsoft technology.

In the Getting Started with Cosmos DB NoSQL Development (DP-3015) course, delegates will gain foundational knowledge and hands-on experience with Cosmos DB, Microsoft's globally distributed, multi-model database service. The curriculum includes setting up Cosmos DB, understanding its data structure options, and learning how to manage data at scale. Participants will also explore features such as automatic failover, multi-region writes, and enterprise-grade security provisions.

Course Objectives:

• To set up and configure Cosmos DB accounts
• To understand NoSQL choices in Cosmos DB
• To manage data replication and partitioning
• To implement security measures in Cosmos DB
• To perform CRUD operations using the Cosmos DB SDK
• To optimise queries for performance and cost
• To integrate Cosmos DB with other Azure services

Upon completion of this course, delegates will be able to effectively set up, configure, and manage Azure Cosmos DB instances. They will have a clear understanding of how to operate Cosmos DB to achieve scalability, performance, and security, tailored to the needs of global applications. Additionally, attendees will know how to utilise the Cosmos DB SDK for application development, preparing them to contribute to projects that require high-performance non-relational databases.

What’s included in this Getting Started with Cosmos DB NoSQL Development DP3015 Training Course?

• World-Class Training Sessions from Experienced Instructors 
• Getting Started with Cosmos DB NoSQL Development DP3015 Training Certificate
• Digital Delegate Pack