Kusto Query Language (KQL) for Cybersecurity

Learn KQL in Azure Log Analytics, Security Copilot, Sentinel, Defender XDR and more

  • 0.0 (0 Reviews)
  • 0 Students
  • 93 Lessons
  • Christopher Nett | 150.000+ Enrollments

Course Overview

This course contains the use of artificial intelligence.

KQL for Cybersecurity, is a meticulously structured Udemy course aimed at IT professionals seeking to master KQL for cybersecurity purposes. This course systematically walks you through the initial setup to advanced implementation with real-world applications.

Key Benefits for you:

SOC Basics: Establish a strong foundation with an overview of core concepts for a Security Operations Centers

Azure Basics: Familiarize yourself with essential Azure services and configurations relevant to integrating Microsoft Defender XDR into cloud environments.

Microsoft Security Basics: Gain insight into Microsoft's security ecosystem, including tools, best practices, and zero trust for safeguarding digital assets.

The Kusto Query Language (KQL): Learn the fundamentals of KQL, a powerful query language designed for fast and efficient data exploration in cybersecurity.

KQL Operators - Fundamentals: Master essential KQL operators, including filtering, sorting, and aggregation, to analyze security data effectively.

KQL Operators - Joins and Union: Understand how to use Joins and Union in KQL to correlate data from multiple sources for comprehensive threat analysis.

KQL in Microsoft Security Copilot: Explore how KQL integrates with Microsoft Security Copilot to enhance automated threat detection and response.

KQL in Microsoft Defender for Cloud: Discover how to use KQL in Microsoft Defender for Cloud to monitor and secure cloud workloads.

KQL for Microsoft Sentinel: Learn how KQL powers Microsoft Sentinel’s SIEM capabilities, enabling advanced threat hunting and security analytics.

KQL in Microsoft Defender XDR: Utilize KQL in Microsoft Defender XDR to detect, investigate, and respond to sophisticated cyber threats.

KQL Queries for Microsoft Entra ID: Explore KQL queries to analyze authentication, identity access patterns, and security incidents in Microsoft Entra ID.

KQL Queries for Cyber Threat Intelligence (CTI): Leverage KQL for cyber threat intelligence by identifying indicators of compromise (IoCs) and suspicious activities.

KQL Queries for Azure Firewall: Learn how to use KQL for monitoring and analyzing firewall logs to detect and prevent network threats.

KQL Queries for Vulnerability Management: Utilize KQL to assess and manage vulnerabilities across your security environment for proactive risk mitigation.

ChatGPT for KQL: Discover how to use ChatGPT to generate, refine, and optimize KQL queries for faster and more effective security investigations.


This course contains promotional materials.

See more

FAQ

FAQ area empty

Course curriculum

18 chương 93 bài học 6 giờ 13 phút 7 bài học thử miễn phí
Chương 1 Introduction
Chương 2 Basics - Security Operations Center (SOC)
Chương 3 Basics - Azure
  • Cloud Computing Properties 3:00
  • Cloud Computing Types 2:12
  • Azure Global Backbone 1:54
  • Shared Responsibility Model 4:30
  • Azure Resource Hierarchy 3:13
  • Azure Subscription Types 2:03
  • Entra ID Tenants and Azure Subscriptions 1:39
Chương 4 Basics - Microsoft Security
  • Zero Trust 3:40
  • The Microsoft Security Cosmos 4:35
  • Defending Across Attack Chains 3:09
Chương 5 The Kusto Query Language (KQL)
  • What is KQL? 8:24
  • Demo: KQL Playground 3:39
Chương 6 KQL Operators - Fundamentals
  • Search 1:53
  • Where 9:02
  • Datetime & timespans 4:52
  • Count, dcount, summarize & top 7:09
  • Order, sort, take 2:22
  • Extend, project 6:11
  • Contains, startswith, endswith 2:47
  • Let 2:39
  • Render 2:23
Chương 7 KQL Operators - Joins and Union
  • Union 1:16
  • Inner join 1:54
  • Left outer join 1:21
  • Right outer join 1:14
  • Full outer join 1:11
Chương 8 KQL in Microsoft Security Copilot
  • Demo: Get your Azure Subscription 0:59
  • What is Security Copilot? 5:22
  • From Prompt to Reponse 2:05
  • Architecture 5:41
  • Extending Copilot with Plugins & more 3:41
  • Privacy Implications 2:11
  • Authentication & RBAC 6:09
  • Standalone vs. Embedded Experience 1:21
  • Pricing 2:23
  • Onboarding Requirements 1:29
  • IMPORTANT - DO NOT SKIP
  • Demo: Create Compute Capacities 3:45
  • Demo: Security Copilot 14:58
  • Demo: KQL with Security Copilot 6:51
