HUOM! Koulutusaihe korvaa 31.3.2025 poistuvan DP-203 Data Engineering on Microsoft Azure -koulutuksen.
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