Home / Blog / Career and Certs

Beginner 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

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.

  1. Evening 1: read the overview, then follow the first part of the common operators tutorial. Keep the quick reference open.
  2. Evening 2: type this query yourself and change one thing at a time, such as the state or the number in take.
  3. 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

Keep going

More in Career and Certs

BeginnerCareer and Certs

How to Build a Home SOC Lab with Free Tools

A beginner friendly plan for a home SOC lab using Windows evaluation builds, Sysmon, a free SIEM and Atomic Red Team, plus how to turn it into interview evidence.

7 Nov 20267 min read