Microsoft Fabric Analytics Engineer: Explore and Analyze Data

How can you use a Fabric workspace to query Azure Data Lake for analytics? This course will teach you how to use SQL and a query designer to extract data through lakehouse and warehouse artifacts in Fabric, and will help you pass the DP-600 exam.

In order to pass the Microsoft DP-600 exam, you will need to learn how to use SQL or the query designer to extract analytical information from a warehouse and lakehouse artifact. In this course, Microsoft Fabric Analytics Engineer: Explore and Analyze Data, you’ll gain the ability to navigate and query data in Fabric lakehouses and warehouses to solve analytical queries. First, you will explore the Fabric service workspace enabled on a capacity. Next, you will open a lakehouse artifact to query data in a connected data lake through the new SQL query and new visual query panes. Next, you will transition to the warehouse artifact and use the tree view list to examine data from a data lake. Finally, you will discover the SQL endpoint exposed by Fabric to use SQL Server Management Studio or Azure Data Studio to query the same data. When you are finished with this course, you will have the skills and knowledge of Microsoft Fabric analytics engineering needed to pass the DP-600 exam section on analyzing and querying data.

• Course Overview 2mins
• Using a Lakehouse in Fabric to Retrieve Analytical Data 16mins
• Exploring the Querying of Data Lake Data in a Fabric Warehouse 16mins