Analyze monitoring data with Kusto Query Language
Learn how to analyze data in Azure Monitor using Kusto Query Language (KQL).
Prerequisites
Familiarity with database structures like tables, columns, and rows.
Achievement Code
Would you like to request an achievement code?
Modules in this learning path
Learn about the basics of Kusto Query Language (KQL), and the various Microsoft products that use it.
Get started by writing simple queries in Kusto Query Language (KQL) to explore and gain insights from your data. Learn how to use the operators take
, project
, where
, count
, sort
, and others.
Write advanced queries in Kusto Query Language to help you gain insights from your data. Use the aggregation functions count
, dcount
, countif
, sum
, min
, max
, avg
, percentiles
, and others. Communicate these results visually in charts.
Write advanced queries in Kusto Query Language to gain deeper insights by combining data from several tables. Learn how to use the table-level operators lookup
, join
, union
, and materialize
, and the new aggregation functions arg_min
and arg_max
. Also, learn how to communicate these results visually in charts.
Use Azure Monitor logs to extract valuable information about your infrastructure from log data.
Write log queries to find answers to operational and business questions. Use Kusto Query Language (KQL) to extract insights from logs in Azure Monitor.
Note
This is a Guided Project module where you complete an end-to-end project by following step-by-step instructions.