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: 🔗 https://github.com/johnthebrit/RandomStuff/raw/master/Whiteboards/KQLOverview.png ► KQL tutorial: 🔗 https://docs.microsoft.com/azure/data-explorer/kusto/query/tutorial?pivots=azuredataexplorer ► ADX sample databases: 🔗 https://dataexplorer.azure.com/clusters/help/databases/Samples ► KQL quick reference: 🔗 https://docs.microsoft.com/azure/data-explorer/kql-quick-reference ► My resource graph example queries: 🔗 https://github.com/johnthebrit/RandomStuff/tree/master/ResourceGraph ► Join documentation: 🔗 https://docs.microsoft.com/azure/data-explorer/kusto/query/joinoperator?pivots=azuredataexplorer ▬▬▬▬▬▬ Want to learn more? 🚀 ▬▬▬▬▬▬ 📖 Recommended Learning Path for Azure 🔗 https://learn.onboardtoazure.com 🥇 Certification Content Repository 🔗 https://github.com/johnthebrit/CertificationMaterials 📅 Weekly Azure Update 🔗 https://youtube.com/playlist?list=PLlVtbbG169nEv7jSfOVmQGRp9wAoAM0Ks ☁ Azure Master Class 🔗 https://youtube.com/playlist?list=PLlVtbbG169nGccbp8VSpAozu3w9xSQJoY ⚙ DevOps Master Class 🔗 https://youtube.com/playlist?list=PLlVtbbG169nFr8RzQ4GIxUEznpNR53ERq 💻 PowerShell Master Class 🔗 https://youtube.com/playlist?list=PLlVtbbG169nFq_hR7FcMYg32xsSAObuq8 🎓 Certification Cram Videos 🔗 https://youtube.com/playlist?list=PLlVtbbG169nHz2qfLvPsAz9CnnXofhmcA 🧠 Mentoring Content 🔗 https://youtube.com/playlist?list=PLlVtbbG169nGHxNkSWB0PjzZHwZ0BkXZZ ❔ Question about my setup? 🔗 https://youtube.com/playlist?list=PLlVtbbG169nHuSSHudxXDdn9Vz3T4-0mS 👕 Cure Childhood Cancer Charity T-Shirt Channel Store 🔗 https://johns-t-shirts-store.creator-spring.com/ SUBSCRIBE ✅ https://www.youtube.com/channel/UCpIn7ox7j7bH_OFj7tYouOQ?sub_confirmation=1 #microsoft #azure #johnsavillstechnicaltraining #doyouevenazure #onboardtoazure #cloud