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

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
4h 1m
Aug 21, 2020
Microsoft Azure Data Explorer - Advanced KQL
Advanced
2h 50m
Jun 30, 2020
Managing SSIS Projects
Intermediate
2h 18m
May 4, 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