Microsoft Fabric: beginner
Expertise:
- 6 Courses | 10h 26m 40s
- 20 Courses | 18h 43m
- 2 Courses | 2h 47m 27s
Explore Microsoft Fabric, an AI-powered end-to-end analytics and data platform designed for enterprises that require a unified solution.
GETTING STARTED
Microsoft Fabric: Working with Data Lakehouses
-
2m 9s
-
9m 6s
GETTING STARTED
Microsoft Fabric: Implementing Security in Fabric Warehouses
-
1m 38s
-
12m 40s
COURSES INCLUDED
Microsoft Fabric: Working with Data Lakehouses
Microsoft Fabric's OneLake includes a data lakehouse that combines some of the most attractive features of data warehouses and data lakes. Heavily leveraging Delta tables as well as Apache Spark, it also adds the power of Power BI and Power Query. In this course, you'll explore data warehouses, comparing them with Azure Data Lake and Amazon S3. You'll build your first data lakehouse in Microsoft Fabric, running T-SQL queries, exploring parquet files and the delta log. You'll write SQL queries, construct visual queries and work with Spark notebooks, using PySpark and SparkSQL. After that, you'll study the Delta Lake architecture and its implementation as Delta tables. You'll explore data ingestion, including data pipelines, dataflows, and Spark notebooks. Finally, you'll create visual queries from the SQL analytics endpoint, learn about query folding, work with M-language expressions, and create and customize Power BI reports. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.
17 videos |
2h 12m
Badge
Microsoft Fabric: Spark & the Capacity Metrics App for Lakehouses
Spark is a key technology on Fabric Lakehouses, and a fundamental part of the DP-600 test curriculum. In this course, you'll learn how Apache Spark integrates with Microsoft Fabric to handle large-scale data processing through distributed computing. First, learn about Spark pools and study the role of the T-SQL endpoint. Create Fabric shortcuts, set up storage accounts, enable hierarchical namespaces, and use Shared Access Signatures (SAS) to link these sources and build Delta tables from the connected data. Next, create notebooks with Apache Spark in Microsoft Fabric, run PySpark and SparkSQL commands, monitor resource usage and learn how to associate lakehouses with notebooks. Finally, explore the Microsoft Fabric Capacity Metrics App, tracking capacity units (CUs), managing SKUs, and handling overages and throttling. Complete the course by installing the app, entering your Fabric capacity ID, and using charts to analyze utilization metrics. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.
15 videos |
1h 57m
Assessment
Badge
Microsoft Fabric: Spark Configuration & Delta Tables
Spark is essential both in Microsoft Fabric and for the DP-600 certification test. In this course, you'll learn how to create Python scripts for Spark batch jobs in Fabric, writing ETL transformations and modifying them for batch execution. You'll configure and monitor Spark batch jobs, analyze job logs, use the Spark History Server, and learn how to schedule jobs with retry policies. Next, you'll configure starter pools and explore high concurrency sessions. You'll customize Spark settings in Fabric, and create custom Spark pools and environments, linking them to notebooks. After that, you'll focus on Delta tables, working with version history and table contents. You'll use the DESCRIBE HISTORY command to analyze table versions and explore time travel by viewing and restoring data to specific versions or timestamps with SparkSQL and PySpark. Finally, you'll explore the differences between managed and external Delta tables. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.
12 videos |
1h 47m
Badge
Microsoft Fabric: The Medallion Architecture with a Star Schema
The medallion architecture, which features bronze, silver, and gold layers, is a data organization approach and an important part of Microsoft Fabric and the DP-600 certification test. In this course, learn how the bronze layer stores raw data, the silver layer holds cleaned and transformed data, and the gold layer is for business-ready reporting and analytics. Begin by implementing the bronze layer. Create code for incremental data processing, perform data cleaning, and use merge and upsert operations with Spark Delta tables to load data into the Silver layer. Next, prepare the gold layer by using fact and dimension tables within a star schema. Transform silver layer data into the gold layer and create a semantic model that defines relationships between tables for use in Power BI reports. Finally, explore partitioning and table maintenance techniques and study the use of features like optimize, v-order, and vacuum. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.
10 videos |
1h 23m
Badge
Microsoft Fabric: Data Transformations Using Dataflow Gen2
Microsoft Fabric Data Factory is a powerful tool for integrating and orchestrating data workflows, enabling organizations to manage data efficiently. Dataflow Gen2 is an important component in Fabric Data Factory that focuses on transforming and managing data within those workflows, providing advanced capabilities for data cleaning and transformation. In this course, learn about Data Factory and Dataflow Gen2, beginning with building data flows using Power Query, cleaning data, replacing values, and applying essential mathematical transformations. Next, examine the fast copy Dataflow Gen2 feature, including when and why you would want to use fast copy. Finally, explore connectors for Dataflows Gen2 and incremental refresh techniques. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.
18 videos |
1h 54m
Assessment
Badge
Microsoft Fabric: Creating and Using Simple Data Pipelines
Data pipelines are an important component in Microsoft Fabric Data Factory that are crucial in automating and managing data workflows. In this course, learn the essentials of creating and using simple data pipelines and how various activities can be integrated within these pipelines. Next, discover how to enhance pipeline flexibility to build robust data workflows and configure a complete data pipeline by integrating components like notebooks, data flows, and email notifications. Finally, explore how to run the pipeline, monitor its performance, and set up alerts for successful completion and failures, ensuring efficient data management and responsiveness. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.
11 videos |
1h 10m
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Microsoft Fabric: Introducing Data Warehouses
What are data warehouses and how do they compare to data lakehouses? What are their key differences and when should you choose each of these storage technologies? In this course, you'll learn the answers to these questions while building hands-on experience. First, learn how warehouses handle structured data through T-SQL queries. Then, get hands-on with data ingestion to a warehouse. Upload data to Azure Data Lakehouse Storage Gen2, ingest it into a Fabric data warehouse using the COPY INTO command, and implement strategies to manage potential errors and maintain data integrity. Finally, dive into advanced data management, running T-SQL queries to perform DDL and DML operations in warehouses. Learn about database mirroring in Fabric, which allows data replication within external storage systems and gain a comprehensive understanding of secure and resilient data workflows in Fabric warehouses. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.
1h 49m
Assessment
Badge
COURSES INCLUDED
Microsoft Fabric: Implementing Security in Fabric Warehouses
Implementing security in Microsoft Fabric warehouses is crucial for protecting sensitive data from unauthorized access, data breaches, and cyberattacks. Additionally, a secure system fosters trust among stakeholders, ensures regulatory compliance, and safeguards the organization's reputation. In this course, learn essential security practices for safeguarding data in Fabric warehouses, beginning with assigning workspace roles, managing object-level permissions, and applying the principle of least privilege. Next, discover how to configure targeted security controls, implement column-level and row-level security, and apply dynamic data masking to protect sensitive information. Finally, explore advanced query constructs and how to choose the appropriate query construct for different use cases. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.
1h 54m
Assessment
Badge
Microsoft Fabric: Semantic Models and Semantic Link
Semantic modeling supports secure, optimized performance and empowers users to build accurate, dependable models for enterprise decision-making. In this course, learn how to create semantic models using lakehouse tables and explore how storage modes like Direct Lake and DirectQuery optimize performance while enabling real-time access to data. Next, explore how large semantic models help handle vast datasets for enterprise analytics and how security measures help ensure compliance with organizational and regulatory requirements. Finally, discover how to use semantic link in Fabric to identify relationships, detect violations, and analyze dependencies within models, and how to evaluate measures and understand calculation logic. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.
8 videos |
53m
Assessment
Badge
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE
Channel
Azure Development