Migrate SQL Server workload to Azure SQL (DP-3001)

 

Course Overview

Learn how to perform online and offline SQL Server migrations to Azure SQL

Prerequisites

  • 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.

Course Content

Design a SQL Server migration strategy

  • Introduction
  • Examine data platform modernization
  • Plan a data migration
  • Explore the available data migration technologies
  • Exercise: Compare on-premises Azure costs
  • Module assessment
  • Summary

Assess SQL Server databases for migration to Azure SQL

  • Introduction
  • Review database for compatibility
  • Explore assessment options for database migration
  • Assess SQL Server with Azure Arc
  • Assess a database with Azure Migrate
  • Exercise: Identify compatibility issues
  • Module assessment
  • Summary

Deploy IaaS solutions with Azure SQL

  • Introduction
  • Explain IaaS options to deploy SQL Server in Azure
  • Understand hybrid scenarios
  • Explore performance and security
  • Explain high availability and disaster recovery options
  • Exercise: Provision a SQL Server on an Azure Virtual Machine
  • Module assessment
  • Summary

Deploy PaaS solutions with Azure SQL

  • Introduction
  • Explain PaaS options for deploying SQL Server in Azure
  • Explore single SQL database
  • Deploy SQL database elastic pool
  • Understand SQL database hyperscale
  • Examine SQL managed instance
  • Exercise: Deploy an Azure SQL Database
  • Module assessment
  • Summary

Migrate SQL Server workloads to Azure Virtual Machine

  • Introduction
  • Review migrations strategies and tools
  • Understand distributed availability group for migration
  • Migrate databases using native backup and restore
  • Compare additional migration methods
  • Exercise: Migrate SQL Server databases to SQL Server on Azure Virtual Machine
  • Module assessment
  • Summary

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

Migrate SQL Server workloads to Azure SQL Managed Instance

  • Introduction
  • Evaluate migration scenarios
  • Migrate using Azure Arc
  • Use Log Replay Service (LRS) to migrate
  • Migrate using Managed Instance link
  • Move data to SQL Managed Instance
  • Exercise - Migrate a SQL Server database to Azure SQL Managed Instance
  • Module assessment
  • Summary

Perform post-migration tasks on Azure SQL

  • Introduction
  • Migrate SQL logins and groups
  • Implement security to protect Azure SQL
  • Implement compliance controls for sensitive data
  • Monitor database performance
  • Configure high availability and disaster recovery
  • Automate database tasks for scalability
  • Exercise: Configure geo-replication for Azure SQL Database
  • Module assessment
  • Summary

Prices & Delivery methods

Online Training

Duration
1 day

Price
  • CHF 420.—
Book now
Enquire a date
Classroom Training

Duration
1 day

Price
  • Switzerland: CHF 420.—
incl. catering
Book now
Enquire a date

Schedule

Instructor-led Online Training:   Course conducted online in a virtual classroom.
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

English

European Time Zones

Online Training Course language: English
Online Training Course language: English

6 hours difference to Central European Summer Time (CEST)

Online Training Time zone: Eastern Daylight Time (EDT) Course language: English
Online Training Time zone: Eastern Daylight Time (EDT) Course language: English
Online Training Time zone: Eastern Standard Time (EST) Course language: English
Online Training Time zone: Eastern Standard Time (EST) Course language: English

7 hours difference to Central European Summer Time (CEST)

Online Training Time zone: Central Daylight Time (CDT) Course language: English
Online Training Time zone: Central Daylight Time (CDT) Course language: English

9 hours difference to Central European Summer Time (CEST)

Online Training Time zone: Pacific Daylight Time (PDT) Course language: English
Online Training Time zone: Pacific Daylight Time (PDT) Course language: English
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

Germany

Munich
Frankfurt

If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.