HomeStudy GuidesDashboardSign Inby Jitendra Singh Malik
Sign In
← All study guides

In-Depth Fabric Learning Path

Follow the topics in order to build your Microsoft Fabric knowledge from ingestion fundamentals to advanced real-time analytics for DP-700 and DP-600.

01Ingest and Transform DataBatch and streaming ingestion, Dataflows Gen2, pipelines, shortcuts, Spark, SQL, and KQL transformations.
02Lakehouse, Spark, and DeltaSpark pools, DataFrames, schemas, partitioning, Spark SQL, Delta tables, and medallion architecture.
03Streaming Data and Real-Time IntelligenceEventstreams, Eventhouse, KQL query patterns, materialized views, stored functions, and Activator.
04Warehouse and Dimensional ModellingWarehouse T-SQL, star schemas, loading strategies, analytical functions, and slowly changing dimensions.
05Monitor and Optimize an Analytics SolutionMonitor Fabric items, resolve ingestion and transformation errors, and optimize Lakehouse, Spark, SQL, and real-time workloads.
06Manage Security and GovernanceWorkspace and item access, row, column, object, and file controls, masking, labels, OneLake security, and auditing.
07Manage and Implement an Analytics SolutionWorkspace settings, Git, database projects, deployment pipelines, orchestration, security, governance, and exam scenarios.

Built by Jitendra Singh Malik

Not affiliated with or endorsed by Microsoft.