PeopleSoft Query Reporting Tools Ed 1
This PeopleSoft Query Reporting Tools training teaches you how to design and run query reports using PeopleSoft Query, Composite Query, and Connected Query in a PeopleTools environment. You learn how to create queries, filter and refine output, run and download query data to popular output formats, and more.
Prerequisite skills include
- PeopleSoft PeopleTools I
- Working knowledge of the PeopleTools development environment.
Suggested Prerequisites
- PeopleSoft PeopleTools II
- Experience developing PeopleSoft applications.
- Programming experience, preferably in an object-oriented language.
STUDENTS 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

Phone
|
Phone
|
---|---|
Product
|
Oracle
|
Code
|
D105740GC10
|
Duration
|
3 Days
|
Price (baht)
|
42,300
|
About the course
COURSE TOPICS
Module 1 : Query Reporting Tools Course Overview
- Query Reporting Tools Course Overview
Module 2 : Query Reporting Tools Technology Overview
- Query Reporting Tools Technology Overview
Module 3 : Working with PeopleSoft Query
- Working with PeopleSoft Query
- Ordering and Sorting Column Data
- Activity 1: Working with Existing Queries
Module 4 : Creating a Simple Query
- Creating a Simple Query
- Query Properties
- Editing Field Properties in Existing Queries
- Activity 2: Creating a New Query
- Activity 3: Editing Field Properties
- Activity 4: Removing Duplicate Data
Module 5 : Filtering Output with Criteria
- Filtering Output with Criteria
- Understanding Adding Criteria to Queries
- Adding Criteria Using Commonly Used Condition Types
- Using Multiple Criteria Statements
- Using the Effective Date Field in Criteria
- Activity 5: Adding Rows of Criteria
- Activity 6: Creating Queries with Multiple Criteria
- Activity 7: Creating Queries with Effective-Dated Criteria
Module 6 : Filtering Output with Runtime Prompts
- Filtering Output with Runtime Prompts
- Activity 8: Creating Runtime Prompts
- Activity 9: Enhancing Queries with Multiple Prompts
- Activity 10: Creating Date Range Prompts
Module 7 : Working with Multiple Tables
- Working with Multiple Tables
- Related-Record Joins
- Activity 11: Accessing Data in Multiple Tables
Module 8 : Using Summary Calculations
- Using Summary Calculations
- Activity 12: Applying the Average Aggregate Function
- Activity 13: Using the Having Criteria in Queries
- Activity 14: Creating Queries with Complex Join Criteria Aggregates
Module 9 : Performing PeopleSoft Query Administrative Tasks
- Performing PeopleSoft Query Administrative Tasks
- Monitoring Query Performance and Use
- Activity 15: Scheduling and Monitoring Queries
- Activity 16: Using Query Administration
Module 10 : Creating Expressions
- Creating Expressions
- Using Literals in Expressions
- Using Expressions in Criteria
- Activity 17: Creating Simple Expressions
- Activity 18: Using the SUBSTR Function in Expressions
- Activity 19: Using Aggregate Functions in Expressions
Module 11 : Drilling URLs in PeopleSoft Query
- Drilling URLs in PeopleSoft Query
- Activity 20: Defining Free-Form Drilling URL for an Existing Query
- Activity 21: Defining a REST Drilling URL for an Existing Query
Module 12 : Implementing Standard Joins
- Implementing Standard Joins
- Activity 22: Joining Multiple Records
- Activity 23: Using Advanced Selection Criteria
Module 13 : Using Subqueries
- Using Subqueries
- Creating an In-List or Not-In-List Subquery
- Creating an Exists or Does-Not-Exist Subquery
- Activity 24: Creating Subqueries
- Activity 25: Creating a Not-In-List Subquery
- Activity 26: Creating a Does-Not-Exist (True/False) Subquery
Module 14 : Working with Unions
- Working with Unions
- Activity 27: Creating Queries with Unions
- Activity 28: Using Joins in Unions
Module 15 : Performing Left Outer Joins
- Performing Left Outer Joins
- Activity 29: Creating a Left Outer Join
Module 16 : Using Composite Query
- Using Composite Query
- Adding Additional Base Queries to Composite Queries
- Adding Drilling URLs to Composite Queries
- Activity 30: Creating Basic Composite Queries
- Activity 31: Applying Field Aggregates to Composite Queries
- Activity 32: Adding Additional Queries and Filtering Criteria to Composite Queries
- Activity 33: Adding Runtime Prompts to Composite Queries
- Activity 34: Adding Component Drilling URLs to Composite Queries
Module 17 : Using Connected Query
- Using Connected Query
- Using Connected Query Manager
- Activity 35: Using Connected Query Quick Start
- Activity 36: Using Connected Query Manager and Connected Query Viewer
Module 18 : Query Reporting Tools Course Review
- Query Reporting Tools Course Review
Register for Training
Schedule
Start Date | End Date | Duration (days) | Price | Register | Course | Code | Product |
---|