Hands On- Kusto Query Language(KQL)

Hands On: Kusto Query Language(KQL), available at $34.99, has an average rating of 2.9, with 19 lectures, based on 5 reviews, and has 32 subscribers.

You will learn about Understand What Kusto Query Language and where it is used Understand Kusto Query Language Commands, Statement, Clause Combining all Commands, Statements for a Use Case based understanding Learn how to leverage Sentinel, MDC & Log Analytics Effectively This course is ideal for individuals who are Cloud Security or Microsoft SIEM & SOAR or SOC Engineers It is particularly useful for Cloud Security or Microsoft SIEM & SOAR or SOC Engineers.

Enroll now: Hands On: Kusto Query Language(KQL)

Summary

Title: Hands On: Kusto Query Language(KQL)

Price: $34.99

Average Rating: 2.9

Number of Lectures: 19

Number of Published Lectures: 18

Number of Curriculum Items: 19

Number of Published Curriculum Objects: 18

Original Price: $24.99

Quality Status: approved

Status: Live

What You Will Learn

Understand What Kusto Query Language and where it is used

Understand Kusto Query Language Commands, Statement, Clause

Combining all Commands, Statements for a Use Case based understanding

Learn how to leverage Sentinel, MDC & Log Analytics Effectively

Who Should Attend

Cloud Security

Microsoft SIEM & SOAR

SOC Engineers

Target Audiences

Cloud Security

Microsoft SIEM & SOAR

SOC Engineers

In this Hands On: Kusto Query Language course we will do hands on KQL and understand various Commands, Clauses, Statements to build a good Foundation.

KQL has many Applications Across Microsoft Sentinel, Micrsoft Defender for Cloud, Azure Data Explorer and it enables in Querying the Data which is Stored in Log Analytics Workspace.

We Will start from Portal Walkthrough provisioned by MS for practicing KQL effectively, we will start with basic commands like getSchema, let, print, and will reach to complex aspect of join, union, data tables, mv-expand, Aggregate functions.

We will understand case-sensitive and case-insensitive aspect of KQL and how commands can be Molded respectively for querying data from Log Analytics.

Kusto Query Language is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modeling, and more. The query uses schema entities that are organized in a hierarchy similar to SQL’s: databases, tables, and columns.

A Kusto query is a read-only request to process data and return results. The request is stated in plain text, using a data-flow model that is easy to read, author, and automate. Kusto queries are made of one or more query statements.

Brief on What we will do Hands on KQL in this Course:

1. Kusto Query Language

2. KQL LA demo Continued( Schema, Workflow of a Query, Pipe Operator)

3. KQL Operator Search

4. KQL Operator Where

5. KQL Operator distinct,summarize

6. KQL Operator sort,ago

7. KQL Operator iif,strcat,case

8. KQL Operator arg_max,arg_min,Count,mv-expand

9. KQL Operator join,range,union,Custom log creation

10.Kusto Rookie

11. Updating..

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: 2. KQL LA demo Continued (Schema, Workflow of a Query, Pipe Operator)

Chapter 2: KQL Operators

Lecture 1: KQL Operator _ Search

Lecture 2: KQL Operator _Where

Lecture 3: KQL Operator Distinct, Summarize Other

Lecture 4: KQL Operator Sort, Ago & Other

Lecture 5: KQL Operator iif,strcat,case

Lecture 6: KQL Operator arg_max,arg_min,Count,mv-expand

Lecture 7: KQL Operator join,range,union,Custom log creation

Chapter 3: Kusto Detective

Lecture 1: Whats Expected from you

Lecture 2: Kusto Detective & Introduction

Lecture 3: Kusto Lieutenant

Chapter 4: KQL Ninja

Lecture 1: Lab Introduction

Lecture 2: Lab Setup and Introduction

Lecture 3: KQL Fundamentals and Data Exploration

Lecture 4: KQL Searching and Filtering Data

Lecture 5: KQL Joins

Lecture 6: Aggregating Data

Instructors

Vipul Dabhi
Cybertellisense

Rating Distribution

1 stars: 2 votes

2 stars: 1 votes

3 stars: 0 votes

4 stars: 0 votes

5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!