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

Kusto Query Language (KQL) from Scratch

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.
Course info
Rating
(13)
Level
Beginner
Updated
Jun 20, 2018
Duration
4h 33m
Table of contents
Course Overview
Introduction
80% of the Operators You’ll Ever Use
Scalar Operators
Advanced Aggregations
Working with Datasets
Time Series
Machine Learning
Exporting Data
Where Next?
Description
Course info
Rating
(13)
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
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
Azure PowerShell Playbook: Azure SQL
Intermediate
1h 4m
Jan 18, 2018
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.