You need to migrate an existing data warehouse to a modern lakehouse architecture in Microsoft Fabric but lack a structured migration approach? Many organizations are transitioning from traditional warehouses to lakehouse models for greater flexibility and cost efficiency. Without a clear methodology, migrations can result in data loss, broken pipelines and extended downtime.
This official Microsoft DP-3001 Applied Skills training enables you in 1 day to plan and execute a data warehouse migration to a lakehouse in Microsoft Fabric. Guided by MCT-certified trainers, you learn to assess existing warehouse schemas, map them to lakehouse structures, migrate data using pipelines and Spark, validate data integrity, and optimize the new architecture. You practice building a complete migration workflow from assessment to validation. This hands-on credential validates your migration skills for modern analytics platforms. Sessions are available in person in Geneva and Lausanne or via virtual classroom.
Module 1: Design a SQL Server migration strategy
Module 2: Assess SQL Server databases for migration to Azure SQL
Module 3: Deploy IaaS solutions with Azure SQL
Module 4: Deploy PaaS solutions with Azure SQL
Module 5: Migrate SQL Server workloads to Azure Virtual Machine
Module 6: Migrate SQL Server workloads to Azure SQL Database
Module 7: Migrate SQL Server workloads to Azure SQL Managed Instance
Module 8: Perform post-migration tasks on Azure SQL
Many organizations are evaluating the transition from traditional data warehouses to modern lakehouse architectures in Microsoft Fabric. This migration offers benefits including unified storage on OneLake, support for both structured and unstructured data, Spark-based processing and reduced licensing costs. However, without a structured approach, migrations can fail with data quality issues, broken transformations and performance degradation. This DP-3001 credential validates your ability to plan and execute such migrations successfully.
This hands-on training focuses on the complete migration workflow. You assess existing warehouse schemas, identify migration strategies for different table types, migrate data using Fabric pipelines and Spark notebooks, transform and validate migrated data, and optimize the new lakehouse architecture. You work through realistic migration scenarios on Fabric environments with MCT-certified trainer guidance.
You should have experience with data warehousing concepts and SQL. Familiarity with Microsoft Fabric lakehouses (DP-601 level) is recommended for getting the most out of this training.
DP-3001 is a Microsoft Applied Skills credential, validating your practical ability to migrate data warehouses to lakehouses through a scenario-based assessment.
The training focuses on migrating to Microsoft Fabric lakehouses. The source assessment principles apply broadly, but the hands-on implementation uses Fabric-specific tools and patterns.
Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00
ITTA
Route des jeunes 35
1227 Carouge, Suisse
Monday to Friday, from 8:30 am to 06:00 pm.
