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.
Play course overview
Course info
Rating
(91)
Level
Beginner
Updated
Jun 20, 2018
Duration
4h 32m
Table of contents
Course Overview
Course Overview 1m
Introduction
Introduction 5m Demo of the Portal 8m
80% of the Operators You’ll Ever Use
The search Command 14m The where Command 9m The take Command 2m The count Command 1m The summarize Command 7m The extend Command 5m The project Command 7m The distinct Command 2m Module Summary 4m
Scalar Operators
The print and now Commands 3m The ago Command 3m The sort Command 3m The extract Command 3m The parse Command 3m datetime and timespan Arithmetic 4m The startof... Commands 4m The endof... Commands 1m The between Commands 4m The todynamic Command 5m The format_datetime and format_timespan Commands 6m The datetime_part Command 3m The iif Command 3m The case Command 3m The isempty and isnull Commands 4m The split Command 4m String Operators 2m The strcat Command 6m
Advanced Aggregations
The arg_max and arg_min Commands 3m The makeset and makelist Commands 3m The mvexpand Command 2m The percentiles Command 3m The dcount Command 4m The dcountIf Command 3m The countif Command 2m The pivot Command 1m The top-nested Command 4m The max and min Commands 1m The sum and sumif Commands 1m The any Command 3m
Working with Datasets
The let Command 8m The join Command 11m The union Command 9m Creating a Datatable 5m The prev and next Commands 9m The toscalar Command 2m The row_cumsum Command 5m The materialize Command 4m
Time Series
The range Command 3m The make-series Command 3m The series_stats Command 2m The series_outliers Command 6m The series_fir Command 10m The series_iir Command 5m The series_fit_line Command 4m The series_fit_2lines Command 4m
Machine Learning
The basket Command 5m The autocluster Command 3m The diffpatterns Command 4m The reduce Command 4m
Exporting Data
Export to CSV Files 2m Exporting to PowerBI 3m
Where Next?
Course Summary 6m
Description
Course info
Rating
(91)
Level
Beginner
Updated
Jun 20, 2018
Duration
4h 32m
Description

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.

Course FAQ
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 Cain
About the author

Robert C. Cain (arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books.

More from the author
PowerShell 7 Quick Start for Developers on Linux, macOS, and Windows
Intermediate
2h 7m
Dec 4, 2020
Everyday PowerShell for Developers on Linux, macOS, and Windows
Intermediate
2h 59m
Dec 3, 2020
Getting Started with PowerShell Core on Linux and macOS
Beginner
4h 1m
Aug 21, 2020
More courses by Robert Cain
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Robert Cain, and welcome to my course, Kusto Query Language from Scratch. I'm the owner of Arcane Training and Consulting, and a Microsoft MVP. In this course we're going to learn the new Kusto Query Language. KQL is being used across multiple Microsoft platforms to make big datasets available for analysis. Some of the major topics that we will cover include scalar operators and aggregations, working with datasets, machine learning, and time series analysis. By the end of this course you'll be comfortable writing KQL queries to extract information from a variety of Microsoft platforms, platforms such as Azure Log Analytics or Application Insights, just to name two of the many available. Before beginning the course you should be familiar with Azure and basic query language concepts. I hope you'll join me on this journey to learn KQL with the Kusto Query Language from Scratch course at Pluralsight.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT