Migrate SQL Server workload to Azure SQL (DP-3001) - Training Courses | Afi U.

Guaranteed to Run sessions View all courses

Training and Coaching

Cultivate a learning organization and develop talent.

Customer Experience

Optimize your processes for operational excellence.

Employee Experience

Engage, empower, and enhance employee well-being.

Artificial Intelligence

Master AI and automate your processes.

Develop key skills to inspire and mobilize.

Boost collaboration and productivity within your teams

Strategy and Performance

Align your goals for sustainable growth.

Digital Transformation

Leverage technology to innovate and accelerate your growth.

Coaching Fundamentals Executive Leadership Leadership and Team Management Conscious, collaborative, and transformational leadership View all programs

Management in the digital age Innovation Governance: Tools and Strategies to Transform Your Organization Leader as Coach: Better Delegation and Empowerment Management in Turbulent Times Coaching in a Consulting Role Building a Customer-Centric Culture: Drive Loyalty, Growth, and Innovation Transform Employee Experience The essentials of an ESG strategy View all microprograms

Artificial intelligence at the service of your organization Achieving your aspirations as a young professional Managing a Growing SME Adapting your management style to the new generations View all Circles by Afi U.

Private Delivery Collaborative Learning Workshops Business Coaching Custom Programs Private Conferences

Who are we?Afi U. Experience The Team Our Offices Partners and Certifications Careers

Blog Funding programs Newsletter FAQ Contact

Benefits of Project Management and Key Trends For a leadership that fits you : find the right program Afi U. 2024-2025 Training Catalog Guaranteed-to-run schedule Discover the Power BI learning path

Back to catalogue

New

Migrate SQL Server workload to Azure SQL (DP-3001)

Learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration Extension and Database Migration Assistant.

Private session

This training is available in a private or personalized format. It can be provided in one of our training centres or at your offices. Call one of our consultants of submit a request online.

Call now at 1 877 624.2344

Duration: 1 day
Regular price: On request

Course outline

Duration : 1 day

© AFI par Edgenda inc.

Applied Skills training courses are designed to validate specific skills by focusing on real-life scenarios. They offer a targeted alternative to traditional role-based certifications, focusing on the application of technical skills in work situations. This learning path prepares you for the task of migrating SQL Server workloads to Azure SQL. You'll learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration Extension and Database Migration Assistant. You'll also learn how to provision and configure Azure SQL resources. You'll gain hands-on experience in choosing the best migration option to meet business requirements for downtime, handling migration state, and monitoring database migration. Additionally, you'll also learn to perform post-migration tasks like disaster recovery and monitoring. These skills are essential for ensuring a smooth, efficient transition to Azure SQL, and maintaining its operation post-migration.
Audience	Administrator Data Engineer Database Administrator Developer
Prerequisites	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.
Objectives	Designing a SQL Server Migration Strategy: You will learn how to plan and design an effective approach for migrating your SQL Server databases to Azure SQL. Assessing SQL Server Databases for Migration to Azure SQL: You will explore evaluation tools such as the Azure SQL Migration extension and the Database Migration Assistant. These tools will help you assess the compatibility of SQL Server components for migration. Deploying PaaS Solutions with Azure SQL: You will discover how to provision and configure Azure SQL resources. Additionally, you’ll learn to choose and configure appropriate options for high availability. Configuring Authentication and Authorization for Databases: You will master aspects related to authentication and permissions within the context of Azure SQL.
Teaching method	Notez que vous aurez besoin d’un abonnement Azure pour effectuer les exercices pratiques. Si vous n’en avez pas encore, vous pouvez créer un compte gratuit et ajouter un abonnement avant de commencer. Please note that you will need an Azure subscription to perform the practical exercises. If you don’t have one yet, you can create a free account and add a subscription before getting started.
Contents	Design a SQL Server migration strategy Assess SQL Server databases for migration to Azure SQL Deploy IaaS solutions with Azure SQL Deploy PaaS solutions with Azure SQL Migrate SQL Server workloads to Azure Virtual Machine Migrate SQL Server workloads to Azure SQL Database Migrate SQL Server workloads to Azure SQL Managed Instance Perform post-migration tasks on Azure SQL

⭐ Discover more Applied Skills: Microsoft applied skills (afiexpertise.com)