Microsoft Fabric Data Engineer

Ingest Data with Dataflows Gen2 in Microsoft Fabric

Data ingestion is crucial in analytics. Microsoft Fabric's Data Factory offers Dataflows for visually creating multi-step data ingestion and transformation using Power Query Online.

• Understand Dataflows Gen2 in Microsoft Fabric
• Explore Dataflows Gen2 in Microsoft Fabric
• Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
• Exercise - Create and use a Dataflow Gen2 in Microsoft Fabric
• Module assessment

Orchestrate processes and data movement with Microsoft Fabric

Use Data Factory pipelines in Microsoft Fabric

• Understand pipelines
• Use the Copy Data activity
• Use pipeline templates
• Run and monitor pipelines
• Exercise - Ingest data with a pipeline
• Module assessment

Use Apache Spark in Microsoft Fabric

Apache Spark is a core technology for large-scale data analytics. Microsoft Fabric provides support for Spark clusters, enabling you to analyze and process data at scale.

• Prepare to use Apache Spark
• Run Spark code
• Work with data in a Spark dataframe
• Work with data using Spark SQL
• Visualize data in a Spark notebook
• Exercise - Analyze data with Apache Spark
• Module assessment

Work with real-time data in an Eventhouse in Microsoft Fabric

Microsoft Fabric provides a scalable and flexible store for real-time data.

• Get started with an Eventhouse
• Use KQL effectively
• Materialized views and stored functions
• Exercise - Work with data in an Eventhouse
• Module assessment

Introduction to end-to-end analytics using Microsoft Fabric

Discover how Microsoft Fabric can meet your enterprise's analytics needs in one platform. Discover the capabilities Fabric has to offer, understand how it works, and identify how you can use Fabric for your analytics needs.

• Explore end-to-end analytics with Microsoft Fabric
• Explore data teams and Microsoft Fabric
• Enable and use Microsoft Fabric
• Module assessment

Get started with lakehouses in Microsoft Fabric

Lakehouses in Microsoft Fabric combine data lake flexibility with data warehouse analytics. Learn how to create, load, and query a lakehouse on a single platform.

• Describe lakehouse features and capabilities
• Ingest and transform data in a lakehouse
• Query and analyze lakehouse data
• Exercise - Create a Microsoft Fabric lakehouse
• Module assessment

Use Apache Spark in Microsoft Fabric

Apache Spark is a core technology for large-scale data analytics. Microsoft Fabric provides support for Spark clusters, enabling you to analyze and process data at scale.

• Prepare to use Apache Spark
• Run Spark code
• Work with data in a Spark dataframe
• Work with data using Spark SQL
• Visualize data in a Spark notebook
• Exercise - Analyze data with Apache Spark
• Module assessment

Work with Delta Lake tables in Microsoft Fabric

Tables in a Microsoft Fabric lakehouse are based on the Delta Lake technology commonly used in Apache Spark. By using the enhanced capabilities of delta tables, you can create advanced analytics solutions.

• Understand Delta Lake
• Create delta tables
• Optimize delta tables
• Work with delta tables in Spark
• Use delta tables with streaming data
• Exercise - Use delta tables in Apache Spark
• Module assessment

Ingest Data with Dataflows Gen2 in Microsoft Fabric

Data ingestion is crucial in analytics. Microsoft Fabric's Data Factory offers Dataflows for visually creating multi-step data ingestion and transformation using Power Query Online.

• Understand Dataflows Gen2 in Microsoft Fabric
• Explore Dataflows Gen2 in Microsoft Fabric
• Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
• Exercise - Create and use a Dataflow Gen2 in Microsoft Fabric
• Module assessment

Orchestrate processes and data movement with Microsoft Fabric

Use Data Factory pipelines in Microsoft Fabric

• Understand pipelines
• Use the Copy Data activity
• Use pipeline templates
• Run and monitor pipelines
• Exercise - Ingest data with a pipeline
• Module assessment

Organize a Fabric lakehouse using medallion architecture design

Explore the potential of the medallion architecture design in Microsoft Fabric. Organize and transform your data across Bronze, Silver, and Gold layers of a lakehouse for optimized analytics.

• Describe medallion architecture
• Plan a medallion architecture in Fabric
• Query and report on data in your Fabric lakehouse
• Secure and govern your medallion lakehouse
• Exercise - Organize your Fabric lakehouse using a medallion architecture
• Module assessment

Get started with Real-Time Intelligence in Microsoft Fabric

Real-Time Intelligence in Microsoft Fabric has capabilities that help you ingest, process, store, visualize, and act on data in motion to gain immediate insights from events as they happen.

• What is real-time data analytics?
• Real-Time Intelligence in Microsoft Fabric
• Ingest and transform real-time data
• Store and query real-time data
• Visualize real-time data
• Automate actions
• Exercise - Get started with Real-Time Intelligence in Microsoft Fabric
• Module assessment

Use Eventstream in Microsoft Fabric

