|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/hands-on-kusto-query-languagekql/
课程评论：没有评论
**课程名称：** Kusto 查询语言 (KQL) 实战 **课程概述：** 本课程旨在通过实操 Kusto 查询语言 (KQL)，帮助学员掌握各种命令、子句和语句，从而打下坚实的基础。KQL 在 Microsoft Sentinel、Microsoft Defender for Cloud、Azure Data Explorer 等多个微软产品中有着广泛的应用，并且能够查询存储在 Log Analytics 工作区中的数据。 课程将从微软提供的用于有效练习 KQL 的门户开始，逐步深入。学员将从 `getSchema`、`let`、`print` 等基础命令学起，最终掌握 `join`、`union`、数据表操作、`mv-expand` 以及聚合函数等复杂概念。此外，课程还将详细讲解 KQL 的大小写敏感与不敏感特性，以及如何根据这些特性灵活地调整查询语句以从 Log Analytics 中检索数据。 Kusto 查询语言是一个强大的数据探索工具，能够帮助用户发现模式、识别异常值、构建统计模型等。KQL 查询使用类似于 SQL 的层级结构来组织数据，包括数据库、表和列。KQL 查询是只读的请求，用于处理数据并返回结果。查询以纯文本形式表达，采用易于阅读、编写和自动化的数据流模型。Kusto 查询由一个或多个查询语句组成。 **课程内容概览：** 1. Kusto 查询语言基础 2. KQL Log Analytics 演示（Schema、查询工作流、管道操作符） 3. KQL 操作符：`search` 4. KQL 操作符：`where` 5. KQL 操作符：`distinct`、`summarize` 6. KQL 操作符：`sort`、`ago` 7. KQL 操作符：`iif`、`strcat`、`case` 8. KQL 操作符：`arg_max`、`arg_min`、`Count`、`mv-expand` 9. KQL 操作符：`join`、`range`、`union`、自定义日志创建 10. Kusto 新手入门 11. 持续更新中...
In this Hands On: Kusto Query Language course we will do hands on KQL and understand various Commands, Clauses, Statements to build a good Foundation.KQL has many Applications Across Microsoft Sentinel, Micrsoft Defender for Cloud, Azure Data Explorer and it enables in Querying the Data which is Stored in Log Analytics Workspace.We Will start from Portal Walkthrough provisioned by MS for practicing KQL effectively, we will start with basic commands like getSchema, let, print, and will reach to complex aspect of join, union, data tables, mv-expand, Aggregate functions.We will understand case-sensitive and case-insensitive aspect of KQL and how commands can be Molded respectively for querying data from Log Analytics.Kusto Query Language is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modeling, and more. The query uses schema entities that are organized in a hierarchy similar to SQL's: databases, tables, and columns.A Kusto query is a read-only request to process data and return results. The request is stated in plain text, using a data-flow model that is easy to read, author, and automate. Kusto queries are made of one or more query statements.Brief on What we will do Hands on KQL in this Course:1. Kusto Query Language2. KQL LA demo Continued( Schema, Workflow of a Query, Pipe Operator)3. KQL Operator Search4. KQL Operator Where5. KQL Operator distinct,summarize6. KQL Operator sort,ago7. KQL Operator iif,strcat,case8. KQL Operator arg_max,arg_min,Count,mv-expand9. KQL Operator join,range,union,Custom log creation10.Kusto Rookie11. Updating..
