Microsoft Fabric: Implementing Security in Fabric Warehouses

Microsoft Fabric    |    Intermediate
  • 17 videos | 1h 54m 15s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 5 users Rating 4.4 of 5 users (5)
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.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Identify security features that can be used to protect data in warehouses
    Share a workspace with another user using a specific workspace role
    Grant, deny, and revoke access to tables using sql commands
    Use the principle of least privilege to grant execution rights on stored procedures but deny access to the underlying table
    Configure column-level security on warehouse tables
    Configure row-level security using a security predicate and a security policy
    Execute operations supported by row-level security
    Alter an existing row-level security policy
  • Use different masking techniques to mask data in tables
    View unmasked data using grants and the contributor role on a workspace
    Outline advanced query constructs such as views, stored procedures, udfs, and dynamic queries
    Create and query views in fabric warehouses
    Create and invoke functions in fabric warehouses
    Create and execute stored procedures in fabric warehouses
    Construct and execute dynamic parameterized queries using sp_executesql and the exec command
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 38s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 12m 40s
    Upon completion of this video, you will be able to identify security features that can be used to protect data in warehouses. FREE ACCESS
  • Locked
    3.  Assigning Workspace Roles
    10m
    Discover how to share a workspace with another user using a specific workspace role. FREE ACCESS
  • Locked
    4.  Using GRANT, DENY, and REVOKE to Manage Object-Level Permissions
    6m 31s
    In this video, you will learn how to GRANT, DENY, and REVOKE access to tables using SQL commands. FREE ACCESS
  • Locked
    5.  Adhering to the Principle of Least Privilege
    6m 9s
    In this video, find out how to use the principle of least privilege to grant execution rights on stored procedures but deny access to the underlying table. FREE ACCESS
  • Locked
    6.  Configuring Column-Level Security
    7m 37s
    During this video, discover how to configure column-level security on warehouse tables. FREE ACCESS
  • Locked
    7.  Configuring Row-Level Security
    11m 16s
    Learn how to configure row-level security using a security predicate and a security policy. FREE ACCESS
  • Locked
    8.  Executing Operations Supported When Row-Level Security Is Applied
    6m 5s
    Find out how to execute operations supported by row-level security. FREE ACCESS
  • Locked
    9.  Altering Row-Level Security
    5m 6s
    In this video, discover how to alter an existing row-level security policy. FREE ACCESS
  • Locked
    10.  Applying Dynamic Data Masking
    11m 39s
    During this video, you will learn how to use different masking techniques to mask data in tables. FREE ACCESS
  • Locked
    11.  Viewing Unmasked Data as a Contributor
    3m 47s
    In this video, find out how to view unmasked data using grants and the Contributor role on a workspace. FREE ACCESS
  • Locked
    12.  Advanced Query Constructs in Warehouses
    9m 52s
    After completing this video, you will be able to outline advanced query constructs such as views, stored procedures, UDFs, and dynamic queries. FREE ACCESS
  • Locked
    13.  Creating and Querying Views in Warehouse Tables
    4m 18s
    Learn how to create and query views in Fabric warehouses. FREE ACCESS
  • Locked
    14.  Creating and Invoking Functions in Warehouse Tables
    5m 33s
    During this video, discover how to create and invoke functions in Fabric warehouses. FREE ACCESS
  • Locked
    15.  Creating and Executing Stored Procedures in Warehouse Tables
    4m 55s
    In this video, find out how to create and execute stored procedures in Fabric warehouses. FREE ACCESS
  • Locked
    16.  Constructing and Executing Dynamic Queries in Fabric
    5m 18s
    Discover how to construct and execute dynamic parameterized queries using sp_executesql and the EXEC command. FREE ACCESS
  • Locked
    17.  Course Summary
    1m 52s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Course Certified in Cybersecurity (CC): Data Security & System Hardening
Rating 4.4 of 17 users Rating 4.4 of 17 users (17)
Course Certified in Cybersecurity (CC): Incident Response
Rating 4.6 of 91 users Rating 4.6 of 91 users (91)
Course Information Security for Leaders: Elements of InfoSec
Rating 4.6 of 5 users Rating 4.6 of 5 users (5)