Learn DQL

Learn DQL is a Dynatrace Query Language (DQL) learning environment that guides you step-by-step through a given set of exercises. The exercises are suitable for beginners and advanced users alike. Each step represents a specific DQL command or function with a short video or documentation link that guides you through the challenge.

At the end of each step, there is a checkpoint where the app validates the query before advancing to the next step. Because there are usually multiple ways to create a query to achieve the desired result, the Learn DQL app compares the result of the presented query with the result of a reference query. If the results match, you can proceed to the next step. If no progress is made after several attempts, the app gives you hints, and as a last option, the shares the full query with you.

There are currently two exercises available:

1.) Beginner’s exercise

Prerequisites: You don’t need any knowledge about DQL to run this exercise.

This tutorial teaches the basics of DQL, including the most important commands and functions.

The goal of the exercise: Work on a set of ingested log records, extract information from a log line, and aggregate the extracted data for a time-based visualization.

2.) JSON audit logs

Prerequisites: Completion of the Beginner's exercise.

In this example, users have made changes that are tracked with audit logs. The goal is to find the type and quantity of actions performed by the users.

Goal of the exercise: You'll learn how to parse JSON data and aggregate the records based on information within the JSON structure.

• Self-service hands-on resource
• Step-by-step approach
• Exercises are component-based
• Additional exercises can be added in the future

DQL Dynatrace Community Forum

Davis DQL Examples

DQL Best Practices

DQL Language Reference