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
(57)
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
The take Command 2m The summarize Command 7m The search Command 14m The where Command 9m The extend Command 5m The count Command 1m The project Command 7m The distinct Command 2m Module Summary 4m
Scalar Operators
The datetime_part Command 3m The startof... Commands 4m The todynamic Command 5m The parse Command 3m String Operators 2m The between Commands 4m The isempty and isnull Commands 4m The case Command 3m The format_datetime and format_timespan Commands 6m The extract Command 3m The sort Command 3m The endof... Commands 1m datetime and timespan Arithmetic 4m The strcat Command 6m The print and now Commands 3m The split Command 4m The ago Command 3m The iif Command 3m
Advanced Aggregations
The mvexpand Command 2m The makeset and makelist Commands 3m The top-nested Command 4m The arg_max and arg_min Commands 3m The pivot Command 1m The dcount Command 4m The max and min Commands 1m The percentiles Command 3m The countif Command 2m The sum and sumif Commands 1m The any Command 3m The dcountIf Command 3m
Working with Datasets
The let Command 8m Creating a Datatable 5m The prev and next Commands 9m The toscalar Command 2m The join Command 11m The union Command 9m The row_cumsum Command 5m The materialize Command 4m
Time Series
The series_iir Command 5m The range Command 3m The series_fit_2lines Command 4m The series_fit_line Command 4m The series_stats Command 2m The make-series Command 3m The series_fir Command 10m The series_outliers Command 6m
Machine Learning
The autocluster Command 3m The basket Command 5m The reduce Command 4m The diffpatterns Command 4m
Exporting Data
Exporting to PowerBI 3m Export to CSV Files 2m
Where Next?
Course Summary 6m
Description
Course info
Rating
(57)
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
Microsoft Azure Data Explorer - Advanced KQL
Advanced
2h 50m
Jun 30, 2020
Managing SSIS Projects
Intermediate
2h 18m
May 4, 2020
Introduction to the Azure Data Migration Service
Beginner
45m
Mar 25, 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