________________________________________________________________
Would you like to take this course online or in person?
Contact us by email: info@nanforiberica.com , phone: +34 91 031 66 78 / +34 605 98 51 30, WhatsApp: +34 685 60 05 91 , or contact our offices
________________________________________________________________
Course DP-3001: Migrate SQL Server workload to Azure SQL
To earn this Microsoft Applied Skills credential, students must demonstrate the ability to assess and migrate SQL Server workloads to Azure SQL Database .
Candidates for this credential should have a solid understanding of both database-level and instance-level scoped objects in SQL Server . They should also be familiar with provisioning Azure SQL resources and navigating the Azure portal .
Intermediate - SQL Server, Azure SQL Database - Database Administrator, Data Engineer, Database Administrator
DP-3001 Training Objectives
- Perform post-migration configuration
- Setting up disaster recovery
- Database evaluation and preparation for migration
- Migrating databases to Azure SQL databases
- Provision and configure Azure SQL databases.
DP-3001 Course Content
Module 1 Designing a SQL Server Migration Strategy
- Data Platform Modernization Review
- Planning a data migration
- Exploring the technologies available for data migration
- Exercise: Comparing Azure On-Premises Costs
Module 2: Assessing SQL Server Databases for Migration to Azure SQL
- Reviewing the database for compatibility
- Exploring Assessment Options for Database Migration
- Assessing a database with the Azure Migration Extension
- Assessing a database with Azure Migrate
- Assessing a database with Data Migration Assistant
- Exercise: Identifying Compatibility Issues
Module 3 Implementing PaaS Solutions with Azure SQL
- Understanding PaaS options for deploying SQL Server on Azure
- Explore a single SQL database
- Deploying an Azure SQL Database Elastic Pool
- SQL Database Hyperscale Description
- Examine Azure SQL Managed Instance
- Describe SQL Edge
- Exercise: Deploying an Azure SQL Database
Module 4 Configuring Authentication and Authorization
- Description of Active Directory and Microsoft Login ID
- Description of authentication and identities
- Description of security entities
- Description of object and database permissions
- Identifying authentication and authorization errors
- Exercise: Authorizing access to Azure SQL Database with Microsoft Access ID
Module 5: Migrating SQL Server Workloads to Azure SQL Database
- Choosing the right Azure SQL Database feature
- Using the Azure SQL Migration Extension to migrate to Azure SQL Database
- Exploring Data Migration Assistant to migrate to Azure SQL Database
- Migrating to Azure SQL Database with BACPAC
- Using an online method to migrate to Azure SQL Database
- Moving to Azure SQL Database
- Exercise: Migrating a SQL Server database to Azure SQL Database
Module 6: Performing Post-Migration Tasks in Azure SQL
- Migrating SQL logins and groups
- Implementing security to protect Azure SQL
- Implementing compliance controls for sensitive data
- Monitoring the performance of a database
- Configuring High Availability and Disaster Recovery
- Automating database tasks for scalability
- Exercise: Configure geo-replication for Azure SQL Database
Prerequisites
A solid understanding of both database-level and instance-level scoped objects in SQL Server is recommended. You should also be familiar with provisioning Azure SQL resources and navigating the Azure portal.
Language
- Course: English / Spanish
- Labs: English / Spanish
Microsoft Applied Skills
This course is part of the Microsoft Applied Skills Credentials.
To earn this Microsoft Applied Skills credential, students must demonstrate the ability to assess and migrate SQL Server workloads to Azure SQL Database.
Applied Skills: Explore all credentials in one guide
