Kusto Query Language (KQL) Overview

A look at KQL, its core usage and some useful resources to help you learn.

🔎 Looking for content on a particular topic? Search the channel. If I have something it will be there!

▬▬▬▬▬▬ C H A P T E R S ⏰ ▬▬▬▬▬▬
0:00 - Introduction
5:25 - Basics of KQL
11:29 - Pipe character and sending output to commands
14:29 - Bags and looking at child elements
20:09 - Summarize and new generated columns
25:04 - Searching for specific data and visualizations
29:05 - Joining tables and types of join
45:50 - Removing columns and renaming and other compares
50:00 - Working with dates and a new column
57:00 - Resource graph example
1:02:40 - Summary and close

Correction:
51:07 - I mean Modulo not Modulus lol

▬▬▬▬▬▬ K E Y L I N K S 🔗 ▬▬▬▬▬▬
► Whiteboard:
► KQL tutorial:
► ADX sample databases:
► KQL quick reference:
► My resource graph example queries:
► Join documentation:

▬▬▬▬▬▬ Want to learn more? 🚀 ▬▬▬▬▬▬
📖 Recommended Learning Path for Azure
🥇 Certification Content Repository
📅 Weekly Azure Update
☁ Azure Master Class
⚙ DevOps Master Class
💻 PowerShell Master Class
🎓 Certification Cram Videos
🧠 Mentoring Content
❔ Question about my setup?
👕 Cure Childhood Cancer Charity T-Shirt Channel Store

#microsoft #azure #johnsavillstechnicaltraining #doyouevenazure #onboardtoazure #cloud

[abuwandaschannel]

Thank you John. I now see light at the end of the tunnel. You get the point across very clearly.

[matthewfranklin]

Fantastic presentation as ever! As a former Oracle DBA and more recently a Splunk consultant this was the Goldilocks level of detail for me. Not too basic, not too tough, just perfect 👌

[johnprincipes]

I've used KQL, but I didn't realize the versatility for visuals using 'render'. Very cool!

[Ozzy_birds]

Amazing explanation. Clear and concise! Thank you so much for allocating your precious time to explain it to us!

[userhelen]

Super useful. As always you are making it so easy to understand with great examples and explanation!

[margoatanacio]

I’ve been looking for Kusto Query tutorials to prep for the SC200 exam and I’m so glad I found a Reddit post recommending your channel. This video is truly top-tier! You've gained a new subscriber

[inetregsameer]

wow. much awaited content . Thanks John. You are really helping us with your awesome contents. stay blessed.

[EstevanLopez]

You've just helped me be better at my job! Thank you so much!

[danyhoter]

Very good presentation. It is recommended to mention the small table of state population first in a join and use inner or rightouter. It is much more efficient.
Also, if you do that, innerunique will make much more sense because it will deduplicate the state table which is going to prevent rows in the storm table to be duplicated.

[steveng.]

Thanks sir! Literally one of the next few things on my list of skills to sharpen, so as usual very timely (at least for me).

[bretspencer]

Awesome! Thanks for this fantastic content. I was just starting a WAF dashboard late last week. This is super timely!

[SanthoshHugar]

Enjoy your teaching style, all things to the point. Great content.

[kamarajanpkb]

Great introduction to KQL, thank you John!

[Astral]

Wow, such an amazing presentation. Thank you so much!

[Timmy-Hi]

👍🇬🇧 lovely, arrived just in time for SC exams 🎉

[zameerahmed]

Ur awesome as ever Keep it up. God blesss

[ZATennisFan]

John if we ever meet in person the beer or whatever you drink is on me…….