Name: Query Reporting Rel 8.48
Course Code: ORPS19237
Duration: 2
Scheduled Dates for ORPS19237
This two-day course combines the query basic and advanced classes. Day one gives students a fast track introduction to building simple queries using PeopleSoft's Query Manager Tool. Students learn how to create ad-hoc queries/reports to meet their immediate needs without submitting an IS request. Day two introduces you to Query Manager's advanced functionality, including user-defined expressions. In addition you learn how to use the Any Join feature, Unions, Subqueries, Outer Joins, and other new features from Query Manager 8.40.
Target Audience
Reports Developer
End Users
Functional Implementer
Key Topics
- Using Query Manager
- Creating a Simple Query
- Filtering Output with Criteria
- Filtering Output with Runtime Prompts
- Working with Multiple Tables
- Using Summary Calculations
- Performing Administrative Tasks
- Creating Expressions
- Implementing Any Joins
- Using Sub-queries
- Working with Unions
- Performing an Outer Join
Objectives
- Use Query Manager
- Create a simple query
- Specify the retrieved output
- Use prompts to filter data
- Work with multiple tables
- Use summary calculations
- Perform administrative tasks
- Create expressions
- Use the Any Join feature
- Use sub-queries
- Work with unions
- Perform outer joins
Required Skills/Experience
- Basic understanding of relational databases.
Fee: $1,500.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
