DP-600: Implementing Analytics Solutions Using Microsoft Fabric

Komplett kursinformasjon legges ut så snart Microsoft har publisert kurset.

Audience 

Course content

Introduction to Azure Synapse Analytics

Use Azure Synapse serverless SQL pool to query files in a data lake

In this module, you'll learn how to:

• Identify capabilities and use cases for serverless SQL pools in Azure Synapse Analytics
• Query CSV, JSON, and Parquet files using a serverless SQL pool
• Create external database objects in a serverless SQL pool

Analyze data with Apache Spark in Azure Synapse Analytics

In this module, you'll learn how to:

• Identify core features and capabilities of Apache Spark.
• Configure a Spark pool in Azure Synapse Analytics.
• Run code to load, analyze, and visualize data in a Spark notebook.

Use Delta Lake in Azure Synapse Analytics

In this module, you'll learn how to:

• Describe core features and capabilities of Delta Lake.
• Create and use Delta Lake tables in a Synapse Analytics Spark pool.
• Create Spark catalog tables for Delta Lake data.
• Use Delta Lake tables for streaming data.
• Query Delta Lake tables from a Synapse Analytics SQL pool.
•  

Analyze data in a relational data warehouse

In this module, you'll learn how to:

• Design a schema for a relational data warehouse.
• Create fact, dimension, and staging tables.
• Use SQL to load data into data warehouse tables.
• Use SQL to query relational data warehouse tables.

Certification

This training will help you prepare for exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.

By passing this exam you will earn the new Microsoft Certified: Fabric Analytics Engineer Associate certification.

 

Other relevant courses