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
- Summarize Operator
- Summarize Operator - bin()
What you'll 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.
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)
The University of Sheffield
Other Courses
SAP Guide : The consultant's secrets to master
Tips and tools for SAP consultants: Improve efficiency and success.
Introduction to Shamanic Rose energy healing
Use Shamanic tools, Roses, herbs, plants, crystals, seashells, sound, visualisation and journeying for energy healing
JavaScript Crash Course for Beginners
JavaScript | ES6 | ES2015 | Object Oriented Programming | Functions
3 Minute German - Free taster course | Lessons for beginners
Learn to speak German you can use in everyday real-world situations - all in just 3-minute chunks!
Introduction To Artificial Intelligence
Introducing AI concepts in a very simple way and make it easy for you to learn
Introduction to Data Science using Python (Module 1/3)
Learn Data science / Machine Learning using Python (Scikit Learn)
About the instructors
- 4.44 Calificación
- 26992 Estudiantes
- 16 Cursos
Edufulness Atchyut
Azure Data Engineer and Instructor
Atchyut Kumar is a renowned programming and GATE CS/IT expert!
With a Masters from the prestigious National Institute of Technology-Calicut and a remarkable GATE CS/IT top ranker with an exceptional 99.97 percentile, Atchyut brings a wealth of knowledge and expertise to our Azure Data Engineering training.
Having spent 6+ years in database development and as a skilled Data Engineer, Atchyut possesses a remarkable 7+ years of experience as a GATE faculty. In total, he boasts an impressive 13+ years of teaching, research, and industry experience, having successfully mentored over 50,000 students through both classroom and online courses.
Atchyut is not only an expert in problem-solving techniques, algorithms, and competitive programming, but he also holds a specialization in data integration, transformation, and consolidation from various structured, unstructured, and streaming data systems. This unique skill set enables him to construct suitable schemas for building robust analytics solutions.
His unparalleled guidance has paved the way for many of his former students, who are now thriving in esteemed organizations such as Amazon, Samsung, Oracle, Google, Adobe, and many others. Some have even pursued higher studies, such as MS, M Tech, or Ph.D., further emphasizing the quality and impact of his teaching.
Student feedback
4.5
Course Rating
Reviews
Mohammad Imran
04-04-2024
It was helpful
Ikechukwu Anthony Iwegbue
19-11-2023
Awesome training!!! Thank You
Oksana Pukas
12-10-2023
I love this course!