DP-700 Microsoft Fabric Data Engineer

Tässä koulutuksessa käydään läpi kattavasti Microsoft Fabricin komponentit (Lakehouse, Spark, Delta-taulut, Medallion-arkkitehtuuri, Data Warehouse, DataFlows, Eventhouse, Rea-time Intelligence), joiden avulla toteutetaan Data Engineering -ratkaisut.

Huomioithan, että Microsoft Fabricista on myös toinen kurssi DP-600 Microsoft Fabric Analytics Engineer, joka on osin päällekkäinen tämän kurssin kanssa, mutta painottuu enemmän Power BI:n ja DAX:in käyttöön.

Tavoite

Opi Data Engineering tekniikat ja käytännöt Microsoft Fabricilla.

Kenelle

Koulutus on suunnattu Data Engineer -asiantuntijoille, arkkitehdeille ja kaikille, joiden tulee osata Microsoft Fabric -tekniikat.

Koulutukseen osallistujalla on suositeltavaa olla hyvä osaaminen datan hallinnasta sekä SQL:n ja Pythonin perusteista.

Lisätiedot

Koulutus valmentaa Microsoftin viralliseen Microsoft Certified: Fabric Data Engineer Associate -sertifiontitestiin.

Koulutuksen sisältö

Explore end-to-end analytics with Microsoft Fabric

• Describe end-to-end analytics in Microsoft Fabric.
• Understand data teams and roles that use Fabric.
• Describe how to enable and use Fabric.

Get started with Lakehouses in Microsoft Fabric

• Describe core features and capabilities of lakehouse in Microsoft Fabric
• Create lakehouse
• Ingest data into files and tables in lakehouse
• Query lakehouse tables with SQL

Use Apache Spark in Microsoft Fabric

• Prepare to use Apache Spark
• Work with Data using Spark notebooks
• Visualize data in Spark notebook

Work with Delta Lake tables in Microsoft Fabric

• Understand Delta Lake and delta tables in Microsoft Fabric
• Create and manage delta tables using Spark
• Optimize delta tables
• Use delta tables with Spark structured streaming

Ingest Data with Dataflows Gen2 in Microsoft Fabric

• Describe Dataflow (Gen2) capabilities in Microsoft Fabric
• Create Dataflow (Gen2) solutions to ingest and transform data
• Include a Dataflow (Gen2) in a pipeline

Orchestrate processes and data movement with Microsoft Fabric

• Describe pipeline capabilities in Microsoft Fabric
• Use the Copy Data activity in a pipeline
• Create pipelines based on predefined templates
• Run and monitor pipelines

Organize a Fabric lakehouse using medallion architecture design

• Describe the principles of using the medallion architecture in data management.
• Apply the medallion architecture framework.
• Analyze data stored in the lakehouse using DirectLake in Power BI

Get started with Real-Time Intelligence with Microsoft Fabric

• Understand real-time data analytics concepts
• Explore core components of Real-Time Intelligence in Microsoft Fabric

Use real time eventstreams in Microsoft Fabric

• Establish source and destinations in Microsoft Fabric Eventstreams.
• Capture, transform, and route data using Microsoft Fabric Eventstreams.

Work with real-time data in a Microsoft Fabric eventhouse

• Create an eventhouse in Microsoft Fabric
• Query real-time data by using Kusto Query Language (KQL)
• Create materialized views and stored functions in a KQL database.

Get started with Data Warehouses in Microsoft Fabric

• Describe data warehouses in Fabric
• Understand a data warehouse vs a data Lakehouse
• Work with data warehouses in Fabric
• Create and manage datasets within a data warehouse

Load data into a Microsoft Fabric data warehouse

• Learn different strategies to load data into a data warehouse in Microsoft Fabric.
• Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
• Learn how to load data in a warehouse using T-SQL.
• Learn how to load and transform data with dataflow (Gen 2).

Query a data warehouse in Microsoft Fabric

• Use SQL query editor to query a data warehouse.
• Explore how visual query editor works.
• Learn how to connect and query a data warehouse using SQL Server Management Studio.

Monitor a Microsoft Fabric data warehouse

• Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
• Monitor current activity in the data warehouse with dynamic management views.
• Monitor querying trends with query insights views.

Secure a Microsoft Fabric data warehouse

• Dynamic data Masking.
• Row level security
• Column level security.

Implement continuous integration and continuous delivery (CI/CD)

• Define CI/CD and describe how it’s implemented in Fabric.
• Implement version control and Git integration.
• Use deployment pipelines to automate the deployment process.
• Automate CI/CD using Fabric APIs.

Monitor activities in Microsoft Fabric

• Apply monitoring concepts to Microsoft Fabric.
• Use Monitoring Hub in Microsoft Fabric.
• Trigger actions using Activator in Microsoft Fabric.

Secure data access in Microsoft Fabric

• Understand Fabric security model
• Configure workspace and item permissions
• Apply granular permissions.

Administer Microsoft Fabric

• Describe Fabric admin tasks
• Navigate the admin center
• Manage user access.

Avainsanat

Microsoft Fabric, Data Engineering, Apache Spark, Medallion Architecture,, Lakehouse, Real-time Intelligence, Data Warehouse, Security