Migrate SQL Server workload to Azure SQL DP-3001 Objectives

Key Point of Training Pragrams

• Migrate SQL Server workload to Azure SQL DP-3001 Outline

  Module 1: Design a SQL Server Migration Strategy

  - Introduction
  - Examine data platform modernisation
  - Plan a data migration
  - Explore 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 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 4: Configure Database Authentication and Authorisation

  - Introduction
  - Describe Active Directory and Microsoft Entra ID
  - Describe authentication and identities
  - Describe security principals
  - Describe database and object permissions
  - Identify authentication and authorisation failures
  - Exercise: Authorise Access to Azure SQL Database with Microsoft Entra ID

  Module 5: 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 6: 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

• Migrate SQL Server workload to Azure SQL DP-3001 Format

  In-Person

  Online

• Migrate SQL Server workload to Azure SQL DP-3001 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.