Training Spotlight: Intermediate to PeopleSoft Query and Advanced PeopleSoft Query

Intermediate to PeopleSoft Query, Oct. 9

It is open to experienced PeopleSoft Query users who have completed the Introduction to PeopleSoft Query training. Topics covered will include expressions and functions (operators, data fields, data conversion), complex criteria (use of Like, In List, condition types, grouping), the XLAT table (what is it, how it works), advanced prompts using prompt tables, simple unions and subqueries and case studies of interesting queries. Learn more and register on Eventbrite.

 

Advanced PeopleSoft Query, Oct. 17

It is open to experienced PeopleSoft Query users who have completed the Intermediate PeopleSoft Query training. Topics covered will include subqueries (Exist/Not Exist, In List/Not In List, other condition types), the Case statement (If-Then-Else logic), union queries and outer joins, case studies (the “movement” queries and more), and aggregates (create and Q/C aggregate queries). Learn more and register on Eventbrite.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s