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
