Simple play icon Course

Kusto Query Language: Scalar Operators

by Robert Cain

In this course, you'll learn a set of scalar operators designed to make your query results nicely formatted and easy to read. With these you can create output more suitable to business users.

What you'll learn

The Kusto Query Language allows you to harvest vast amounts of data. However, the data is not always easy to read.

In this course, Kusto Query Language: Scalar Operators, you'll cover a set of scalar operators designed to make the output neater and easier to read.

First, you'll discover operators to perform date/time calculations and format the results nicely. Next, you'll see how to perform logic branching, making decisions based on data. Then, you'll explore how to work with string data - formatting and dissecting it. Finally, you'll learn how to work with columns, expanding one column into multiple. When you are finished with this course, you’ll have the skills and knowledge of scalar operators to effectively use them in your Kusto Queries.

Table of contents

Course Overview
Basic Scalar Operators
Working with Columns

About the author

Robert C. Cain ( is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years' experience in the IT industry, working in a variety of fields including manufacturing, insurance, teleco... more

Ready to upskill? Get started