Kusto Query Language (KQL) Tutorial

Kusto Query Language (KQL) Tutorial Series

Getting Started & Setup

1. Install Azure Data Explorer & Start Writing Queries
2. Tools to Connect to Azure Data Explorer
3. Database Management Commands in KQL

Table Management

1. Data Types & Create Table
2. Add/Remove Columns
3. Use Docstring for Metadata
4. Move Tables to Folders
5. Create Empty Table from Existing Table
6. Create, Drop, Rename Table
7. Create Multiple Tables in One Statement
8. List Tables & Schema
9. Recover Dropped Table
10. Clear Table Data

Column Operations

1. Change Column Data Type
2. Drop Columns
3. Rename Column

Basic Queries

1. Select Data
2. WHERE Clause
3. String Functions
4. Search Operator
5. Count Operator

Filtering, Sorting & Aggregations

1. Limit/Take Operator
2. Find Operator
3. Sort Operator
4. Top N Records
5. Extend for Calculated Columns
6. Summarize & Aggregate Functions

Joins, Unions & Set Logic

1. Join Types (Inner, Left, Right, Full)
2. Union Operator

Advanced Functions & Techniques

1. Print Operator
2. Ago & Now Functions
3. Next Function
4. Parse Operator
5. dccount() Estimate Function
6. Using LET in Queries
7. Lookup Operator
8. Cross Cluster/DB Queries