Course Overview
Learn how to perform online and offline SQL Server migrations to Azure SQL
Moyens d'évaluation :
- Quiz pré-formation de vérification des connaissances (si applicable)
- Évaluations formatives pendant la formation, à travers les travaux pratiques réalisés sur les labs à l’issue de chaque module, QCM, mises en situation…
- Complétion par chaque participant d’un questionnaire et/ou questionnaire de positionnement en amont et à l’issue de la formation pour validation de l’acquisition des compétences
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
Français
Anglais
Allemand
ukrainien
Polonais
Pays-Bas
Pologne
Ukraine
Arabie Saoudite
Emirats-Arabes-Unis
Moyens Pédagogiques :