What You Always Wanted to Know about Microsoft Azure Certifications - Live Webinar

closeClose

PeopleSoft Query Reporting Tools

Course Details
Code: PPL-QRY-RPT
Tuition (USD): $2,772.00 • Virtual (3 days)
$2,931.00 • Classroom (3 days)

Applies to 8.57

This PeopleSoft Query Reporting Tools training covers the following PeopleSoft query reporting tools: 

  • Simple Query
  • Composite Query
  • Connected Query

Learn To:

  • Filter output with criteria and runtime prompts.
  • Work with multiple tables and summary calculations.
  • Perform PeopleSoft Query administrative tasks.
  • Create expressions, drilling URLs, standard joins and left outer joins.
  • Use aggregate functions, subqueries, and unions.
  • Run and download query data to popular output formats, including HTML, Microsoft Excel, XML, and CSV formats. 
  • Schedule queries to run at specified times.

Benefits to You

Enrolling in this course helps you to understand and use PeopleSoft query reporting tools to extract the precise information you need from your PeopleSoft database to create reports and visual representations of your data, without having to write SQL statements.


Skills Gained

  • Filter output with criteria and runtime prompts.
  • Work with multiple tables and summary calculations.
  • Perform PeopleSoft Query administrative tasks.
  • Create expressions, drilling URLs, standard joins and left outer joins.
  • Use aggregate functions, subqueries, and unions.
  • Run and download query data to popular output formats, including HTML, Microsoft Excel, XML, and CSV formats.
  • Schedule queries to run at specified times.

Who Can Benefit

  • Developer
  • End User
  • Manager
  • Suitable for students using PeopleTools 8.54 or later.

Prerequisites

  • PeopleSoft PeopleTools I
  • PeopleSoft PeopleTools II
  • Programming experience, preferably in an object-oriented language.
  • Working knowledge of the PeopleTools development environment.

Course Details

Course Outline

  • Filtering Output with Runtime Prompts
  • Using Summary Calculations
  • Performing PeopleSoft Query Administrative Tasks
  • Working with Unions
  • Using Composite Query
  • Using Connected Query
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward