Featured resource
Tech Upskilling Playbook 2025
Tech Upskilling Playbook

Build future-ready tech teams and hit key business milestones with seven proven plays from industry leaders.

Learn more
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Filter and Search Data with Kusto Query Language (KQL)

When working with datasets, whether small or large, the ability to efficiently and quickly filter the data to get the needed subset is essential. This course will teach you how to filter data in Azure Data Explorer using Kusto Query Language.

Gail Shaw - Pluralsight course - Filter and Search Data with Kusto Query Language (KQL)
by Gail Shaw

What you'll learn

In KQL, or any other data querying language, the ability to efficiently filter data to find just the needed entries is critical for any data professional.

In this course, Filter and Search Data with Kusto Query Language (KQL), you’ll gain the ability to efficiently search any data with KQL.

First, you’ll explore the basic form of the where clause and simple predicates.

Next, you’ll discover how to search data time and duration data.

Finally, you’ll learn how to search string data, including within longer chunks of text.

When you’re finished with this course, you’ll have the skills and knowledge of filtering data with KQL needed to work with data sets of any size and complexity.

Table of contents

About the author

Gail Shaw - Pluralsight course - Filter and Search Data with Kusto Query Language (KQL)
Gail Shaw

Gail Shaw is a Data Platform MVP and holds the MCM certification for SQL Server. Her specialties are in performance tuning and database recovery for SQL Server. She is a frequent poster on the SQL Server Central forums, writes articles for both SQLServerCentral.com and Simple-Talk.com, and often speaks at SQLBits and the PASS Community Summit.

More Courses by Gail