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.
Author Name: Robert Cain
Author Description:
Robert C. Cain (http://arcanecode.com) 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

Table of Contents

• Course Overview
  1min
• Introduction
  2mins
• Basic Scalar Operators
  16mins
• Working with Dates and Times
  23mins
• Formatting Dates and Times
  16mins
• Logic Branching
  21mins
• Working with Strings
  18mins
• Working with Columns
  15mins
• Conclusion
  7mins