Microsoft Fabric: Introducing Data Warehouses

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. What are data warehouses and how do they compare to data lakehouses? What are their key differences and when should you choose each of these storage technologies? In this course, you’ll learn the answers to these questions while building hands-on experience. First, learn how warehouses handle structured data through T-SQL queries. Then, get hands-on with data ingestion to a warehouse. Upload data to Azure Data Lakehouse Storage Gen2, ingest it into a Fabric data warehouse using the COPY INTO command, and implement strategies to manage potential errors and maintain data integrity. Finally, dive into advanced data management, running T-SQL queries to perform DDL and DML operations in warehouses. Learn about database mirroring in Fabric, which allows data replication within external storage systems and gain a comprehensive understanding of secure and resilient data workflows in Fabric warehouses. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.