Analyze monitoring data with Kusto Query Language 

Introduction

Query language basics

KQL query environments

How a KQL query is built

Exercise: Sample queries

Types of KQL queries

Exercise: Different types of KQL queries

Knowledge check

Summary

Introduction

Understand the basic structure of a Kusto query

Exercise - Connect to resources

Exercise - Return a specific number of rows by using the take operator

Exercise - Select columns to return by using the project operator

Exercise - Filter data by using the where operator

Exercise - Reorder returned data by using the sort operator

Challenge

Solution

Knowledge check

Summary

Introduction

Group data using aggregate functions

Exercise - Connect to resources

Exercise - Count events using the count function

Exercise - Visualize data with the render operator

Exercise - Summarize data using aggregate functions

Exercise - Introduce variables using the let statement

Challenge

Solution

Knowledge check

Summary

Introduction

Combine and optimize data

Exercise - Connect to resources

Exercise - Combine table results by using the join operator

Exercise - Combine table results by using the lookup operator

Exercise - Combine table results by using the union operator

Exercise - Optimize queries by using the materialize function

Knowledge check

Summary

Introduction

Features of Azure Monitor logs

Create basic Azure Monitor log queries to extract information from log data

Exercise - Create basic Azure Monitor log queries to extract information from log data

Summary

Introduction

Prepare

Exercise - List recently active virtual machines that stopped sending logs

Exercise - Identify machines with high CPU usage

Exercise - Summarize free space statistics by computer

Knowledge check

Summary