technifyed

Microsoft via Microsoft Learn

Write your first query with Kusto Query Language

Overview

Learn how to write simple queries in Kusto Query Language (KQL) by using the operators take, project, count, where, and sort.

Syllabus 11

  1. Introduction 5 minutes
  2. Understand the basic structure of a Kusto query 5 minutes
  3. Exercise - Connect to resources 5 minutes
  4. Exercise - Return a specific number of rows by using the take operator 5 minutes
  5. Exercise - Select columns to return by using the project operator 5 minutes
  6. Exercise - Filter data by using the where operator 5 minutes
  7. Exercise - Reorder returned data by using the sort operator 5 minutes
  8. Challenge 5 minutes
  9. Solution 5 minutes
  10. Module assessment 5 minutes
  11. Summary 5 minutes

Skills you'll practise

Azure Data ExplorerAzure

Advantages and disadvantages

Advantages

  • Free, official and kept up to date by Microsoft.
  • Free sandbox environments for many Azure exercises, no credit card needed.
  • Counts toward Microsoft certification exams (AZ-900, AI-900, PL-300…).
  • From Microsoft, a well-regarded name.
  • Free digital badge you can add to LinkedIn.
  • Completely free.
  • Self-paced: start any time.
  • A clear syllabus (11 parts) you can see before you start.

Disadvantages

  • Mostly reading, not video.
  • Focused on Microsoft products.
  • Short (40 minutes): an overview, not deep coverage.

Some points apply to every course of this kind; see how we rank.

Free, with a free credential

  • Free: Sign in with any Microsoft account.
  • Badge: Finish it to earn a free badge on your Microsoft Learn profile.

Microsoft is in Tier 2: excellent universities and the companies that build the technology of our institution ranking (86/100).

Similar courses

Compare these

Massachusetts Institute of Technology · YouTube

MIT 6.01SC Introduction to EECS I

Instructor: Dennis Freeman, Kendra Pugh This course provides an integrated introduction to electrical engineering and computer science, including modern software engineering, linear systems analysis, electronic circuits, and decision-making. The lecture videos provide an overview of each topic, whi…

Free video27 videos, 17 hours

Harvard University · YouTube

CS50's Introduction to Cybersecurity

An introduction to cybersecurity for technical and non-technical audiences alike. Learn how to secure your accounts, data, systems, and software against today’s threats and how to recognize and evaluate tomorrow’s as well, both at home and at work. Learn how to preserve your own privacy. Learn to v…

Free video6 videos, 7.5 hours

Harvard University · edX

CS50's Introduction to Computer Science

An introduction to the intellectual enterprises of computer science and the art of programming.

Free to audit12 weeks, 5 - 14 hours per week

Harvard University · YouTube

CS50 Fall 2023 - Lecture 10 - Cybersecurity (live, unedited)

*** This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming. *** TABLE OF CONTENTS 00:00:00 - Introduction 00:12:55 - Recap 00:15:50 - MIT Hack 00:20:00 - Looking Ahead 00:26:54 - Thank you! 00:29:57 - Passwords 00:53:16 - Passw…

Free video2 hours

Massachusetts Institute of Technology · YouTube

MIT 6.5630 Advanced Topics in Cryptography, Fall 2023

Instructor: Yael T. Kalai View the complete course: https://ocw.mit.edu/courses/6-5630-advanced-topics-in-cryptography-fall-2023/ YouTube Playlist: https://www.youtube.com/playlist?list=PLUl4u3cNGP61EZllk7zwgvPbI4kbnKhWz This course is about the evolution of proofs in computer science. We will lear…

Free video17 videos, 23 hours

Stanford University · YouTube

Stanford Webinar - Hash, Hack, Code: Emerging Trends in Cyber Security

Hashing schemes for passwords. Monitoring the Internet of Things. Securing program control flow. These are the latest developments in cyber security you need to understand for defending against various attack techniques. Join Professor Dan Boneh as he shares new approaches to these emerging trends…

Free video50 minutes

Enter your email and the official page opens. Phone is optional.