Learn Azure Data Explorer (ADX) and Kusto Query Language (KQL) in easiest possible way.

What you will learn

Understand Azure Data Explorer (ADX)

Write queries in Kusto Query Language (KQL)

Learn Joins, Subqueries, Aggregate functions in KQL.

Create clusters and databases in ADX

Create geospatial visualization.

Learn Tabular operators, Scaler operators, Scalar functions, special functions and Time series analysis.

Description

Welcome!

Hi, I am happy to helping you with learning one of the in-demand data engineering tools in the cloud, Azure Data Explorer (ADX) and Kusto Query Language (KQL).

Azure Data Explorer aka ADX, is a fast, highly scalable and fully managed data analytics service for log, telemetry and streaming data. This data exploration service enables you to pull together, store and analyze diverse data. You can query terabytes of data in a few seconds and it allows fast ad-hoc queries over the varied data.


Get Instant Notification of New Courses on our Telegram channel.


Kusto Query Language is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modeling, and more. The query uses schema entities that are organized in a hierarchy similar to SQLs: databases, tables, and columns.

This course is designed to help for develop the skills necessary to understand Azure Data Explorer (ADX) and Kusto Query Language (KQL).

Who this course is for:

  • University students looking for a career in Data Engineering
  • IT developers working on other disciplines trying to move to Data Engineering
  • Data Architects looking to gain an understanding about Azure Data Engineering stack
  • Data Scientists who want extend their knowledge into data engineering
  • Data Analyst or similar profiles
  • Other on-premises Database related profiles who want to learn how to implement these technologies in Azure Cloud.
  • Database Developer
  • Database Administrators (DBA)
English
language

Content

Introduction

Azure Data Explorer (ADX) account creation
Azure Data Explorer (ADX) Free account creation
Ingest Data from Local file and Microsoft Blob
Basic commands
Project Operator
Where operator