Course Outline
1 - Ingest Data with Dataflows Gen2 in Microsoft Fabric
- Understand Dataflows Gen2 in Microsoft Fabric
- Explore Dataflows Gen2 in Microsoft Fabric
- Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
2 - Orchestrate processes and data movement with Microsoft Fabric
- Understand pipelines
- Use the Copy Data activity
- Use pipeline templates
- Run and monitor pipelines
3 - Get started with Real-Time Intelligence in Microsoft Fabric
- 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
4 - Use real-time eventstreams in Microsoft Fabric
- Components of eventstreams
- Eventstream sources and destinations
- Eventstream transformations
5 - Work with real-time data in a Microsoft Fabric eventhouse
- Get started with an eventhouse
- Use KQL effectively
- Materialized views and stored functions
6 - Introduction to end-to-end analytics using Microsoft Fabric
- Explore end-to-end analytics with Microsoft Fabric
- Data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
7 - Get started with lakehouses in Microsoft Fabric
- Explore the Microsoft Fabric lakehouse
- Work with Microsoft Fabric lakehouses
- Explore and transform data in a lakehouse
8 - Use Apache Spark in Microsoft Fabric
- 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
9 - Work with Delta Lake tables in Microsoft Fabric
- Understand Delta Lake
- Create delta tables
- Optimize delta tables
- Work with delta tables in Spark
- Use delta tables with streaming data
10 - Organize a Fabric lakehouse using medallion architecture design
- Describe medallion architecture
- Implement a medallion architecture in Fabric
- Query and report on data in your Fabric lakehouse
- Considerations for managing your lakehouse
11 - Create Real-Time Dashboards with Microsoft Fabric
- Get started with real-time dashboards
- Advanced features
- Real-Time Dashboard best practices
12 - Get started with data warehouses in Microsoft Fabric
- Understand data warehouse fundamentals
- Understand data warehouses in Fabric
- Query and transform data
- Prepare data for analysis and reporting
- Secure and monitor your data warehousev
13 - Load data into a Microsoft Fabric data warehouse
- Explore data load strategies
- Use data pipelines to load a warehouse
- Load data using T-SQL
- Load and transform data with Dataflow Gen2
14 - Query a data warehouse in Microsoft Fabric
- Query data
- Use the SQL query editor
- Explore the visual query editor
- Use client tools to query a warehouse
15 - Monitor a Microsoft Fabric data warehouse
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
16 - Secure a Microsoft Fabric data warehouse
- Explore dynamic data masking
- Implement row-level security
- Implement column-level security
- Configure SQL granular permissions using T-SQL
17 - Implement continuous integration and continuous delivery (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
18 - Monitor activities in Microsoft Fabric
- Understand monitoring
- Use Microsoft Fabric Monitor Hub
- Take action with Microsoft Fabric Activator
19 - Secure data access in Microsoft Fabric
- Understand the Fabric security model
- Configure workspace and item permissions
- Apply granular permissions
20 - Administer a Microsoft Fabric environment
- Understand the Fabric Architecture
- Understand the Fabric administrator role
- Manage Fabric security
- Govern data in Fabric
Target Audience