Kusto Query Language (KQL) Overview

In this video

0:00 - Introduction

5:25 - Basics of KQL

11:29 - Pipe character and sending output to commands

14:29 - Bags and looking at child elements

20:09 - Summarize and new generated columns

25:04 - Searching for specific data and visualizations

29:05 - Joining tables and types of join

45:50 - Removing columns and renaming and other compares

50:00 - Working with dates and a new column

57:00 - Resource graph example

1:02:40 - Summary and close

More about

Tutorial: Use Kusto queries

The best way to learn about the Kusto Query Language is to look at some basic queries to get a "feel" for the language. We recommend using a database with some sample data. The queries that are demonstrated in this tutorial should run on that database. The StormEvents table in the sample database provides some information about storms that happened in the United States.

https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/tutorial?pivots=azuredataexplorer

Kusto Query Language (KQL) overview

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.

https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/

Kusto 101 – A Jumpstart Guide to KQL

Got the basics down and ready to move on to more advanced aspects of Kusto? You’ve come to the right place! Here you will learn how to use aggregation functions, visualize query results, and put your data into context. If you’re just getting started with Kusto, check out our ‘Jumpstart Guide to Kusto’ before starting on this one. Let’s get into visualizing data with Kusto!

https://squaredup.com/blog/kusto-101-a-jumpstart-guide-to-kql/