Eventstream in Real-Time Intelligence (RTI) enables you to ingest, transform, and route real-time data.

• Components of Eventstream
• Eventstream sources and destinations
• Eventstream transformations
• Exercise - Ingest real-time data with Eventstream in Microsoft Fabric
• Module assessment

Work with real-time data in an Eventhouse in Microsoft Fabric

Microsoft Fabric provides a scalable and flexible store for real-time data.

• Get started with an Eventhouse
• Use KQL effectively
• Materialized views and stored functions
• Exercise - Work with data in an Eventhouse
• Module assessment

Create Real-Time Dashboards with Microsoft Fabric

Real-Time Dashboard is a capability in Microsoft Fabric that you can use to create interactive data visualizations.

• Get started with real-time dashboards
• Organize and filter dashboard data
• Dashboard management and optimization
• Exercise - Get started with real-time dashboards
• Module assessment

Use Activator in Microsoft Fabric

Fabric Activator is an event detection engine that automatically triggers actions when specific patterns or conditions are detected in data sources.

• Configure Activator for your data
• Create rules in Activator
• Configure actions in Activator
• Exercise - Use Activator in Fabric
• Module assessment

Introduction to end-to-end analytics using Microsoft Fabric

Discover how Microsoft Fabric can meet your enterprise's analytics needs in one platform. Discover the capabilities Fabric has to offer, understand how it works, and identify how you can use Fabric for your analytics needs.

• Explore end-to-end analytics with Microsoft Fabric
• Explore data teams and Microsoft Fabric
• Enable and use Microsoft Fabric
• Module assessment

Get started with data warehouses in Microsoft Fabric

Understand the key components and design considerations for implementation of data warehouses in Microsoft Fabric.

• Understand data warehouses
• Understand data warehouses in Fabric
• Query and transform data
• Model data in a warehouse
• Secure and monitor a warehouse
• Exercise - Create and query a warehouse
• Module assessment

Load data into a Microsoft Fabric data warehouse

Learn how to load data into a Microsoft Fabric warehouse using data pipelines, T-SQL, and Dataflow Gen2.

• Explore data load strategies
• Use data pipelines to load a warehouse
• Load data using T-SQL
• Load and transform data with Dataflow Gen2
• Exercise: Load data into a warehouse
• Module assessment

Query a data warehouse in Microsoft Fabric

Learn to query a Microsoft Fabric data warehouse using the SQL query editor, visual query editor, and SQL Server Management Studio.

• Query data
• Use the SQL query editor
• Explore the visual query editor
• Use client tools to query a warehouse
• Exercise: Query a data warehouse in Microsoft Fabric
• Module assessment

Get started with Copilot in Microsoft Fabric for Data Warehouse

Get started with Copilot in Microsoft Fabric for Data Warehouse

• Use Copilot code completion in Microsoft Fabric's Data Warehouse
• Use Copilot chat in Microsoft Fabric's Data Warehouse
• Use Copilot quick actions in Microsoft Fabric's Data Warehouse
• Review best practices using Copilot in Microsoft Fabric's Data Warehouse
• Exercise - Use Copilot in Microsoft Fabric data warehouse
• Module assessment

Monitor a Microsoft Fabric data warehouse

A data warehouse is a vital component of an enterprise analytics solution. It's important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.

• Monitor capacity metrics
• Monitor current activity
• Monitor queries
• Exercise - Monitor a data warehouse in Microsoft Fabric
• Module assessment

Secure a Microsoft Fabric data warehouse

Learn the key concepts and strategies for protecting sensitive data in Microsoft Fabric data warehouses.

• Explore dynamic data masking
• Implement row-level security
• Implement column-level security
• Configure SQL granular permissions using T-SQL
• Exercise: Secure a warehouse in Microsoft Fabric
• Module assessment

Implement continuous integration and continuous delivery (CI/CD) in Microsoft Fabric

Learn the key concepts and strategies for implementing continuous integration and continuous deployment (CI/CD) in Microsoft Fabric.

• Understand Continuous Integration and Continuous Delivery (CI/CD)
• Implement version control and Git integration
• Implement deployment pipelines
• Automate CI/CD using Fabric APIs
• Exercise: Implement deployment pipelines in Microsoft Fabric
• Module assessment

Monitor activities in Microsoft Fabric

Learn how to use the monitoring hub in Microsoft Fabric to track activity status, investigate failures, and view historical run data. Explore how Activator responds to Fabric job events with automated alerts and actions.

• Understand monitoring
• Use the Microsoft Fabric monitoring hub
• Respond to Fabric events with Activator
• Exercise - Monitor Fabric activity in the monitoring hub
• Module assessment

Secure data access in Microsoft Fabric

Implement workspace roles, item permissions, and OneLake security roles to control data access in Microsoft Fabric.

• Understand the Fabric security model
• Configure workspace and item permissions
• Apply granular permissions
• Exercise: Secure data access in Microsoft Fabric
• Module assessment