Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Architect a data platform in Azure

Microsoft via Microsoft Learn

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
  • Learn the essentials of Azure SQL Database deployment and migration. Explore its benefits, exclusive features, and migration options while optimizing performance and application connections for a smooth transition to the cloud.

    In this module, you'll:

    • Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Database.

    • Migrate databases using Azure Database Migration Service with Azure CLI and tracking database migration activities.

    • Use transactional replication as an online method to migrate to Azure SQL Database.

    • Explore several other methods for migrating SQL Server databases to Azure SQL Database.

  • Learn the core features and functionality of Azure Cosmos DB.

    After completing this module, you'll be able to:

    • Identify the key benefits provided by Azure Cosmos DB

    • Describe the elements in an Azure Cosmos DB account and how they are organized

    • Explain the different consistency levels and choose the correct one for your project

    • Explore the APIs supported in Azure Cosmos DB and choose the appropriate API for your solution

    • Describe how request units impact costs

    • Create Azure Cosmos DB resources by using the Azure portal.

  • Work with Azure Cosmos DB

    After completing this module, you'll be able to:

    • Identify classes and methods used to create resources.

    • Create resources in Azure Cosmos DB for NoSQL using .NET.

    • Write stored procedures, triggers, and user-defined functions by using JavaScript.

Syllabus

  • Migrate SQL Server workloads to Azure SQL Database
    • Introduction
    • Choose the right Azure SQL Database feature
    • Use Azure Database Migration Service to migrate to Azure SQL Database
    • Migrate to Azure SQL Database using BACPAC
    • Use an online method to migrate to Azure SQL Database
    • Move data to Azure SQL Database
    • Exercise - Migrate a SQL Server database to Azure SQL Database
    • Module assessment
    • Summary
  • Explore Azure Cosmos DB
    • Introduction
    • Identify key benefits of Azure Cosmos DB
    • Explore the resource hierarchy
    • Explore consistency levels
    • Choose the right consistency level
    • Explore supported APIs
    • Discover request units
    • Exercise: Create Azure Cosmos DB resources by using the Azure portal
    • Module assessment
    • Summary
  • Work with Azure Cosmos DB
    • Introduction
    • Explore Microsoft .NET SDK v3 for Azure Cosmos DB
    • Exercise - Create resources in Azure Cosmos DB for NoSQL using .NET
    • Create stored procedures
    • Create triggers and user-defined functions
    • Explore change feed in Azure Cosmos DB
    • Module assessment
    • Summary

Reviews

Start your review of Architect a data platform in Azure

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.