DP-3001 Migrate SQL Server workload to Azure SQL
Price Net € VAT €
Price Price on Request
Duration
1 day
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.
- 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