Migrate SQL workloads to Azure
- Offered byMicrosoft
Migrate SQL workloads to Azure at Microsoft Overview
Duration | 3 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Migrate SQL workloads to Azure at Microsoft Course details
- Introduction to data platform modernization
- Assess and convert SQL Server databases using the Data Migration Assistant (DMA)
- Test and optimize SQL Server databases using the Database Experimentation Assistant (DEA)
- Migrate SQL workloads to Azure virtual machines
- Migrate SQL workloads to Azure SQL Databases
- Migrate SQL workloads to Azure Managed Instances
- The objective of this learning path is to educate the learner how they can migrate SQL Server workloads to SQL Services that exist on Azure
- In this course, you'll learn what the purpose of data platform modernization and see the benefits it can bring to your organization
- The Database Experimentation Assistant (DEA) is a standalone application that can compare workloads between the current version of your database, and the target
- Learners will be able to demonstrate the benefits and processes for moving a SQL Server database to an Azure virtual machine
Migrate SQL workloads to Azure at Microsoft Curriculum
Introduction to data platform modernization
Introduction
Understand data platform modernization
Understand the stages of data migration
Explore the available data migration technologies
Exercise: Compare on-premises Azure costs
Summary
Assess and convert SQL Server databases using the Data Migration Assistant (DMA)
Introduction
Decide if the Data Migration Assistant (DMA) is right for your task
Install the DMA
Identify compatibility issues
Upgrade a database
Create Azure SQL virtual machine
Exercise: Install the Data Migration Assistant (DMA)
Exercise: Identify compatibility issues
Exercise: Upgrade a database
Summary
Test and optimize SQL Server databases using the Database Experimentation Assistant (DEA)
Introduction
Decide if DEA is right for your task
Install DEA
Configure a new capture
Review a trace analysis report
Exercise - Install the Database Experimentation Assistant
Exercise - Configure a new capture with DEA
Exercise - Review a trace analysis report in DEA
Summary
Migrate SQL workloads to Azure virtual machines
Introduction
Considerations of SQL Server to Azure virtual machine migrations
SQL workloads to Azure virtual machine migration options
Configure and optimize your applications
Summary
Migrate SQL workloads to Azure SQL Databases
Introduction
Choose the right SQL Server Instance option in Azure
Migrate SQL Server to Azure SQL Database offline
Migrate SQL Server to Azure SQL Database online
Load and move data to Azure SQL Database
Summary
Migrate SQL workloads to Azure Managed Instances
Introduction
Evaluate migration scenarios to SQL Database Managed Instance
Migrate to SQL Database Managed Instance
Load and Move data to SQL Database Managed Instance
Summary
Migrate SQL workloads to Azure at Microsoft Entry Requirements
- Experience with SQL Server databases.Knowledge of SQL Server editions and versions.Basic knowledge of security concepts like identities and permissions.Experience using the Azure portal to create resources and set permissions.
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?