fbpx

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

Already a member? Log in.

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

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.

① 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.

Loading Events

« All Events

  • This event has passed.

PeopleSoft Query 1

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

Learn PeopleSoft Query Basics

Learn PeopleSoft Query

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

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!

Enroll

Tickets

The numbers below include tickets for this event already in your cart. Clicking “Get Tickets” will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available