This post has been republished via RSS; it originally appeared at: Azure Data Explorer Blog articles.
The second MS Learn Module on "Write your first query with Kusto Query Language" was published, and you are welcome to continue your journey.
Kusto Query Language (KQL) lets you explore your data and discover patterns, identify anomalies and outliers, and create statistical models.
Suppose you're a data analyst with a passion for meteorological data. You want to use the Kusto Query Language to explore a dataset for answers to basic questions about the kinds and locations of storms in the United States.
What will we be doing?
You'll write simple queries in the Kusto Query Language (KQL) to explore and gain insights from a sample dataset. You'll learn how to:
- Count the number of records by using the
- Return a specific number or rows by using the
- Select columns to return by using the
- Filter data by using the
- Reorder returned data by using the
- Build queries using multiple operators
What is the main goal?
By the end of this session, you'll be able to write a query with the most commonly used operators: count, take, project, where, sort, and others.