DP-3001 Migrate SQL Server workload to Azure SQL

Price
Net
VAT

Price
Price on Request

Duration
1 day

For companies and job seekers:
this course is 100% fundable!
 

Location

Course Language
English

Training Solutions
Online Live

The migration of relational databases to a cloud-based environment is one of the key issues in modern IT architectures. The focus is on secure, scalable, and cost-effective data platforms that reliably transfer existing SQL Server environments to Azure SQL and enable long-term operation.

Key topics

  • Migration strategies for SQL Server to Azure SQL.
  • Architecture and operating models in Azure.
  • Performance, security, and high availability.
  • Data consistency, governance, and compliance.
  • Automation, monitoring, and cost control.

Prerequisites
Solid knowledge of relational databases and practical experience with SQL Server. A basic understanding of cloud and network architectures is required.

Target audience
IT professionals, database administrators, and architects responsible for the migration, operation, and optimization of data platforms.

Working with Azure SQL opens up sustainable options for stable, flexible, and maintainable data solutions. Existing systems are further developed in a structured manner and aligned with modern cloud standards, with a focus on security, efficiency, and long-term scalability.

Print as PDF
Course content
  • Modernize your data platform
  • Plan data migration
  • Examine technologies for data migration
  • Database compatibility check
  • Evaluating migration options
  • Evaluate Azure Migration Extension
  • Assessment with Azure Migrate
  • Assessment with Data Migration Assistant
  • PaaS options for SQL Server in Azure
  • Single SQL Database
  • Elastic SQL Database Pool
  • SQL Database Hyperscale
  • SQL Managed Instance
  • SQL Edge
  • Active Directory & Microsoft Entra ID
  • Authentication & Identities
  • Security Principles
  • Database & Object Permissions
  • Errors in authentication & authorization
  • Select Azure SQL Database feature
  • Use Azure SQL Migration Extension
  • Examine the Data Migration Wizard
  • Migrate with BACPAC
  • Use the online method
  • Move data
  • Migrating SQL logins and groups
  • Implement security for Azure SQL
  • Implement compliance controls for sensitive data
  • Monitor database performance
  • Configuring high availability and disaster recovery
  • Automating database tasks for scalability

Do you have any further questions? Please contact us.