Log in

Please log in to continue.

Forgot your password? Click here to reset.

Not a member? Register Now. Registration is Free!

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.

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

Privacy Policy | Terms of Use

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.

5 + 5 =

① LOG IN

Login

Forgot Password?
Register

② 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

April 29, 2024 @ 10:00 am – April 30, 2024 @ 5:00 pm America/Chicago

Learn PeopleSoft Query Basics

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.

Who Should Attend

  • Functional Business Analysts
  • Developers

On-Demand

Prefer to learn at your own pace? Get this same training on demand!

Related Events