
KQL for Azure Admins
Course Overview
Course Content
6 modules · 17 topics01Module 1: Introduction to KQL3 topics
- Introduction to KQL commands
- Understanding of syntax
- Running KQ queries
02Module 2: Analyze query results using KQL3 topics
- Summarize Operator uses
- Summarize Operator to filter results
- Summarize Operator to prepare data
03Module 3: Build Multi-Table Statements using KQL2 topics
- Union Operator uses
- Join Operator uses
04Module 4: Construct KQL Statements for Microsoft Sentinel4 topics
- Understand the KQL language statement structure
- Let statement uses
- Search operator use
- Extend operator uses
05Module 5: Write your first query with KQL3 topics
- Understand the basic structure of a KQ
- Select column to return by using the project operator
- Reorder return data by using the sort operator
06Module 6: Export data using KQL2 topics
- Export to csv files
- Export to Power BI
Schedule Dates
4 upcoming batches| Batch Dates | Duration | Batch Options | Language | Action |
|---|---|---|---|---|
| 28 December 2026 - 29 December 2026 | 2 Days | 8 hours & 4 hours | English / Arabic | |
| 29 March 2027 - 30 March 2027 | 2 Days | 8 hours & 4 hours | English / Arabic | |
| 05 July 2027 - 06 July 2027 | 2 Days | 8 hours & 4 hours | English / Arabic | |
| 11 October 2027 - 12 October 2027 | 2 Days | 8 hours & 4 hours | English / Arabic |
Can’t find a suitable date? Request a schedule that fits your team.
Request More InformationFAQs
What is KQL, and why is it important for Azure admins?
Kusto Query Language (KQL) is a powerful query language used to explore and analyze large datasets stored in Azure services. It is essential for Azure administrators because it enables efficient data management, analysis, and visualization, which are critical for monitoring and optimizing Azure resources.
What are the prerequisites for this course?
Basic knowledge of Azure services and familiarity with general database concepts are recommended. However, the course starts with foundational topics, making it accessible to those new to KQL.
How is the course structured?
The course is structured into modules, starting with basic concepts and gradually progressing to advanced topics. Each module includes hands-on lessons and practical exercises to reinforce learning.
What support is available during the course?
CounselTrain offers various support options, including access to instructors, a community forum for peer interaction, and customer support for technical issues or inquiries related to the course content.
