Events

Query Series

The HEUG Query Series is a course made up of 4 series of multiple on-demand video recordings (5-15 min each) that allow you to expand your understanding and knowledge, learn at your own pace, in your own time and on your own schedule. Presented by top technical professionals in Higher Ed, these trainings are packed with practical examples and a wealth of knowledge that is sure to take your query skills to the next level.

Login to register.
Not a member? Request a login.

Paula McDaniel Headshot

Paula McDaniel

Washington State Board
for Community and Technical Colleges
Data Analytics Education and Learning Instructor

Jamie Polizzi Headshot

Jamie Polizzi

University of Texas at Dallas
Information Systems Analyst

Dede Young Headshot

Dede Young

Northern Illinois University
Associate Director/Registrar

Query-101

100 Series Topics

  1. Navigation & Search
  2. Query Manager Tool Overview
  3. Finding Records
  4. Creating Queries
  5. Joins
  6. Creating Prompts
  7. Criteria
Query-202

200 Series Topics

  1. Query Types & Query Record Types
  2. Aggregate Functions
  3. Having Criteria
  4. Beginning Expressions
  5. Effective Dates
  6. String Expressions
  7. Querying on Queries
Query-301

300 Series Topics

  1. Expressions
  2. Aggregate SQL Functions
  3. Analytic Functions
  4. PS Query SQL Functions
  5. Subquery Types
  6. Unions
Query-401

400 Series Topics

  1. Drilling URLs
  2. Query Security
  3. Scheduling Queries
  4. Transformations
  5. Understanding Your Data

The information provided will help users expand their understanding of how PeopleSoft query works and allow them to mature their query development skills. Especially since you are able to come back and re-watch the modules. What you may not understand the first time, might be exactly what you need to see the second (or third time) watching the section.

You're able to, in your own queries, put into practice what they present and take away practical experience from the modules . In this way, it can take you to a deeper knowledge and skill level of query development.

All sales are final. Purchases may take up to 24 hours to reflect on this page. We try to update access as soon as possible during the office hours of Monday - Friday, 8:00 AM to 5:00 PM (MST) in United States, UTC/GMT -07:00. Contact support for more help.