Providing Technology Training and Mentoring For Modern Technology Adoption
Web Age Aniversary Logo
US Inquiries / 1.877.517.6540
Canadian Inquiries / 1.877.812.8887
Course #:TP2885

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

Three days

Outline of Design Develop and Migrate NoSQL Workloads to Azure Training

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.

 

Module 2: Comparing Database Options in Azure


This module compares the various relational and non-relational data storage options available in Azure. Options are explored as groups such as relational databases (Azure SQL Database, MySQL, and PostgreSQL on Azure), non-relational (Azure Cosmos DB, Storage Tables), streaming (Stream Analytics) and storage (Data Factory, Data Warehouse, Data Lake).

Lab : Deploying Database Instances in Azure

After completing this module, students will be able to:

  • 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

Lessons

  • Understand Migration Benefits
  • Migration Planning
  • Data Migration
  • Application Migration
  • Post-migration considerations


Lab : Migrating Cassandra DB Workloads to Cosmos DB

  • Export the Schema
  • Move Data Using CQLSH COPY
  • Move Data Using Spark
  • 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





We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
US Inquiries / 1.877.517.6540
Canadian Inquiries / 1.877.812.8887