- 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.
PowerBI Data Analyst - Create visualizations and dashboards from scratch
Our career paths help you become job ready faster
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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