PeopleSoft Query Reporting Tools Ed 1

Cost $3,600

Course Code
D105738GC10

Duration
3 days

Format
Live Virtual Class

What you will learn

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.

Prerequisites

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

Audience

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

Objectives

  • Perform PeopleSoft Query administrative tasks
  • Create expressions
  • Use drilling URLs
  • Implement standard joins
  • Work with unions
  • Use subqueries
  • Perform left outer joins
  • Use Composite Query
  • Use Connected Query
  • Describe query reporting
  • Create simple queries
  • Filter output with criteria and runtime prompts
  • Work with multiple tables
  • Use summary calculations

Topics

  • Filtering Output with Runtime Prompts
    • Creating Runtime Prompts
    • Creating Multiple Runtime Prompts
  • Using Summary Calculations
    • Aggregate Functions and Having Criteria
    • Using Predefined Aggregate Functions
  • Performing PeopleSoft Query Administrative Tasks
    • Running a Query from Query Viewer
    • Scheduling a Query
    • Monitoring Query Performance and Use

 

  • Working with Unions
    • Using Literals as Placeholder Fields
    • Creating Unions
    • Viewing Union SQL
  • Using Composite Query
    • Editing, Copying and Deleting Composite Queries
    • Adding Additional Base Queries to Composite Queries
    • Adding Runtime Prompts to Composite Queries
    • Adding Drilling URLs to Composite Queries
  • Using Connected Query
    • Using Connected Query Quick Start
    • Using Connected Query Manager

Enroll for PeopleSoft Query Reporting Tools Ed 1

PeopleSoft Query Reporting Tools Ed 1

$3,600.00

Clear
SKU: D105738GC10 Categories: ,

Additional information

Schedules

GTR – Sep 8 2021 – Sep 10 2021 (3 days) 9:00 AM – 5:00 PM US-Eastern, GTR – Nov 22 2021 – Nov 24 2021 (3 days) 9:00 AM – 5:00 PM US-Eastern, Feb 15 2022 – Feb 17 2022 (3 days) 9:00 AM – 5:00 PM US-Pacific, Aug 15 2022 – Aug 17 2022 (3 days) 9:00 AM – 5:00PM US-Eastern

Format

Live Virtual Class

Reviews

There are no reviews yet.

Be the first to review “PeopleSoft Query Reporting Tools Ed 1”

Your email address will not be published. Required fields are marked *

No products were found matching your selection.

Follow-on Courses

Browse the suggested follow-on courses below and continue your training journey. We offer training in various learning formats, from instructor-led to virtual, so you can choose what works best for you. Get started by selecting a course to learn more.

No products were found matching your selection.

TOP
0