Home / Blog / Career and Certs
Free Places to Learn KQL: A Beginner Resource List
A short, annotated list of Microsoft Learn courses, a detective game and a community repo for learning KQL, with a simple plan for using them this week.
Kusto Query Language (KQL) is the language you use to ask questions of logs in Microsoft Sentinel and Microsoft Defender. This list points to places to learn it, with a note on who each one suits and what the page says about cost.
Too many tabs, not enough practice
Search for "learn KQL" and you get dozens of courses, videos and blog posts. Beginners often open ten tabs, read a bit of each and never run a single query.
- Some resources assume you already know SQL (Structured Query Language).
- Some need a Sentinel workspace you may not have.
- Some are paid, and it is not always obvious before you click.
The list below is short on purpose. Every link was opened and checked while writing this. Cost notes only repeat what each page says, so check the current price before you sign up for anything.
Start here
- Kusto Query Language overview: Microsoft's landing page. It explains that queries are steps joined by the pipe character (|). Suits: absolute beginners. Cost: no price stated, it is documentation.
- Tutorial: Learn common operators: covers count, take, project, distinct, where, sort, top and extend on a sample table called StormEvents. Suits: first hands-on session. Cost: no price stated, but you sign in with a Microsoft account or Microsoft Entra identity.
- KQL quick reference: one page listing common operators with a short description each. Suits: keeping open while you practise. Cost: no price stated.
Practise
- Kusto Detective Agency: a game where you solve data investigation puzzles using KQL. Suits: learners who get bored with plain tutorials. Cost: the page does not mention pricing.
- Construct KQL statements for Microsoft Sentinel: a Microsoft Learn module, listed as intermediate, about 36 minutes, covering search, where, let, extend, order by and project. Suits: people heading toward Sentinel work. Cost: the page does not state it.
- Create queries for Microsoft Sentinel using KQL: a four module learning path. Suits: a structured route after the basics. Cost: the page says you need an Azure account and mentions an Azure free trial of up to 30 days.
Go deeper
- Work with data in Microsoft Sentinel using Kusto Query Language: extracting data from string fields and creating functions. Suits: once simple filters feel easy. Cost: not stated on the page.
- Must Learn KQL on GitHub: a community repository of queries, datasets and workshop material. Suits: self-paced learners. Cost: the code is free under an MIT licence, and the page also mentions optional paid books.
- KQL learning resources from Microsoft: a curated list of more courses and tools. Suits: finding your next step. Cost: it varies by resource and the page mostly does not say.
Using this list this week
This is an illustrative practice plan with made up details, not a real incident. Suppose you have 20 minutes after work on three evenings.
- Evening 1: read the overview, then follow the first part of the common operators tutorial. Keep the quick reference open.
- Evening 2: type this query yourself and change one thing at a time, such as the state or the number in take.
- Evening 3: start Kusto Detective Agency and write down every operator you use.
StormEvents
| where State == "TEXAS"
| summarize Events = count() by EventType
| sort by Events desc
| take 5
- Line 1 names the table, which is the sample data used in the tutorial.
- Line 2 keeps only rows for one state.
- Line 3 counts rows for each event type.
- Line 4 puts the biggest count first.
- Line 5 keeps the top five rows.
At the end of the week, pick one Microsoft Learn module from the Practise section and put it on your calendar. One small habit beats ten bookmarks.
Written by Ben, Cybersecurity Student, member of Cyber Talent Incubator Network (CTIN) Cohort