Migrate SQL workloads to Azure

Session Detail:    Classroom, Virtual 2 Day

In this course, the students will explore the 7 R objectives of data platform modernization. They will learn the reasons why they should choose each objective and why each objective is most suitable for a variety of different business requirements. Students will also explore each phase of the data platform modernization process and define what tasks are involved at each stage.

The student will explore the assessment, planning, and migration tools available. The student will learn the capabilities of these tools and how they are suitable for each phase of the data migration process. They will also learn how, and when, to implement a range of the tools.

The student will explore three target platforms for SQL based workloads; Azure Virtual Machines, Azure SQL Databases and Azure SQL Managed Instances. The student will learn the benefits and limitations of each target for SQL based workloads and fulfill the business requirements for modern SQL based workloads.

The student will implement a variety of tools to migrate SQL data to the target platform. The student will discover the suitability of the existing SQL based application for migration, assess what changes need to be made, plan how to implement the changes, and migrate the SQL data to the target platform. The student will explore the changes that may need to be made to existing SQL based applications so that they can make the best use of modern data platforms in Azure.

Prerequisites

In addition to their professional experience in SQL Server, students who take this training should have technical knowledge equivalent to the following courses:

  • Azure fundamentals

Who Can Benefit

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 SQL based workloads can be migrated and modernized. The secondary audience for this course is individuals who manage data platforms or develop applications that deliver content from the existing data platform technologies.

Session Outline

Class Outline

Module 1: Introducing Data Platform Modernization

  • Lesson 1: Understand Data Platform Modernization
  • Lesson 2: Understanding the stages of migration
  • Lesson 3: Data Migration Paths

After completing this module, students will be able to:

  • Understand Data Platform Modernization
  • Understand the Stages of Migration
  • Data Migration Paths

Module 2: Choose the right tools for Data Migration

  • Lesson 1: Discover the Database Migration Guide
  • Lesson 2: Build your data estate inventory using Map Toolkit
  • Lesson 3: Identify Migration candidates using Data Migration Assistant
  • Lesson 4: Evaluate a Data workload using Database Experimentation Assistant
  • Lesson 5: Data Migration using Azure Database Migration Service
  • Lesson 6: Migrate non-SQL Server workloads to Azure using SQL Migration Assistant

After completing this module, students will be able to:

  • Identify Migration candidates using Data Migration Assistant
  • Evaluate a Data workload using Database Experimentation Assistant

Module 3: Migrating SQL Workloads to Azure Virtual Machines

  • Lesson 1: Considerations of SQL Server to Azure VM Migrations
  • Lesson 2: SQL Workloads to Azure VM Migration Options
  • Lesson 3: Implementing High Availability and Disaster Recovery Scenarios

After completing this module, students will be able to:

  • Considerations of SQL Server to Azure VM Migrations
  • SQL Workloads to Azure VM Migration Options
  • Implementing High Availability and Disaster Recovery Scenarios

Module 4: Migrate SQL Workloads to Azure SQL Databases

  • Lesson 1: Choose the right SQL Server Instance option in Azure
  • Lesson 2: Migrate SQL Server to Azure SQL DB offline
  • Lesson 3: Load and Move data to Azure SQL Database

After completing this module, students will be able to:

  • Choose the right SQL Server Instance option in Azure
  • Migrate SQL Server to Azure SQL DB online
  • Load and Move data to Azure SQL Database

Module 5: Migrate SQL Workloads to Azure SQL Database Managed Instance

  • Lesson 1: Evaluate migration scenarios to SQL Database Managed Instance
  • Lesson 2: Migrate to SQL Database Managed instance
  • Lesson 3: Load and Move data to SQL Database Managed instance
  • Lesson 4: Application Configuration and Optimization

After completing this module, students will be able to:

  • Evaluate migration scenarios to SQL Database Managed Instance
  • Migrate to SQL Database Managed instance
  • Load and Move data to SQL Database Managed instance
  • Application Configuration and Optimization

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

Migrate SQL workloads to Azure

2 Day
Classroom, Virtual

$1,545.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now