This learning path prepares you for the task of migrating SQL Server workloads to Azure SQL.
You'll learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration Extension and Database Migration Assistant. You'll also learn how to provision and configure Azure SQL resources. You'll gain hands-on experience in choosing the best migration option to meet business requirements for downtime, handling migration state, and monitoring database migration.
Additionally, you'll also learn to perform post-migration tasks like disaster recovery and monitoring. These skills are essential for ensuring a smooth, efficient transition to Azure SQL, and maintaining its operation post-migration.
Audience
Administrator
Data Engineer
Database Administrator
Developer
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.
Objectives
Designing a SQL Server Migration Strategy: You will learn how to plan and design an effective approach for migrating your SQL Server databases to Azure SQL.
Assessing SQL Server Databases for Migration to Azure SQL: You will explore evaluation tools such as the Azure SQL Migration extension and the Database Migration Assistant. These tools will help you assess the compatibility of SQL Server components for migration.
Deploying PaaS Solutions with Azure SQL: You will discover how to provision and configure Azure SQL resources. Additionally, you’ll learn to choose and configure appropriate options for high availability.
Configuring Authentication and Authorization for Databases: You will master aspects related to authentication and permissions within the context of Azure SQL.
Teaching method
Notez que vous aurez besoin d’un abonnement Azure pour effectuer les exercices pratiques. Si vous n’en avez pas encore, vous pouvez créer un compte gratuit et ajouter un abonnement avant de commencer.
Please note that you will need an Azure subscription to perform the practical exercises. If you don’t have one yet, you can create a free account and add a subscription before getting started.
Contents
Design a SQL Server migration strategy
Assess SQL Server databases for migration to Azure SQL
Deploy IaaS solutions with Azure SQL
Deploy PaaS solutions with Azure SQL
Migrate SQL Server workloads to Azure Virtual Machine
Migrate SQL Server workloads to Azure SQL Database
Migrate SQL Server workloads to Azure SQL Managed Instance
Perform post-migration tasks on Azure SQL
Surround yourself with the best
Frédéric Paradis
Certified Trainer and Cloud Architect
As a certified Microsoft trainer, Frédéric describes himself as a Cloud magician who easily navigates the mythical space between technology and reality.
Marc Maisonneuve
Training program director
Marc Maisonneuve has acted as a Training Program Director, professional effectiveness trainer and user tools practice leader at AFI for several years. Mr. Maisonneuve is known for his analytical skills, his legendary calm and his undeniable desire to encourage people to develop their skills. He has the ability to present technological solutions in a natural way and to adapt them to the concrete needs of the workplace.
Vicky Moreau
Trainer
Vicky Moreau is a passionate freelancer and professional in the area of office automation. She holds a college diploma in office automation, most of her solid experience with the Office Suite was acquired while being an autodidact. In fact, she has successfully completed an MOS (Microsoft Office Specialist) Excel certification.
Francis Ferland-Stevenson
Trainer
Francis began as a trainer more than 5 years ago by testing office automation tools designed specifically to met the needs of his colleagues. His calm and his empathy makes him able to adapt his language according to the level of experience of the group. This makes his learnings clear and accessible to anyone. As a trainer, he is therefore attentive to the needs of his students to make sure they meet their objectives and face the challenges.