Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
DP-700 Microsoft Fabric Data Engineer Associate Course
Rating: 4.3 out of 5(16 ratings)
941 students

DP-700 Microsoft Fabric Data Engineer Associate Course

13+ REAL End-to-End Fabric Data Engineer IT Projects | 100+ High-Quality Practice Questions with VIDEO Explanation !
Created byCloud Guru Amit
Last updated 4/2026
English
English [Auto],

What you'll learn

  • Implement dynamic data masking in Azure SQL Database with hands-on projects.
  • Create and configure Azure SQL Database and Azure SQL Server from scratch.
  • Master Kusto Query Language (KQL) through demonstrations using Azure Data Explorer.
  • Solve practice test exam questions with video explanations for all answers.

Course content

6 sections128 lectures11h 8m total length
  • Fabric Workspace1:26

    Today let's learn about what is Fabric Workspace in Microsoft Fabric.

  • Spark Workspace1:14

    Today let's learn about what is Spark Workspace in Microsoft Fabric.

  • Spark Workspace Hands on13:40
  • Domain Workspace1:21

    Explore domain workspace by viewing a company as a city where domains host workspaces containing data, assets, pipelines, and reports, governed by rbac, sensitivity labels, and governance.

  • Domain Workspace Hands on2:28
  • OneLake workspace1:23

    Discover one lake workspace, a central data reservoir that unifies departments and enables access to governance-ready data via spark sql or power bi, with adls or s3 integration and rbac.

  • OneLake Hands on1:52
  • Data workflow settings1:08
  • Dataflow Gen2 Workflow Hands on15:19
  • Version control1:32

    Master version control as a time machine for data projects by saving snapshots, tracking changes to notebooks, data flows, and pipelines, and showing who changed what and when.

  • Version control Hands on10:41

    Explore hands-on version control in fabric workspace by linking Azure DevOps, creating a repo, committing report changes, and syncing in the same region with main and feature branches.

  • Database Project1:10

    Learn how database projects act as architectural blueprints for tables, views, procedures, and relationships, with versioning, validation, and deployment across environments using git integration in Microsoft Fabric.

  • Database Project Hands on4:51

    Create a warehouse in fabric, load sample data, and run SQL queries on the weather table.

  • Deployment Pipelines1:02
  • Workspace-level access controls1:06

    Understand workspace level access control in Fabric: admins have master keys, members and contributors can edit, only members can share, and viewers observe securely.

  • Workspace-Level Access Controls Hands on3:52

    Learn workspace level access control in Microsoft Fabric by assigning admin, contributor, and viewer roles to secure datasets, reports, and pipelines within a workspace, following the least privilege principle.

  • Item-level access controls1:01
  • Item-level Access Control Hands on4:23

    Implement item level access control in Power BI by creating a report from input data and sharing the dashboard with stakeholders, managing permissions to hide raw data. Remove access.

  • Row-level access controls1:03

    Explore row-level access control by applying filters so regional managers see their region while the CEO sees all, using DAX or security rules in Microsoft Fabric.

  • Column-level access controls1:03

    Explore column-level access control to restrict who views columns, with HR seeing salary and age, using Microsoft Fabric with Dax or sensitivity labels to hide private data from unauthorized users.

  • Object-level access controls1:01

    Define object level access control within a semantic model to restrict who views tables, columns, and measures, using DAX and model settings in Microsoft Fabric.

  • File-level access controls0:58

    Assign permissions to individual files in Microsoft Fabric, controlling who can view or edit each locked drawer. Protect sensitive content while enabling secure collaboration across teams.

  • File-level Access Control Hands on4:35

    Implement file level security using workspace permissions in Fabric or Power BI, creating separate finance and sales workspaces, assigning contributor roles, and restricting access to each team's reports.

  • Dynamic data masking1:20

    Understand dynamic data masking in Microsoft Fabric, which hides sensitive fields from unauthorized users while keeping data intact, applied at query time on the SQL analytics endpoint or warehouse.

  • Sensitivity labels1:00

    Learn how sensitivity labels act as digital tags that classify data, flagging confidential information, while in Microsoft Fabric they travel with data and trigger protections like encryption and masking.

  • Endorsements0:54
  • Endorsement Hands on2:02
  • Pipelines vs Notebooks1:03

    Compare pipelines and notebooks in Microsoft Fabric: pipelines automate and schedule data workflows visually, while notebooks support interactive data exploration and transformation using Spark and Python.

  • Schedules & Event-Based Triggers1:12
  • Schedules & Event-Based Triggers Hands on16:11
  • Orchestration with Parameters & Expressions1:08

    Orchestrate data workflows in Microsoft Fabric using parameters and dynamic expressions to load daily folders, check existence, and decide to proceed or skip, enabling reusable workflows that adapt to inputs.

Requirements

  • Basic knowledge of SQL and database management systems.

Description

Unlock your potential as a data engineer with our comprehensive course, "DP-700 Microsoft Fabric Data Engineer Associate Course." Designed and delivered by Cloud Guru Amit, this course offers an end-to-end hands-on learning experience that covers essential topics to help you excel in your data engineering career.


In this course, you will:


  • Implement Dynamic Data Masking: Learn how to secure sensitive data in Azure SQL databases by applying dynamic data masking techniques.

  • Create Azure SQL Databases & Servers: Gain expertise in creating and configuring Azure SQL databases and servers from scratch, with a focus on best practices and networking.

  • Kusto Query Language (KQL) Demonstrations: Dive into KQL with hands-on demonstrations using Azure Data Explorer, mastering powerful data querying and analytics.

  • Interactive Practice Tests: Access 100+ practice test questions with video explanations for each correct and incorrect answer. Leverage the method of elimination backed by Microsoft documentation to ensure you understand the rationale behind each answer.

By the end of this course, you will have the skills and knowledge to implement data engineering solutions using Microsoft Fabric, and you will be well-prepared for the DP-700 certification exam. Whether you're an aspiring data engineer, a database administrator, or an IT professional, this course will provide you with the tools and confidence to succeed in your career.

Join us and take the first step towards becoming a certified data engineer with Microsoft Fabric!

Who this course is for:

  • Aspiring Data Engineers: Individuals looking to build a strong foundation in data engineering and seeking to gain hands-on experience with Microsoft Fabric.
  • Database Administrators: Professionals who want to enhance their skills in Azure SQL Database and data engineering solutions.
  • Data Analysts: Those who wish to expand their knowledge of data processing, querying, and analytics using Azure Data Explorer and Kusto Query Language (KQL).
  • IT Professionals: Individuals aiming to transition into data engineering roles or add data engineering skills to their toolkit.
  • Developers: Software developers looking to understand data engineering principles and best practices in a cloud environment.
  • Students and Graduates: Learners from technical and engineering backgrounds who aspire to become certified data engineers.
  • Tech Enthusiasts: Anyone passionate about data and interested in exploring the capabilities of Azure for implementing data engineering solutions.