MENU

Fun & Interesting

Learn KQL with Kusto Detective Agency

Tybul on Azure 1,740 7 months ago
Video Not Working? Fix It Now

Hey there! Have you heard of Kusto Query Language (KQL)? It’s a powerful querying language that’s becoming widely used across several Azure services, like Azure Monitor, Azure Data Explorer, and Microsoft Fabric. So, how do you get started with KQL? Sure, you could comb through pages of documentation, but there’s a more engaging way: the Kusto Detective Agency! It’s a clever gamified experience from Microsoft where you can learn KQL by solving intriguing detective cases. Curious? Join me in this video as I tackle the first case. Let’s dive in and have some fun! ▬▬▬▬▬▬ IMPORTANT LINKS ▬▬▬▬▬▬ My LinkedIn profile: https://www.linkedin.com/in/piotr-tybulewicz-81a8793/ My GitHub with drawings and source code: https://github.com/TybulOnAzure/StandaloneEpisodes Kusto Detective Agency: https://detective.kusto.io/ SQL cheat sheet: https://learn.microsoft.com/en-us/kusto/query/sql-cheat-sheet?view=microsoft-fabric Join types: https://learn.microsoft.com/en-us/kusto/query/join-operator?view=azure-data-explorer&preserve-view=true&pivots=azuredataexplorer#default-join-flavor ▬▬▬▬▬▬ MEMBERSHIP ▬▬▬▬▬▬ Join this channel to get access to perks: https://www.youtube.com/channel/UCLnXq-Fr-6rAsCitq9nYiGg/join ▬▬▬▬▬▬ CHAPTERS ▬▬▬▬▬▬ 00:00 Introduciton 00:15 KQL overview 02:04 Kusto Detective Agency 10:25 Your first KQL query 12:26 Syntax of KQL queries 14:44 The 1st real case 26:02 Solving the case 52:14 Summary

Comment