8420  Reviews star_rate star_rate star_rate star_rate star_half

Architecting End-to-End Data Solutions with Fabric

In this Fabric training course, participants explore the capabilities and features of Microsoft Fabric, a unified data platform designed for building scalable, secure, and high-performance data...

Read More
By Request
Contact Us For Pricing
Duration 1 day
Course Code WA3771
Available Formats Classroom

Overview

In this Fabric training course, participants explore the capabilities and features of Microsoft Fabric, a unified data platform designed for building scalable, secure, and high-performance data solutions. The course covers essential components of Fabric, including databases, data engineering, data warehouses, data factories, real-time intelligence, and data science. Participants learn how to manage and architect data solutions using SQL databases, Spark jobs, Lakehouses, Data Factory pipelines, EventStream for real-time analytics, and machine learning models. By the end of the training, participants will be equipped to design and deploy comprehensive data architectures with Microsoft Fabric.

Skills Gained

  • Understand the core components and architecture of Microsoft Fabric
  • Work with databases, data engineering, and data warehouse technologies within Fabric
  • Design data pipelines using Data Factory and integrating real-time analytics tools
  • Explore machine learning workflows and data science capabilities in Microsoft Fabric
  • Implement governance, security, and compliance measures in Fabric architectures

Prerequisites

  • Familiarity with cloud technologies and data platforms.
  • Experience with data integration and analytics tools.
  • Basic knowledge of Microsoft Azure services is useful but not necessary.

Course Details

Introduction to Microsoft Fabric

  • Overview of Microsoft Fabric and its role in modern data architectures
  • Key components of Fabric: SQL databases, Data Engineering, Data Warehouses, Data Factory, Real-time Intelligence, and Data Science
  • Architecture of Fabric and its integration with Azure services
  • Overview of Fabric’s interface and tools for architects
  • The role of architects in designing and managing scalable, secure data solutions using Fabric

Databases in Microsoft Fabric

  • Working with SQL databases in Microsoft Fabric
  • Introduction to managing SQL Server instances within Fabric
  • Configuring mirrored databases for fault tolerance and high availability
  • Best practices for managing large-scale databases and ensuring high performance within Fabric

Data Engineering: Lakehouses and Spark Jobs

  • Overview of the Lakehouse architecture within Microsoft Fabric
  • Setting up and managing Lakehouses for unified data storage and analytics
  • Working with Spark Job definitions for large-scale distributed data processing
  • Creating data pipelines for batch and real-time data processing
  • Using APIs for GraphQL to automate and manage data workflows in Fabric

Data Warehouse Management in Microsoft Fabric

  • Introduction to Data Warehouses within Fabric
  • Configuring Dataflow Gen2 for optimizing ETL/ELT processes in Data Warehouses
  • Managing mirrored Azure SQL databases, Databricks catalogs, and Snowflake integration
  • Best practices for building hybrid data warehousing solutions with Fabric
  • Ensuring data consistency, performance, and security across Data Warehouses

Data Factory: Pipelines and Dataflows

  • Overview of Data Factory and its capabilities for data orchestration
  • Using Dataflow Gen2 for large-scale data transformation and processing
  • Designing and configuring data pipelines for automated data movement
  • Creating copy jobs for replicating data across different environments
  • Integrating Data Factory with other Fabric components for efficient workflows

Real-time Intelligence in Microsoft Fabric

  • Introduction to EventStream for real-time data ingestion and processing
  • Building and managing real-time dashboards with live data updates
  • Writing and executing KQL queries for real-time analytics
  • Using Activators to trigger actions based on real-time data events
  • Integrating EventStream with Data Factory and Data Lake for seamless real-time analytics

Data Science and AI in Microsoft Fabric

  • Overview of data science capabilities in Fabric
  • Creating and deploying machine learning models within Fabrics Data Science environment
  • Using notebooks for data experimentation, model building, and testing
  • Using AI skill to create conversational AI experience to interact with data
  • Implementing Python notebooks for advanced data manipulation and model training
Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information
Ascendient Learning would like to occasionally share news about our services and career opportunities via e-mail when we believe it would be relevant to you. Would you like to opt-in to these communications? You may withdraw your consent at any time using the opt-out/preferences link in the emails sent.

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

I liked the pace of the course. I like that I have more than instance to use the lab.

Very interactive and in-depth course that really got me ready for the industry

Class was easy to sign up for and ExitCertified provided very good communication

Quick to sign-up to course, and was able to garner some information from the course.

Very good company. I've done technical trainings at their facility in downtown Montreal in the past and I'Ve always appreciated them.