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, May.27.2024 - May.29.2024 (3 days), 09:00 AM - 05:00 PM US Eastern
SCHEDULED, Jul.29.2024 - Jul.31.2024 (3 days), 09:00 AM - 05:00 PM US Eastern
SCHEDULED, Nov.18.2024 - Nov.20.2024 (3 days), 09:00 AM - 05:00 PM US Pacific
SCHEDULED, Jan.08.2025 - Jan.10.2025 (3 days), 09:00 AM - 05:00 PM US Eastern
SCHEDULED, Mar.31.2025 - Apr.02.2025 (3 days), 09:00 AM - 05:00 PM US Eastern
$3,600.00
$3,600.00
$3,600.00
$3,600.00
$3,600.00

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 (suggested not required)

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 (suggested not required)

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