Chương 9 KQL in Microsoft Defender for Cloud
  • What is Defender for Cloud? 3:19
  • Demo: KQL in Defender for Cloud 4:57
Chương 10 KQL for Microsoft Sentinel
  • What is Sentinel? 4:59
  • Demo: KQL in Sentinel 7:17
Chương 11 KQL in Microsoft Defender XDR
  • Demo: Get E5 1:49
  • What is Defender XDR? 1:38
  • Demo: Configure RBAC 1:26
  • Demo: Create Sample Alerts in Defender for Cloud 1:18
  • Demo: Manage Incidents and Alerts 4:41
  • Demo: Connect Sentinel to Defender XDR 3:56
  • Demo: KQL in Defender XDR 2:01
Chương 12 KQL Queries for Microsoft Entra ID
  • What is Microsoft Entra ID? 9:27
  • Entra ID Authentication Methods 6:20
  • Conditional Access 6:37
  • Demo: Conditional Access 14:42
  • Identity Protection 14:02
  • Demo: Identity Protection 6:12
  • KQL Hunting Queries: Suspicious Sign-in to privileged Accounts 5:22
  • KQL Hunting Queries: Entra ID Brute Force 3:02
  • KQL Analytic Rule: Conditional Access Policy modified by new User 2:47
Chương 13 KQL Queries for Cyber Threat Intelligence (CTI)
  • What is a Threat? 1:34
  • Intelligence, Threat Intelligence & Cyber Threat Intelligence (CTI) 2:46
  • What is CTI? 2:07
  • Threat, Vulnerability & Risk 1:46
  • Threat-Informed Defense 3:15
  • Tactics, Techniques & Procedures (TTPs) 3:00
  • IOCs & IOAs 2:34
  • Pyramid of Pain 3:11
  • CTI Sources 1:53
  • KQL Hunting Queries: File Entity Office Activity 2:53
  • KQL Hunting Queries: Security Events 2:26
Chương 14 KQL Queries for Azure Firewall
  • Azure Firewall 8:19
  • Demo: Azure Firewall 23:21
  • KQL Hunting Queries: Source IP Abnormally Connects to Multiple Destinations 4:02
Chương 15 KQL Queries for Vulnerability Management
  • What is a Vulnerability? 2:02
  • Common Vulnerabilities and Exposures (CVE) 2:37
  • Common Vulnerability Scoring System (CVSS) 5:05
  • Log4j 3:27
  • Analytic Rule: Identify log4j vulnerable machines 1:31
Chương 16 ChatGPT for KQL
  • Demo: Create your OpenAI Account 1:14
  • Demo: Analytic Rules for Microsoft Sentinel 5:11
  • Demo: Hunting Queries 6:27
Chương 17 Cybersecurity Resources for KQL
  • Cybersecurity Resources for KQL
Chương 18 Bonus
  • Bonus 0:52

Requirment

  • Basic IT Knowledge

  • Willingness to learn cool stuff!

Outcomes

  • KQL Operators - Fundamentals: Master essential KQL operators, including filtering, sorting, and aggregation, to analyze security data effectively.

  • KQL Operators - Fundamentals: Master essential KQL operators, including filtering, sorting, and aggregation, to analyze security data effectively.

  • KQL in Microsoft Security Copilot: Explore how KQL integrates with Microsoft Security Copilot to enhance automated threat detection and response.

  • KQL in Microsoft Defender for Cloud: Discover how to use KQL in Microsoft Defender for Cloud to monitor and secure cloud workloads.

  • KQL for Microsoft Sentinel: Learn how KQL powers Microsoft Sentinel’s SIEM capabilities, enabling advanced threat hunting and security analytics.

  • KQL in Microsoft Defender XDR: Utilize KQL in Microsoft Defender XDR to detect, investigate, and respond to sophisticated cyber threats.

  • KQL Queries for Microsoft Entra ID: Explore KQL queries to analyze authentication, identity access patterns, and security incidents in Microsoft Entra ID.

  • KQL Queries for Cyber Threat Intelligence (CTI): Leverage KQL for cyber threat intelligence by identifying indicators of compromise (IoCs) and suspicious activi

  • KQL Queries for Azure Firewall: Learn how to use KQL for monitoring and analyzing firewall logs to detect and prevent network threats.

  • KQL Queries for Vulnerability Management: Utilize KQL to assess and manage vulnerabilities across your security environment for proactive risk mitigation.

  • ChatGPT for KQL: Discover how to use ChatGPT to generate, refine, and optimize KQL queries for faster and more effective security investigations.

Instructor

...
Christopher Nett | 150.000+ Enrollments

0.0

  • ... 0 Student
  • ... 21 Courses
  • ... 0 review

View Details

Reviews

Rate this course :

Remove all