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

GUARANTEED, 13-Dec-2023 - 15-Dec-2023, 8:00AM - 4:00PM US Pacific
SCHEDULED, 12-Feb-2024 - 14-Feb-2024, 09:00 AM - 05:00 PM US Pacific
SCHEDULED, 29-May-2024 - 31-May-2024, 09:00 AM - 05:00 PM US Eastern
SCHEDULED, 01-May-2024 - 03-May-2024, 09:00 AM - 05:00 PM US Eastern
SCHEDULED, 29-Jul-2024 - 31-Jul-2024, 09:00 AM - 05:00 PM US Eastern
Choose an option
PeopleSoft Query Reporting Tools – GUARANTEED, 13-Dec-2023 - 15-Dec-2023, 8:00AM - 4:00PM US Pacific
$3,600.00
PeopleSoft Query Reporting Tools – SCHEDULED, 12-Feb-2024 - 14-Feb-2024, 09:00 AM - 05:00 PM US Pacific
$3,600.00
PeopleSoft Query Reporting Tools – SCHEDULED, 29-May-2024 - 31-May-2024, 09:00 AM - 05:00 PM US Eastern
$3,600.00
PeopleSoft Query Reporting Tools – SCHEDULED, 01-May-2024 - 03-May-2024, 09:00 AM - 05:00 PM US Eastern
$3,600.00
PeopleSoft Query Reporting Tools – SCHEDULED, 29-Jul-2024 - 31-Jul-2024, 09:00 AM - 05:00 PM US Eastern
$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