Skip to main content

KQL (Kusto): Advanced Queries

Learn about advanced KQL queries and how to leverage the power of Microsoft KQL.

Task 1: Introduction

Task 2: Using the Join Operator

Task 3: Using the Union Operator

Task 4: Using the Project Operator

Task 5: Using the Extend Operator

Task 6: Using the Parse Operator

Task 7: Lab Instructions

Task 8: Creating KQL Parsers

Task 9: Lab-02: Discover

Task 10: Conclusion

Back to all walkthroughs
Room Icon

KQL (Kusto): Advanced Queries

Max room.

Learn about advanced KQL queries and how to leverage the power of Microsoft KQL.

medium

60 min

656

User profile photo.
User profile photo.

To access material, start machines and answer questions login.

This room is a continuation of the (Kusto): Basic Queries room. However, we will discuss advanced KQL queries, and, as before, we will run as many queries as possible to ensure you are familiar with the different KQL operators and functions for threat analysis. Basic KQL queries provide a good foundation for security analysis in Microsoft Sentinel, but for in-depth threat hunting and incident investigation, advanced KQL knowledge is required.

Prerequisites

Learning Objectives

  • How to use the join operator
  • How to use the union operator
  • How to use the project operator
  • How to use the extend operator
  • How to create parsers and use the parse operator
Answer the questions below
I am ready to go advanced!