Duration: 1 Day Course Code: DP-603 Course Delivery: Virtual (1-Day) GMT/Virtual (1-Day) PST Level: Beginner
Course Overview
In this learning path, the student is exposed to various ways to: • Source streaming data sources into Microsoft Fabric. • Use real time Eventstream in Microsoft Fabric. • Query data in a KQL database in Microsoft Fabric. • Create real time dashboards in Microsoft Fabric
Audience Profile
Course Objectives
After completing this course, students will be able to: • Get started with Real-Time Analytics in Microsoft Fabric • Use real time eventstreams in Microsoft Fabric • Query data in a KQL database in Microsoft Fabric
Prerequisites
The student should be able to: • Log in to the Azure portal. • Explain and create resource groups. • Understand the concept of streaming data.
Course Outline
Module 1: Get started with Real-Time Analytics in Microsoft Fabric+
Analysis of real-time data streams is a critical capability for any modern data analytics solution. In this module learn how to use the Real-Time Analytics capabilities of Microsoft Fabric to ingest, query, and process streams of data. Lessons
• Implement Real-Time Analytics with Microsoft Fabric • Introduction • What is Synapse Real-Time Analytics? • Understand KQL database and tables • Write queries with KQL • Exercise: Explore Synapse Real-Time Analytics in Fabric
After completing this module, students will be able to:
• Describe Real-Time Analytics in Microsoft Fabric • Create Real-Time Analytics databases and tables • Use KQL to query tables
Module 2: Use real time event streams in Microsoft Fabric+
This module is an introduction to the Microsoft Fabric Eventstream within Real-Time Analytics (RTA) Lessons
• Introduction • Main components of Eventstream • Setting up Eventstream • Routing eventstream data • Exercise - Load data into a KQL database using Microsoft Fabric Eventstream After completing this module, students will be able to:
• Establish source and destinations in Eventstream • View the data in-flight in eventstream items • Capture, transform, and route data using Eventstream
Module 3: Query data in a KQL database in Microsoft Fabric+
This module provides a brief introduction to KQL (Kusto Query Language) queries using Querysets and the major differences between KQL and T-SQL when using Querysets.
Lessons
• Introduction • Get started with KQL queries • KQL best practices • Advanced features • Exercise - query a KQL database in Microsoft Fabric After completing this module, students will be able to:
• Use basic syntax and of Kusto Query Language (KQL). • Understand the basics of the Queryset canvas. • Describe how to execute T-SQL queries in the Queryset canvas. • Describe how to convert T-SQL queries into KQL queries.
Book this Course
If you have any questions or are looking for customised training for you or your team, please contact us
Exam Information