Microsoft Fabric Data Engineer
Den här kursen täcker metoder och praktiska tillämpningar för att implementera lösningar inom data engineering med hjälp av Microsoft Fabric. Du kommer att lära dig att utforma och utveckla effektiva dataladdningsmönster, dataarkitekturer och orkestreringsprocesser.
Kursens mål inkluderar att importera och transformera data samt att säkra, hantera och övervaka lösningar inom data engineering.
Målgrupp och förkunskaper
Den här kursen vänder sig till dataproffs som vill lära sig data engineering med Microsoft Fabric.
Kursen kräver erfarenhet av att manipulera och transformera data med något av följande programmeringsspråk: Structured Query Language (SQL), PySpark eller Kusto Query Language (KQL). Du bör också ha erfarenhet av dataextrahering, transformering, laddning och orkestrering,
För att hålla en hög kvalitet på våra teknikkurser använder vi både engelsk- och svensktalande experter som kursledare.
Detaljerad information
Kursmaterialet är på engelska med detta innehåll:
Explore end-to-end analytics with Microsoft Fabric
Introduces Microsoft Fabric and its components like Data Factory, Data Engineering, and Power BI, and explains how Fabric unifies data roles and services to enable collaborative data projects.
Get started with lakehouses in Microsoft Fabric
Covers the concept of a lakehouse, how to ingest, transform, and explore data using tools like notebooks, dataflows, and Power BI within the lakehouse architecture.
Use Apache Spark in Microsoft Fabric
Explains how to use Apache Spark in Fabric for scalable data processing, including loading and transforming data, writing Spark SQL, and visualizing data in notebooks.
Work with Delta Lake tables in Microsoft Fabric
Details Delta Lake features such as ACID transactions and time travel, and how to create, manage, and optimize delta tables using Spark in Fabric.
Ingest data with Dataflow Gen2 in Microsoft Fabric
Introduces Dataflow Gen2 as a low-code ETL tool in Fabric, showing how to extract, transform, and load data independently or in pipelines.
Orchestrate processes and data movement with Microsoft Fabric
Explains how to create and manage pipelines using predefined templates and activities like "Copy Data" to orchestrate data movement and transformation.
Organize a lakehouse with medallion architecture
Presents the medallion architecture (Bronze, Silver, Gold) and how to implement it using tools like pipelines and notebooks for secure and scalable data organization.
Get started with Real-Time Intelligence in Microsoft Fabric
Covers real-time analytics concepts and components like Eventstream, Eventhouse, Real-Time Dashboards, and Activator for processing and responding to live data.
Use Real-Time Eventstreams in Microsoft Fabric
Describes how to set up data sources, transformations, and destinations for streaming data, including the use of temporal windowing functions.
Work with real-time data in a Microsoft Fabric eventhouse
Explains how to use Kusto Query Language (KQL) to query real-time data stored in an eventhouse and create reusable queries and views.
Get started with data warehouses in Microsoft Fabric
Provides an overview of Fabric data warehouses, schema design (star and snowflake), fact and dimension tables, and how to query and visualize warehouse data.
Load data into a Microsoft Fabric data warehouse
Covers ETL strategies for data warehousing, including using pipelines, T-SQL COPY, and Dataflows Gen2 to load and transform data efficiently.
Monitor a Microsoft Fabric data warehouse
Teaches how to monitor data warehouse usage and performance using dynamic management views (DMVs), the Capacity Metrics app, and query insights.
Secure a Microsoft Fabric data warehouse
Details how to implement security using dynamic data masking, row- and column-level security, and granular T-SQL permissions.
Implement continuous integration and continuous delivery (CI/CD)
Introduces CI/CD principles in Fabric, including Git integration, deployment pipelines, and automation via REST APIs.
Monitor activities in Microsoft Fabric
Shows how to use the Monitoring Hub and Activator to track activities and trigger automated responses to events in Fabric.
Secure data access in Microsoft Fabric
Explains how to secure data through workspace roles, item permissions, OneLake access controls, and SQL-based security techniques.
Administer Microsoft Fabric
Covers administrative tasks in Fabric such as managing user access, monitoring resources, and governing data through lineage and metadata tools.
Relaterat innehåll
