Write your first query with Kusto Query Language

Module
11 Units

Beginner

Data Scientist

Data Analyst

Business Analyst

Security Operations Analyst

Azure Data Explorer

Azure

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.

Learning objectives

By the end of this module, you'll be able to:

Write your first query with KQL.
Use KQL to explore data by using the most common operators.

Prerequisites

An Azure subscription; you can create a free Azure account
Familiarity with database structures like tables, columns, and rows

Introduction min
Understand the basic structure of a Kusto query min
Exercise - Connect to resources min
Exercise - Return a specific number of rows by using the take operator min
Exercise - Select columns to return by using the project operator min
Exercise - Filter data by using the where operator min
Exercise - Reorder returned data by using the sort operator min
Challenge min
Solution min
Knowledge check min
Summary min