English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 4h 33m | 780 MB
KQL, the Kusto Query Language, is used to query Azure’s services. This course will teach you the basic syntax of KQL, then cover advanced topics such as machine learning and time series analysis, as well as exporting your data to various platforms.
Increasingly, Azure is becoming the infrastructure backbone for many corporations. It is imperative then, that you have the ability to query Azure into gain insights to the Azure services your company is using. In this course, Kusto Query Language (KQL) from Scratch, you will learn foundational knowledge to query a variety of Azure services. First, you will learn the basics of KQL, the Kusto Query Language. Next, you will progress to advanced KQL abilities such as machine learning and time series analysis. Finally, you will explore how to export the results of your KQL queries to CSV files and PowerBI. When you’re finished with this course, you will have the skills and knowledge of the Kusto Query Language needed to gain valuable insights into your Azure services.
Table of Contents
Course Overview
1 Course Overview
Introduction
2 Introduction
3 Demo of the Portal
% of the Operators You ll Ever Use
4 The search Command
5 The where Command
6 The take Command
7 The count Command
8 The summarize Command
9 The extend Command
10 The project Command
11 The distinct Command
12 Module Summary
Scalar Operators
13 The print and now Commands
14 The ago Command
15 The sort Command
16 The extract Command
17 The parse Command
18 datetime and timespan Arithmetic
19 The startof… Commands
20 The endof… Commands
21 The between Commands
22 The todynamic Command
23 The format datetime and format timespan Commands
24 The datetime part Command
25 The iif Command
26 The case Command
27 The isempty and isnull Commands
28 The split Command
29 String Operators
30 The strcat Command
Advanced Aggregations
31 The arg max and arg min Commands
32 The makeset and makelist Commands
33 The mvexpand Command
34 The percentiles Command
35 The dcount Command
36 The dcountIf Command
37 The countif Command
38 The pivot Command
39 The top-nested Command
40 The max and min Commands
41 The sum and sumif Commands
42 The any Command
Working with Datasets
43 The let Command
44 The join Command
45 The union Command
46 Creating a Datatable
47 The prev and next Commands
48 The toscalar Command
49 The row cumsum Command
50 The materialize Command
Time Series
51 The range Command
52 The make-series Command
53 The series stats Command
54 The series outliers Command
55 The series fir Command
56 The series iir Command
57 The series fit line Command
58 The series fit 2lines Command
Machine Learning
59 The basket Command
60 The autocluster Command
61 The diffpatterns Command
62 The reduce Command
Exporting Data
63 Export to CSV Files
64 Exporting to PowerBI
Where Next
65 Course Summary
Resolve the captcha to access the links!