- Course
- 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.
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 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.