What you'll learn:
- Students will learn how to build warehouse and lakehouses on Microsoft Fabric.
- Students will learn all aspects required to take on the DP-700 exam.
- Students will learn aspects around ingesting and transforming data into Microsoft Fabric.
- Students will gain a better understanding on how to use Microsoft Fabric when it comes the data engineering needs.
This intensive, comprehensive course is designed to prepare data professionals for the Microsoft DP-700 certification exam, focusing on data warehouse implementation and optimization using Microsoft Fabric. Participants will gain the knowledge and practical skills necessary to design, implement, and manage semantic models, data warehouses , lakehouses that leverage the full power of Microsoft's modern data analytics platform.
What are we going to learn
First we'll setup the required accounts and tools required to practice along. We will learn how to use Free trial licenses when it comes to Microsoft Fabric.
Then we will do a deep-dive into hosting data warehouses in Microsoft Fabric. There are different ways in which we can ingest data into a data warehouse. We will learn how to use Data pipelines, T-SQL and Data Flow Gen2 to ingest data into a data warehouse. We won't be done there. We will learn how to design Fact and Dimension tables within a data warehouse.
Next it will be time to perform a deep-dive into Lakehouses. We'll again use Data pipelines and Data Flow Gen2 to ingest data into a lakehouse. We'll learn on how to use Notebooks to in interact with data within a lakehouse.
Next comes the Eventhouse. How do we get data into the eventhouse.How do we stream a continuous data streams into the eventhouse. And then how to use the Kusto Query Language to query for data.
As per the exam , we need to focus on key security concepts, such as how to secure access to items in Microsoft Fabric.How do we enforce column and row level security. There's a lot to cover when it comes to security in Microsoft Fabric.
