KQL Full Course for Beginners | Kusto Query Language

The Ten Minute KQL channel is dedicated to improving your KQL skills no matter what your level. This KQL full course for beginners is the perfect way to learn the basics or refresh on an areas you may be weak at. If you want more in-depth explanations and examples, refer to the individual sessions associated with the Beginner Series playlist below. If you want to progress beyond the beginner series, try the Intermediate Series playlist below.

Beginner Series Playlist    • 1. Kusto Query Language | KQL | Begin...  
Intermediate Series Playlist    • 1. Kusto Query Language | KQL | Inter...  

Timecode
0:00 - Intro
0:42 - KQL Overview
3:24 - Azure Data Explorer (ADX) Setup
4:50 - Log Analytics Workspace (LAW) Setup
6:11 - Sampling Table Data
7:55 - where
10:04 - Pipe
10:43 - Spacing
11:03 - and
11:46 - or
12:13 - in
13:00 - ~
16:08 - project
16:40 - // comments
17:55 - distinct
18:38 - sort by
19:38 - search
20:21 - contains
21:29 - has
22:28 - startswith
22:45 - endswith
22:54 - !
23:22 - count
23:31 - Numbers
24:00 - Greater Than / Less Than
24:27 - getschema
24:55 - Time
25:45 - ago
27:20 - between / datetime
27:46 - Time Formats
28:38 - now
29:49 - UTC
30:15 - Practical Exercise
31:38 - top
32:12 - extend
33:25 - Debugging
36:16 - Debugging Challenge
40:48 - Additional Resources