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
