Log in

Please log in to continue.

Register

Fantastic! Before you enroll, do you have an account with us? If so, please log in to continue. Otherwise, we have a simple three-step process:

① REGISTER

② Confirm your e-mail Address

③ Purchase this course

① REGISTER

Already a member? Log in.

Name *

First

Last

Username *

A username may contain letters, numbers, spaces, underscores, hyphens, periods, and the @ symbol

Email *

Password *

Password

Confirm Password

Phone *

Shipping Address *

Address Line 1

Address Line 2

City

State / Province / Region

Postal Code

Country

We love to send gifts! Which beverage(s) do you prefer? *

Coffee
Hot Chocolate
Tea
Lemonade

I acknowledge that I have read and agree to abide by the the Terms and Conditions

By clicking register, I agree to receive communications from JSMpros. I understand that I can opt-out of communications at any time and that opting out may result in missed notices regarding my account.

Please prove you are human by solving a simple puzzle *

① LOG IN

Login

② Confirm your e-mail Address

Check your e-mail (and spam/junk) for an e-mail from us asking you to confirm your e-mail address. After confirmation, return to this dialog to complete step 3: Enroll in this course.

③ Purchase this course

Check your e-mail (and spam/junk) for an e-mail from us asking you to confirm your e-mail address. After confirmation, return to this dialog to complete step 3: Enroll in this course.

Begin Purchase

« All Events

This event has passed.

PeopleSoft Query 1

Name: PeopleSoft Query 1
Start: 2025-02-24T09:00:00-06:00
End: 2025-02-25T17:00:00-06:00

February 24, 2025 @ 9:00 am – February 25, 2025 @ 5:00 pm CST

Learn PeopleSoft Query

SQL basics
Query Manager
Selecting data
Filtering data
Prompts
Joins
Aggregate functions

Enroll

PeopleSoft Query is more than just an ad-hoc reporting tool. PeopleSoft Query is a foundational development tool for search indexes, integration points, security role rules, reports, pivot grids, user lists, and much more!

PeopleSoft Query 1 is part one of our two-part Query series and includes the topics:

Introduction to Query
Creating queries
Modifying queries
Selecting fields
Duplicate rows
Filtering results with criteria
Grouping criteria
Effective dating
Runtime prompts
Multi-table queries
Aggregate functions
Finding your data

Our PeopleTools expert, Jim Marion, facilitates this two-day training course. We provide comprehensive activity guides and access to training servers.

Login

PeopleSoft Query 1

Learn PeopleSoft Query

Who Should Attend

On-Demand

Enroll

Tickets

Related Events

Event Navigation

Log in

Register

① REGISTER

① LOG IN

Login

② Confirm your e-mail Address

③ Purchase this course

PeopleSoft Query 1

Learn PeopleSoft Query

Who Should Attend

On-Demand

Enroll

Tickets

Related Events

PeopleSoft Test Framework (PTF)

Fluid Landing Pages

Fluid 1: The Basics of Fluid

Event Navigation