Analyze monitoring data with Kusto Query Language

Beginner
Intermediate
Advanced
Business Analyst
Data Analyst
Data Engineer
Data Scientist
Developer
DevOps Engineer
Security Operations Analyst
Technology Manager
Azure
Azure Log Analytics
Azure Monitor
Azure Portal
Microsoft Sentinel
Microsoft Defender

Learn how to analyze data in Azure Monitor using Kusto Query Language (KQL).

Prerequisites

Familiarity with database structures like tables, columns, and rows.

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.