PeopleSoft - Course Details

PSQV8.5 PeopleSoft Query Reporting Rel 8.50

PeopleSoft Course Description:
The Query Advanced portion of this course teaches you to create complex online reports. You learn advanced techniques to view the exact data that you need, use expressions to perform configurable online calculations, and combine data from unrelated tables or multiple queries to return one set of data.
PeopleSoft Course Duration:
2 Days Training
PeopleSoft Course Target Audience:
End Users,Project Manager,Reports Developer
PeopleSoft Course Prerequisite:
Basic knowledge of PeopleSoft navigation, PeopleSoft concepts, and PeopleSoft Architecture
Course Content:
  • Using Query Manager Searching for Existing Queries Editing Existing Queries

  • Creating a Simple Query

  • Filtering Output with Criteria

  • Filtering Output with Runtime Prompts

  • Working with Multiple Tables

  • Using Summary Calculations

  • Performing Administrative Tasks

  • Creating Expressions

  • Drilling URLs in PeopleSoft Query

  • Implementing Any Joins

  • Using Sub queries

  • Working with Unions

  • Performing an Outer Join

  • Using Connected Query