TYPE
Virtual
Classroom ILT
LEARNING PATH
SKILL LEVEL
DURATION
AVAILABLE DATES
Choose date
R3 400,00
Price excluding VAT
Introduction
This learning path prepares you for the task of migrating SQL Server workloads to Azure SQL Database. You’ll learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration Extension and Database Migration Assistant. This training guides you through the process of provisioning and configuring Azure SQL Database resources. You 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 for Azure SQL Database. These skills are essential for ensuring a smooth, efficient transition to Azure SQL Database, and maintaining its operation post-migration.
Pre-requisites
Before attending this course, delegates must know:
- 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
Module 1: Design a SQL Server migration strategy |
In this module, you’ll learn the phases of a migration and the steps involved to ensure your migration project is executed smoothly. You’ll also learn the purpose of data platform modernization and see the benefits it can bring to your organization.
Lessons: |
|
By the end of this module, you’ll be able to: |
|
Module 2: Assess SQL Server databases for migration to Azure SQL |
Assessment tools such as Azure SQL Migration extension for Azure Data Studio, Azure Migrate, and Data Migration Assistant facilitate the migration of SQL Server databases to Azure
Lessons: |
|
By the end of this module, you’ll be able to: |
|
Module 3: Deploy PaaS solutions with Azure SQL |
Provision and deploy Azure SQL Database and Azure SQL managed instance. Select the appropriate options when performing a migration to the SQL PaaS platform.
Lessons: |
|
By the end of this module, you’ll be able to: |
|
Module 4: Configure database authentication and authorization |
Contrast authentication using Microsoft Entra ID, Windows Active Directory, and SQL Server authentication. Implement various security principals and configure permissions.
Lessons: |
|
By the end of this module, you’ll be able to: |
|
Module 5: Migrate SQL Server workloads to Azure SQL Database |
You will explore different migration tools and migrate SQL Server databases to Azure SQL Database.
Lesson: |
|
By the end of this module, you’ll be able to: |
|
Module 6: Perform post-migration tasks on Azure SQL |
You’ll explore different features and tools to help you maintain Azure SQL environments.
Lesson: |
|
In this module, you’ll practice how to: |
|
Associated certifications and exam
There is no Associated certification & Exam for this course, however, there is an assessment to achieve your Applied Skills credential. (Assessment Link)
Microsoft Overview
Skilled Microsoft engineers add significant value to the marketplace by reducing the cost of technology solutions whilst improving efficiency and fuelling innovation. Through authorized Microsoft training, Torque IT empowers engineers, developers and end-users to realise their full potential by providing them with the necessary knowledge and skills to optimise the adoption and use of Microsoft solutions.
Torque IT considers authorised Microsoft training to be an integral part of any Microsoft implementation. Microsoft authorised training, and associated certification, ensures that you get the most from your technology investment and that you are able to operate above the technology curve. Microsoft career certifications are universally recognised as demonstrating a high level of expertise and credibility for individuals and the organisations that employ them.
Authorized Microsoft training and certification is the industry standard for any solution that includes designing, selling, implementing, upgrading, managing, and operating Microsoft solutions.
For 19 years, Torque IT has maintained the status of Gold Learning Partner for Microsoft in South Africa. This is the highest level of accreditation that Microsoft awards to Learning Partners that specialize in technical, product, sales, development, end-user and solutions training.
These achievements reflect our commitment to providing our customers with quality skills development, enablement, training, and certification solutions that demonstrate exceptional depth, breadth, and expertise across Windows Server, Windows Client, Microsoft Virtualization, Microsoft Azure, Office 365, Exchange Server, SharePoint Server, Skype for Business, System Centre Server, Visual Studio and Microsoft Office technologies.
Torque is recognized by Microsoft, and the industry, as having met rigorous standards for educational competency, service, customer satisfaction and investment in Microsoft technologies that will prepare the next generation of IT industry professionals.