Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Learning Dynatrace Query Language - DQL

Dynatrace via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn Dynatrace Query Language (DQL) through this comprehensive 45-minute video playlist that teaches you to explore data, discover patterns, identify anomalies and outliers, and create statistical modeling using data stored in Dynatrace Grail storage. Master essential DQL commands including fetch for querying data, filter for data filtering, fields for selecting specific data fields, parse for data parsing, sort for organizing results, and summarize for grouping data. Explore advanced techniques such as join queries for combining datasets, dedup for removing duplicates, lookup for joining two queries, expand for converting fields into multiple records, append for adding data, and timeseries for querying metrics. Discover specialized commands like makeTimeseries for charting non-metric data over time and learn Dynatrace Pattern Language (DPL) fundamentals. Apply your knowledge through practical use cases including comparing memory usage week-over-week, analyzing percentage distributions, identifying problem hotspots by application name or tags, examining trading activity patterns by weekday, and performing comprehensive data searches. Gain hands-on experience with real-world scenarios that demonstrate how to leverage DQL's powerful capabilities for effective data analysis and monitoring within the Dynatrace platform.

Syllabus

Starting out with DQL – The Concepts You Need to Know
Getting Started with Dynatrace Pattern Language (DPL)
Join queries - join command
Deduplicating data - dedup command
Joining Two Queries - Lookup Command
Expand A Field Into Multiple Records In DQL – Expand Command
Append Data in DQL – Append Command
Query Your Metrics in DQL – Timeseries Command
DQL by Use Case -Compare Memory Usage Week-over-Week
Query your data in DQL – Fetch Command
Filter Your Data in DQL – Filter Command
Select Fields of Your Data in DQL – Fields Command
Parse Your Data in DQL – Parse Command
Sort Your Data in DQL – Sort Command
Group Your Data in DQL – Summarize Command
Chart Non-Metric Data Over Time - makeTimeseries Command
DQL by Use Case - Percentage Distribution
DQL by Use Case - Problem Hotspots by App, Name or Any Other Tag
DQL by Use Case - Trading Activity by Weekday
Search data in DQL (Dynatrace Query Language)

Taught by

Dynatrace

Reviews

Start your review of Learning Dynatrace Query Language - DQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.