Simple play icon Course

Kusto Query Language (KQL) from Scratch

by Robert Cain

KQL, the Kusto Query Language, is used to query Azure's services. This course will teach you the basic syntax of KQL, then cover advanced topics such as machine learning and time series analysis, as well as exporting your data to various platforms.

What you'll learn

Increasingly, Azure is becoming the infrastructure backbone for many corporations. It is imperative then, that you have the ability to query Azure into gain insights to the Azure services your company is using. In this course, Kusto Query Language (KQL) from Scratch, you will learn foundational knowledge to query a variety of Azure services. First, you will learn the basics of KQL, the Kusto Query Language. Next, you will progress to advanced KQL abilities such as machine learning and time series analysis. Finally, you will explore how to export the results of your KQL queries to CSV files and PowerBI. When you're finished with this course, you will have the skills and knowledge of the Kusto Query Language needed to gain valuable insights into your Azure services.

Table of contents

Course Overview
Where Next?

Course FAQ

What is the Kusto Query Language?

Kusto Query Language (KQL) is a read only request to process data and return results.

What is machine learning?

Machine learning is the study of computer algorithms that improve automatically through experience and time.

What will I learn in this KQL course?

In this course, you will learn about scaler operators and aggregations, how to work with datasets, machine learning, time series analysis. By the end of this course, you will be comfortable writing KQL queries.

What prerequisites are required for this KQL course?

Prerequisites for this course are a familiarity with Azure and and understanding of basic query concepts.

What are some of the benefits of big datasets?

Some of the benefits of big data are: better decision making, increased efficiency, cuts costs, key insights, and increased predicting capabilities.

About the author

Robert C. Cain ( is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years' experience in the IT industry, working in a variety of fields including manufacturing, insurance, teleco... more

Ready to upskill? Get started