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

Ref. DP-3001
Duration:
1
 day
Exam:
Optional
Level:
Intermediate

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

Translate your transition to the cloud with our advanced training “Migrate SQL Server workload to Azure SQL (DP-3001)” which focuses on migrating SQL Server to Azure SQL Database. This learning path is designed for demanding professionals, offering insightful migration strategies, cutting-edge data migration technologies, and rigorous assessment methodologies. Learn how to use tools such as the Azure SQL Migration extension and the Database Migration Assistant to ensure seamless compatibility.

Our course, Migrate SQL Server workload to Azure SQL (DP-3001), also covers crucial aspects such as disaster recovery planning and database monitoring, ensuring sustained operational efficiency in the Azure environment. Join us to master best practices, minimize downtime, and maximize the performance of your migration to Azure SQL Database.

Participant profiles

  • Database Administrator
  • Data Engineer
  • Administrator

Objectives

  • Design a SQL Server migration strategy
  • Plan a data migration
  • Evaluate SQL Server databases for migration to Azure SQL
  • Deploy PaaS solutions with Azure SQL
  • Implement security and compliance to protect Azure SQL
  • Monitor and optimize Azure SQL performance

Prerequisites

  • Previous experience in SQL Server database administration
  • Recommended familiarity with Microsoft Azure services

Course content

Module 1: Designing a Migration Strategy for SQL Server

  • Review data platform modernization
  • Plan a data migration
  • Explore available data migration technologies

Module 2: Evaluating SQL Server Databases for Migration to Azure SQL

  • Review database for compatibility
  • Explore database migration evaluation options
  • Evaluate a database with the Azure Migration extension
  • Evaluate a database with Azure Migrate
  • Evaluate a database with the Data Migration Assistant

Module 3: Deploying PaaS Solutions with Azure SQL

  • Explain PaaS options for deploying SQL Server in Azure
  • Explore a single SQL database
  • Deploy a SQL database elastic pool
  • Understand the hyperscale tier of SQL database
  • Review SQL Managed Instance
  • Describe SQL Edge

Module 4: Configuring Database Authentication and Authorization

  • Describe Active Directory and Microsoft Entra ID
  • Describe authentication and identities
  • Describe security principles
  • Describe database and object permissions
  • Identify authentication and authorization failures

Module 5: Migrating SQL Server Workloads to Azure SQL Database

  • Choose the right Azure SQL Database feature
  • Use the 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

Module 6: Performing Post-Migration Tasks on Azure SQL

  • 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

Documentation

  • Digital course material included

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

Amplify Your SQL Server Migration Strategy with Our Advanced Training : Migrate SQL Server workload to Azure SQL (DP-3001)

Our advanced training program is designed to equip IT professionals with the skills and knowledge necessary to successfully migrate SQL Server to modern platforms. With a special focus on Azure SQL, our course provides a deep understanding of available data migration technologies, as well as strategies for deploying effective PaaS solutions.

Data Platform Modernization

Explore the latest trends in data platform modernization. Learn how to plan an effective data migration and discover the migration technologies available to facilitate this process. Our training highlights best practices for assessing SQL Server databases for migration to Azure SQL, ensuring a smooth transition.

Evaluation and Planning for Migration

We guide you through various evaluation options for migrating your database. Learn to use the Azure Migration extension, Azure Migrate, and the Data Migration Assistant for a comprehensive assessment of your database. These tools play a crucial role in preparation for migration and ensure your database’s compatibility with Azure SQL.

Deploying PaaS Solutions with Azure SQL

Discover PaaS options for deploying SQL Server on Azure, including single SQL database, SQL elastic pool, and managed SQL instance. We also cover advanced concepts such as SQL hyperscale database and SQL Edge, preparing you to fully leverage Azure SQL capabilities.

Authentication and Authorization

Dive into database authentication and authorization mechanisms, focusing on Active Directory and Microsoft Entra ID. Our training addresses key identity and security concepts, including security principles, database and object permissions, and how to identify authentication and authorization failures.

Migrating to Azure SQL Database

Learn how to select the right Azure SQL Database feature for your needs, use the Azure SQL migration extension to migrate, and leverage the Data Migration Assistant. Our training also covers online methods for migrating to Azure SQL Database, managing post-migration tasks, and implementing security to protect Azure SQL.

Monitoring and Performance Management

We emphasize the importance of monitoring database performance, configuring high availability, and disaster recovery. Learn to automate database tasks for scalability and efficient management, thus ensuring business continuity and the protection of sensitive data.

Our DP-3001 training is not only content-rich but also designed to be human and natural, facilitating learning and the practical application of knowledge. Join us to transform your SQL Server migration strategy and embrace the latest in cloud database innovations with confidence and competence.

Prix de l'inscription
CHF 850.-
Inclus dans ce cours
  • Training provided by a certified trainer
  • 180 days of access to Official Microsoft Labs
  • Official documentation in digital format
  • Official Microsoft achievement badge

ven31Mai09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3001

ven31Mai09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-3001

ven05juil09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3001

ven05juil09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-3001

ven09Aoû09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3001

ven09Aoû09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-3001

ven13Sep09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3001

ven13Sep09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-3001

ven18Oct09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3001

ven18Oct09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-3001

ven22Nov09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3001

ven22Nov09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-3001

ven27Déc09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-3001

ven27Déc09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-3001

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X