role-iq-logo
Rock [Azure]
See all Azure roles

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

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
Getting Started with PowerShell Core on Linux and macOS
Beginner
3h 53m
May 28, 2019
Building Your First SSRS Report
Intermediate
2h 1m
Jan 22, 2019
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