- 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
-
DEMO: Data Query UI walkthrough
-
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: Data Query Use Cases - Deep Dive
-
DEMO: Retrieving Data Periodically
-
DEMO: Tracing a Charge Type Using Inner Join
-
DEMO: Retrieving Top Five Accounts With the Highest Subscription Count Using Index Join
-
DEMO: Finding the Included Units for Quarterly and Annual Overage Pricing
-
DEMO: Creating Credit Memos for Referral Bonus
-
DEMO: Generating an Open Invoice With the Overdue Date
-
Rate This Course!
-
Next Steps
Course 4: Data Query - A Complete Guide
Get an overview of Data Query and learn how it benefits both business and end subscribers.
Welcome to the Data Query - A Complete Guide course. This is the fourth course of a series of courses in the Advanced APIs Learning Path and will guide you on how to use Zuora’s Data Query feature. A subscription-based business can benefit greatly from reporting and data analysis used to understand the business. Using realistic scenarios, this course will illustrate how to write queries to extract data from Zuora objects.
By the end of this course, you'll be able to:
- List the benefits of using Zuora Data Query
- Identify the basic features and functions of Data Query
- Explain how to use Data Query
- Explain steps to export data using Data Query through REST API, Zuora UI and Workflow tasks
- List the limitations of query processing
- Describe various scenarios in which Data Query can be useful
- Execute queries for a few common use cases
Click the Enter button above to start.