DP-3001 Migrate SQL Server workload to Azure SQL
In a single day you will plan and carry out a move from SQL Server to Azure SQL: design a migration strategy, assess databases, deploy PaaS options, configure authentication, migrate workloads and complete post-migration tasks.
About this course
In a single day you will plan and carry out a move from SQL Server to Azure SQL: design a migration strategy, assess databases, deploy PaaS options, configure authentication, migrate workloads and complete post-migration tasks.
What you'll learn
- Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Database. Migrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities.
- Use transactional replication as an online method to migrate to Azure SQL Database.
- Explore several other methods for migrating SQL Server databases to Azure SQL Database.
Curriculum
- Examine data platform modernization
- Plan a data migration
- Explore the available data migration technologies
- 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
- 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
- Describe Active Directory and Microsoft Entra ID
- Describe authentication and identities
- Describe Security Principals
- Describe database and object permissions
- Identify authentication and authorization failures
- 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
- 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
Who it's for
Database administrators planning to move SQL Server workloads to the cloud.
Before you start
- 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.
Related courses
More in Microsoft Data & Power BI →55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Administering a SQL Database Infrastructure (55353)
Microsoft Data & Power BI
View course →Administering Microsoft Azure SQL Solutions (DP-300 Exam Prep/DP-300T00)
Microsoft Data & Power BI
View course →Data Analysis using Power BI Desktop - Level 1: Report Builder
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.