Writing NRQL Queries

Writing NRQL Queries

Learn how to ask questions about your data using NRQL, New Relic's SQL-flavored query language, and create beautiful visualizations for analyzing your data in real-time.

About this course

Learn how to ask questions about your data using NRQL, New Relic's SQL-flavored query language, and create beautiful visualizations for analyzing your data in real-time. Write queries and create charts to display both a broad view and a highly detailed drill-down analysis of your data to understand the metrics that matter most to your team.

In this course, you'll learn how to:

  1. Ask questions about your data with Insights' SQL-like query language, NRQL
  2. Compose basic queries in order to:
    • Group results using different time-based criteria
    • Show data distribution
    • Show the intersection and frequency of two attributes
  3. Compose complex queries in order to:
    • Ask questions about the completion of steps in a process or completion of a series of desired actions
    • Create Apdex charts to view compare overall Apdex scores or to test different t-values
    • Use math with almost any other functions

Whether you're familiar with query language syntax or not, this course will give you the foundation you need to access a powerful array of capabilities and visualizations for analyzing your data in real-time.

Curriculum

  • Introduction to NRQL

    Learn how to ask questions about your data with Insights' SQL-like query language, NRQL.

  • Advanced Segmentation

    Break data into groups by attribute, and display results with numerical values.

  • Filter Queries

    Narrow the scope of a large store of data by a single, specific parameter.

  • Cohort Analysis Queries

    Use FACET to separate and group your results by attribute.

  • Histogram and Heat Map Queries

    Display data in histogram and heat map charts.

  • Funnel Queries

    Ask questions about the completion of steps in a process, or completion of a series of selected actions.

  • NRQL Queries with Math

    Use basic mathematical functions to analyze any numerical data.

  • Apdex Queries

    Use the Apdex function to view and compare overall Apdex scores or to test different t-values.

  • Percentile Queries

    Identify performance outliers and help set a standard of performance within your app.

  • Course Evaluation: Writing NRQL Queries

    Help us improve; please share your feedback!

About this course

Learn how to ask questions about your data using NRQL, New Relic's SQL-flavored query language, and create beautiful visualizations for analyzing your data in real-time. Write queries and create charts to display both a broad view and a highly detailed drill-down analysis of your data to understand the metrics that matter most to your team.

In this course, you'll learn how to:

  1. Ask questions about your data with Insights' SQL-like query language, NRQL
  2. Compose basic queries in order to:
    • Group results using different time-based criteria
    • Show data distribution
    • Show the intersection and frequency of two attributes
  3. Compose complex queries in order to:
    • Ask questions about the completion of steps in a process or completion of a series of desired actions
    • Create Apdex charts to view compare overall Apdex scores or to test different t-values
    • Use math with almost any other functions

Whether you're familiar with query language syntax or not, this course will give you the foundation you need to access a powerful array of capabilities and visualizations for analyzing your data in real-time.

Curriculum

  • Introduction to NRQL

    Learn how to ask questions about your data with Insights' SQL-like query language, NRQL.

  • Advanced Segmentation

    Break data into groups by attribute, and display results with numerical values.

  • Filter Queries

    Narrow the scope of a large store of data by a single, specific parameter.

  • Cohort Analysis Queries

    Use FACET to separate and group your results by attribute.

  • Histogram and Heat Map Queries

    Display data in histogram and heat map charts.

  • Funnel Queries

    Ask questions about the completion of steps in a process, or completion of a series of selected actions.

  • NRQL Queries with Math

    Use basic mathematical functions to analyze any numerical data.

  • Apdex Queries

    Use the Apdex function to view and compare overall Apdex scores or to test different t-values.

  • Percentile Queries

    Identify performance outliers and help set a standard of performance within your app.

  • Course Evaluation: Writing NRQL Queries

    Help us improve; please share your feedback!

*/