FORGOT YOUR DETAILS?

eluide9eb7f5d

PeopleSoft Query Reporting Tools

Cost
$3600 USD
Course Code
D105738GC10
Duration
3 Days
Format
Live Virtual Class

Course Schedule

PeopleSoft Query Reporting Tools

$3,600.00

Scheduled, 01-Aug-2022 - 03-Aug-2022, 09:00 AM - 05:00 PM US Eastern
Scheduled, 13-Dec-2022 - 15-Dec-2022, 09:00 AM - 05:00 PM US Eastern
Scheduled, 13-Feb-2023 - 15-Feb-2023, 09:00 AM - 05:00 PM US Pacific
Scheduled, 30-May-2023 - 01-Jun-2023, 09:00 AM - 05:00 PM US Eastern
Choose an option
PeopleSoft Query Reporting Tools – Scheduled, 01-Aug-2022 - 03-Aug-2022, 09:00 AM - 05:00 PM US Eastern
$3,600.00
PeopleSoft Query Reporting Tools – Scheduled, 13-Dec-2022 - 15-Dec-2022, 09:00 AM - 05:00 PM US Eastern
$3,600.00
PeopleSoft Query Reporting Tools – Scheduled, 13-Feb-2023 - 15-Feb-2023, 09:00 AM - 05:00 PM US Pacific
$3,600.00
PeopleSoft Query Reporting Tools – Scheduled, 30-May-2023 - 01-Jun-2023, 09:00 AM - 05:00 PM US Eastern
$3,600.00
Clear

Overview

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.

Audience

  • Developer
  • End User
  • Manager

Suggested Prerequisites

  • Working knowledge of the PeopleTools development environment
  • PeopleSoft PeopleTools I

Topics

  • Technology Overview
  • Working with PeopleSoft Query
  • Creating a Simple Query
  • Filtering Output with Criteria
  • Filtering Output with Runtime Prompts
  • Working with Multiple Tables
  • Using Summary Calculations
  • Performing PeopleSoft Query Administrative Tasks
  • Creating Expressions
  • Drilling URLs in PeopleSoft Query
  • Implementing Standard joins
  • Using Subqueries
  • Working with Unions
  • Performing Left Outer Joins
  • Using Composite Query
  • Using Connected Query

Overview

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.

Audience

  • Developer
  • End User
  • Manager

Suggested Prerequisites

  • Working knowledge of the PeopleTools development environment
  • PeopleSoft PeopleTools I

Topics

  • Technology Overview
  • Working with PeopleSoft Query
  • Creating a Simple Query
  • Filtering Output with Criteria
  • Filtering Output with Runtime Prompts
  • Working with Multiple Tables
  • Using Summary Calculations
  • Performing PeopleSoft Query Administrative Tasks
  • Creating Expressions
  • Drilling URLs in PeopleSoft Query
  • Implementing Standard joins
  • Using Subqueries
  • Working with Unions
  • Performing Left Outer Joins
  • Using Composite Query
  • Using Connected Query

Related Courses…

TOP
0