Migrate SQL Server Workload To Azure SQL DP3001 Course in Manilla

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

Module 1: Design a SQL Server Migration Strategy 

• Introduction
• Examine Data Platform Modernisation
• Plan a Data Migration
• Explore the Available Data Migration Technologies
• Exercise: Compare on-premises Azure Costs

Module 2: Assess SQL Server Databases for Migration to Azure SQL

• Introduction
• Review Database for Compatibility
• Explore Assessment Options for Database Migration
• Assess a Database with Azure Migration Extension
• Assess a Database with Azure Migrate
• Assess a Database with Data Migration Assistant
• Exercise: Identify Compatibility Issues

Module 3: 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 4: 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
• Describe SQL Edge
• Exercise: Deploy an Azure SQL Database

Module 5: Migrate SQL Server Workloads to Azure Virtual Machine

• Introduction
• Review Migrations Strategies and Tools
• Explore Azure SQL Migration Extension for Azure Data Studio
• Understand Data Migration Assistant
• 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 6 : Migrate SQL Server Workloads to Azure SQL Database

• Introduction
• Choose the Right Azure SQL Database Feature
• Use Azure SQL Migration Extension to Migrate to Azure SQL Database
• Explore Data Migration Assistant 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 7: Migrate SQL Server Workloads to Azure SQL Managed Instance

• Introduction
• Evaluate Migration Scenarios
• 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 8: 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

Who Should Attend this Migrate SQL Server workload to Azure SQL (DP-3001)?

The Migrate SQL Server Workload to Azure SQL (DP-3001) course is tailored for professionals who are involved in the planning, implementation, and management of database infrastructure transitions to Azure SQL. This training will be particularly beneficial for:

• Chief Information Officers (CIO)
• Database Administrators (DBA)
• IT Managers
• Cloud Solutions Architects
• Head of IT Infrastructure Executives
• Director of IT Operations
• Systems Engineers
• Data Migration Specialists

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

Delegates should have understanding of SQL Server and basic knowledge of Azure services. Experience in database management and familiarity with cloud migration strategies are also required.

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

Migrate SQL Server Workload to Azure SQL (DP-3001) is a targeted training course designed to empower IT professionals with the necessary skills to transition SQL Server databases to Azure SQL effectively. This course focuses on practical strategies for assessing, planning, and executing migrations that optimise performance and cost-efficiency in the cloud. Through this training, organisations will benefit from enhanced database scalability, robust security, and streamlined management, essential for modern cloud architectures. For individuals, it provides a comprehensive understanding of Azure migration tools and methodologies, significantly boosting their technical proficiency and career prospects in cloud technologies.

During this training course, delegate will learn how to leverage Azure's powerful migration frameworks, from initial assessment to the operationalisation of migrated databases. The course includes detailed sessions on using tools like Azure Migrate and Data Migration Assistant, understanding IaaS and PaaS deployment options, and implementing post-migration optimisation techniques.  The training will be delivered by seasoned experts with extensive experience in Azure SQL migrations, offering both theoretical knowledge and practical insights.

Course Objectives

• To evaluate SQL Server readiness for Azure migration
• To design a comprehensive migration strategy
• To utilise Azure’s data migration tools efficiently
• To deploy SQL Server workloads on Azure VMs
• To implement Azure SQL Database and Managed Instances
• To configure post-migration security and performance
• To understand costs related to Azure SQL solutions

After attending this training, delegates will be equipped to confidently assess and migrate SQL Server databases to Azure SQL, leveraging both Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) models. They will be proficient in using Azure’s native tools like Azure Migrate and Data Migration Assistant to facilitate smooth transitions. Additionally, participants will gain the ability to configure and optimise the migrated databases for enhanced performance, security, and disaster recovery.

What’s included in this Migrate SQL Server workload to Azure SQL DP3001 Course?

• World-Class Training Sessions from Experienced Instructors 
• Migrate SQL Server workload to Azure SQL DP3001 Course Certificate
• Digital Delegate Pack