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

Request a consultation Add to favorites Print as PDF

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

Frequently Asked Questions

  • Knowledge of cloud databases and SQL migrations is currently among the most in-demand skills in the Microsoft ecosystem. Demand is rising steadily, particularly in projects involving cloud transformation, data center modernization, and hybrid infrastructures.
  • Typical areas of application include database administration, cloud architecture, infrastructure management, and the DevOps environment. Technical project managers and consultants also regularly deal with database migrations and cloud platforms.
  • Many companies are replacing on-premises database servers with scalable cloud services. This creates new requirements for planning, migration, operation, and optimization of modern data platforms in Azure.
  • Experience with Azure services is now one of the most important requirements in many job postings in the database and infrastructure fields. Knowledge of platform services and cloud operations, in particular, is becoming increasingly important.
  • Typical projects include data center modernization, cloud migrations, application modernization, and hybrid IT strategies. Databases are often among a company's business-critical components.
  • Cloud databases reduce administrative overhead and enable flexible scaling. At the same time, they create new demands on professionals who can operate data platforms securely and cost-effectively.
  • Azure SQL platforms are used particularly frequently in manufacturing, retail, finance, healthcare, and the public sector. Cloud-based databases are becoming increasingly important wherever large volumes of data are processed.
  • Knowledge of Microsoft Azure, automation, data analysis, DevOps, and IT security is a valuable asset. This combination of skills is particularly sought after in modern cloud projects.
Berlin
Bremen
Dortmund
Dusseldorf
Frankfurt
Hamburg
Hanover
Cologne
Leipzig
Munich
Nuremberg
Stuttgart

Do you have any further questions? Please contact us.