Design Develop and Migrate NoSQL Workloads to Azure Training

This course provides the knowledge and skills to compare and contrast various database options on Azure, identify data streaming options for large-scale data ingest, and identify longer-term data storage options.

Students will gain the knowledge and skills needed to leverage Azure storage services and features in their development solutions. It covers Azure Table storage, Azure Cosmos DB, Azure Blob, and developing against relational databases in Azure.

The students will learn what is Cosmos DB and how you can migrate MongoDB and Cassandra workloads to Cosmos DB.

Objectives

Determine the ideal pricing option for Azure Storage based on a solution’s requirements.

Identify performance thresholds for the Azure Storage service.

Determine the type of Storage blobs to use for specific solution components.

Use the Azure Files service for SMB operations.

Identify solutions that could benefit from the use of StorSimple physical or virtual devices.

Compare and contrast monitoring services for applications, the Azure platform, and networking.

Design an alert scheme for a solution hosted in Azure.

Select the appropriate backup option for infrastructure and data hosted in Azure.

Automate the deployment of future resources for backup recovery or scaling purposes.

Building Globally Distributed Applications with Cosmos DB

Migrate MongoDB Workloads to Cosmos DB

Migrate Cassandra DB Workloads to Cosmos DB

Audience

The audience for this course is successful Cloud Solutions Architects begin this role with practical experience with operating systems, virtualization, cloud infrastructure, storage structures, billing, and networking. Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam. The audience for this course is data professionals and data architects who want to learn about migrating data platform technologies that exist on Microsoft Azure and how existing NoSQL workloads can be migrated and modernized.

Prerequisites

In addition to their professional experience in SQL Server, students who take this training should have technical knowledge in Azure Fundamentals. Students should have 1-2 years experience as a developer. It is recommended that students have some experience with PowerShell or Azure CLI, working in the Azure portal, and with at least one Azure-supported programming language.The students should know the fundamental concepts of partitioning, replication, and resource governance for building and configuring scalable NoSQL applications that are agnostic of a Cosmos DB API.

Duration

Course AZ-301T02-A: Designing a Data Platform Solution

Module 1: Backing Azure Solutions with Azure Storage

This module describes how many Azure services use the Azure Storage service as a backing store for other application solution in Azure. The module dives into critical considerations when using Azure Storage as a supplemental service for an all-up Azure solution.

After completing this module, students will be able to:

Determine the ideal pricing option for Azure Storage based on a solution’s requirements.

Identify performance thresholds for the Azure Storage service.

Determine the type of Storage blobs to use for specific solution components.

Use the Azure Files service for SMB operations.

Identify solutions that could benefit from the use of StorSimple physical or virtual devices.

Compare and contrast monitoring services for applications, the Azure platform, and networking.

Identify data streaming options for large-scale data ingest.

Identify longer-term data storage options.

Module 3: Monitoring & Automating Azure Solutions

This module covers the monitoring and automation solutions available after an Azure solution has been architected, designed and possibly deployed. The module reviews services that are used to monitor individual applications, the Azure platform, and networked components. This module also covers automation and backup options to enable business-continuity scenarios for solutions hosted in Azure

Lab : Deploying Configuration Management Solutions to Azure

After completing this module, students will be able to:

Compare and contrast monitoring services for applications, the Azure platform, and networking.

Design an alert scheme for a solution hosted in Azure.

Select the appropriate backup option for infrastructure and data hosted in Azure.

Automate the deployment of future resources for backup recovery or scaling purposes.

Course AZ-203T03-A: Develop for Azure storage

Module 1: Develop solutions that use Azure Table storage

Azure Table storage is a service that stores structured NoSQL data in the cloud, providing a key/attribute store with a schemaless design. Because Table storage is schemaless, it's easy to adapt your data as the needs of your application evolve.

Lessons

Azure Table storage overview

Authorization in Table storage

Table service REST API

After completing this module, students will be able to:

Understand the features and uses of Azure Table storage

Know how to utilize Shared Key authorization

Know how to use the Azure Table storage REST service to manage data

Module 2: Develop solutions that use Azure Cosmos DB storage

This module covers Azure Cosmos DB storage. It instructs students on how it works, how to manage containers and items, and create and update documents by using code.

Lessons

Azure Cosmos DB overview

Managing containers and items

Create and update documents by using code

After completing this module, students will be able to:

Understand core features and functionality of Azure Cosmos DB

Be able to manage containers and items

Be able to create and update documents

Module 3: Develop solutions that use a relational database

SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as relational data, JSON, spatial, and XML

Lessons

Azure SQL overview

Create, read, update, and delete database tables by using code

After completing this module, students will be able to:

Know how the Azure SQL Database service works

Be able to perform database operations by using code

Module 4: Develop solutions that use Microsoft Azure Blob storage

Azure Blob storage is Microsoft's object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Unstructured data is data that does not adhere to a particular data model or definition, such as text or binary data.

Lessons

Azure Blob storage overview

Working with Azure Blob storage

After completing this module, students will be able to:

Understand when and why to use Azure Blob storage

Know how to set and retrieve Blob storage properties and metadata

Know how to replicate and copy Blobs

Course DP-060T00-A: Migrate NoSQL workloads to Azure Cosmos DB

Module 1: Building Globally Distributed Applications with Cosmos DB

This module describes the benefits and architecture of Cosmos DB

Lessons

Cosmos DB overview

Cosmos DB APIs

Provisioning Throughput

Partitioning/Sharding Best Practices

Lab : Creating a Cosmos DB Database

Create Cosmos DB Account

Configure RUs

At the end of this module, the students will be able to describe:

Cosmos DB overview

Cosmos DB APIs

Provisioning Throughput

Partitioning/Sharding Best Practices

Module 2: Migrate MongoDB Workloads to Cosmos DB

Migrate MongoDB Workloads to Cosmos DB

Lessons

Understand Migration Benefits

Migration Planning

Data Migration

Application Migration

Post-migration considerations

Lab : Migrating MongoDB Workloads to Cosmos DB

Create a Migration Project

Define Source and Target

Perform Migration

Verify Migration

At the end of this module, the students will be able to:

Understand Migration Benefits

Perform Migration Planning

Perform Data Migration

Perform Application Migration

Undertake Post-migration considerations

Module 3: Migrate Cassandra DB Workloads to Cosmos DB

This module describes the benefits and process of migrating Cassandra DB workloads to Cosmos DB