Zuora Platform: Data Query

This course will provide you the overview of Data Query and explains how this benefits both business and end subscribers.

About this course

This course will help you get familiarized with Data Query and discuss how this feature helps with SQL based data retrieval solution that enables you to export data from your tenant by performing SQL queries.

Prerequisites: 

  • Knowledge of SQL
  • Working knowledge of any API Testing Tool - eg: Postman

Note: The target audience for this course is anyone who is configuring Zuora (Zuora admins, developers, implementers) and will need developer skills to complete some of the tasks.

Click Enter/Start Course to begin the course.

Curriculum

  • Module 1: Introduction to Data Query
  • Overview of SQL Query and Data Query
  • Why Do We Need Data Query?
  • Advantages of Data Query Over ZOQL/Export ZOQL
  • Features of Data Query
  • Module Recap
  • Module 2: Exporting Data Using Data Query
  • SQL Query Syntax in Data Query - Example/Use Case
  • Export Data Using Data Query Through API- Example/Use Case
  • Demo: To export data using Data Query through API
  • Export Data Using Data Query Through Zuora UI- Example/Use Case
  • Demo: Use-case to export data using Data Query in Zuora Platform: UI
  • Export Data Using Data Query through Workflow - Example/Use Case
  • Demo: Use-case to retrieve data using Data Query as a workflow task
  • Best Practices for Using Zuora’s Data Query
  • Module Recap
  • Module 3: End of Course
  • Rate This Course!
  • Next Steps

About this course

This course will help you get familiarized with Data Query and discuss how this feature helps with SQL based data retrieval solution that enables you to export data from your tenant by performing SQL queries.

Prerequisites: 

  • Knowledge of SQL
  • Working knowledge of any API Testing Tool - eg: Postman

Note: The target audience for this course is anyone who is configuring Zuora (Zuora admins, developers, implementers) and will need developer skills to complete some of the tasks.

Click Enter/Start Course to begin the course.

Curriculum

  • Module 1: Introduction to Data Query
  • Overview of SQL Query and Data Query
  • Why Do We Need Data Query?
  • Advantages of Data Query Over ZOQL/Export ZOQL
  • Features of Data Query
  • Module Recap
  • Module 2: Exporting Data Using Data Query
  • SQL Query Syntax in Data Query - Example/Use Case
  • Export Data Using Data Query Through API- Example/Use Case
  • Demo: To export data using Data Query through API
  • Export Data Using Data Query Through Zuora UI- Example/Use Case
  • Demo: Use-case to export data using Data Query in Zuora Platform: UI
  • Export Data Using Data Query through Workflow - Example/Use Case
  • Demo: Use-case to retrieve data using Data Query as a workflow task
  • Best Practices for Using Zuora’s Data Query
  • Module Recap
  • Module 3: End of Course
  • Rate This Course!
  • Next Steps