Who is this training for?
Administrators, data engineers, database administrators, and developers.
Training objectives
- Design a SQL Server migration strategy to plan and design an effective approach for migrating your SQL Server databases to Azure SQL
- Evaluate SQL Server databases for migration to Azure SQL by exploring assessment tools such as the Azure SQL Migration extension and the Database Migration Wizard to assess the compatibility of SQL Server components
- Deploy PaaS solutions with Azure SQL by learning how to provision and configure Azure SQL resources and learning how to choose and configure the appropriate options for high availability
- Configure authentication and authorization for databases by mastering authentication and permissions aspects in the context of Azure SQL
Summary
Applied Skills training courses are designed to validate specific skills by being oriented towards real-world scenarios. They offer a targeted alternative to traditional role-based certifications, with a focus on applying technical skills in real-world business situations. This course prepares you for migrating SQL Server workloads to Azure SQL. You will learn how to evaluate SQL Server components and compatibility for migration using the Azure SQL Migration Extension and the Database Migration Wizard. 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, migration status management, and database migration monitoring. In addition, you will learn how to perform post-migration tasks such as disaster recovery and monitoring. These skills are critical to ensuring an efficient and smooth transition to Azure SQL and keeping it running after the migration.
Course outline
- Design a SQL Server migration strategy
- Evaluate 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
- Run post-migration tasks on Azure SQL
Approach and methodology
Practical and structured approach combining focused theory and guided workshops. Participants gradually migrate workloads from SQL Server to Azure SQL through real-world exercises inspired by business scenarios, promoting immediate application of learnings. They learn how to plan, execute, and optimize migrations, while ensuring business continuity and database performance in the cloud. Led by a Microsoft certified trainer, the training focuses on interactivity and the development of directly transferable technical skills to modernize data environments in a professional context.
Prerequisites
- You'll need an Azure subscription to complete the labs. If you don't have one yet, you can create a free account and add a subscription before you start.
- Experience with SQL Server databases, knowledge of SQL Server editions and versions
Recommendations
- Basic knowledge of security concepts such as identities and permissions
- Experience using the Azure portal to create resources and set permissions.
