Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

PeopleSoft Query Reporting Tools

( Duration: 3 Days )

This PeopleSoft Query Reporting Tools training course will help 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.

By attending PeopleSoft Query Reporting Tools workshop, delegates will learn to:

  • 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

  • Basic knowledge of PeopleSoft navigation, PeopleSoft concepts, and PeopleSoft achitecture.
  • Basic knowledge of relational databases, effective-date, translated values, trees, key fields, and prompt tables.

COURSE AGENDA

1

Working with PeopleSoft Query

  • Describing PeopleSoft Query
  • Describing the Uses of the Query Manager Search Page
  • Searching for Existing Queries
  • Organizing and Managing Queries
  • Ordering and Sorting Column Data
  • Running Queries
  • Viewing Objects that use a PeopleSoft Query as a Data Source
2

Creating a Simple Query

  • Creating Simple Queries
  • Editing Field Properties
  • Removing Duplicate Data
3

Filtering Output with Criteria

  • Adding Criteria to Queries
  • Adding Criteria Using Commonly Used Condition Types
  • Using Multiple Criteria Statements
  • Using the Effective Date Field in Criteria
4

Filtering Output with Runtime Prompts

  • Describing Runtime Prompts
  • Creating Runtime Prompts
  • Creating Multiple Runtime Prompts
5

Working with Multiple Tables

  • Describing the Purpose of Joins
  • Using Record-Hierarchy and Related-Record Joins
6

Using Summary Calculations

  • Describing Aggregate Functions and Having Criteria
  • Using Predefined Aggregate Functions
  • Using the Having Criteria
7

Performing PeopleSoft Query Administrative Tasks

  • Running a Query from Query Viewer
  • Scheduling a Query
  • Monitoring Query Performance and Use
8

Creating Expressions

  • Defining Expressions
  • Creating Simple Expressions
  • Using Literals in Expressions
  • Using Functions in Expressions
  • Using Expressions in Criteria
  • Using Links in Expressions
  • Using Prompts in Expressions
  • Using Aggregates in Expressions
9

Drilling URLs in PeopleSoft Query

  • Describing Drilling URLs in PeopleSoft Query
  • Defining Query URL Widgets
  • Defining Component URL Widgets
  • Defining External URL Widgets
  • Defining Freeform URL Widgets
  • Running Queries that Have Drilling URLs Defined
  • Scheduling Queries that Have Drilling URLs Defined
10

Implementing Standard Joins

  • Explaining Standard Joins
  • Describing PeopleSoft Auto-Join
11

Using Subqueries

  • Explaining Subqueries
  • Creating a Single-Value Subquery
  • Creating an In-List or Not-In-List Subquery
  • Creating an Exists or Does-Not-Exist Subquery
12

Working with Unions

  • Explaining Unions
  • Using Literals as Placeholder Fields
  • Creating Unions
  • Viewing Union SQL
13

Performing Left Outer Joins

  • Describing Joins
  • Creating Left Outer Joins
14

Using Composite Query

  • Describing Composite Query
  • Creating Composite Queries
  • Editing, Copying and Deleting Composite Queries
  • Adding Additional Base Queries to Composite Queries
  • Adding Filtering Criteria to Composite Queries
  • Adding Runtime Prompts to Composite Queries
  • Adding Drilling URLs to Composite Queries
15

Using Connected Query

  • Describing Connected Query
  • Using Connected Query Quick Start
  • Using Connected Query Manager
  • Using Connected Query Viewer
  • Using Connected Query Scheduler

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X