What you'll learn

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.