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
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.
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.
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!