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
(112)
Level
Beginner
Updated
Jun 20, 2018
Duration
4h 32m
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
(112)
Level
Beginner
Updated
Jun 20, 2018
Duration
4h 32m
Your 10-day individual free trial includes:

Expert-led courses

Keep up with the pace of change with thousands of expert-led, in-depth courses.
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
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
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.