Events

Query Series

4 series · 25 modules · 5–15 min each · Learn at your own pace

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.

Your Instructors
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
What You'll Learn
HEUG

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
HEUG

Query 201

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
HEUG

Query 301

300 Series Topics

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

Query 401

400 Series Topics

  1. Drilling URLs
  2. Query Security
  3. Scheduling Queries
  4. Transformations
  5. Understanding Your Data
Insights from the Course Creators

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.

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 office hours of Monday–Friday, 8:00 AM to 5:00 PM (MST). Contact support for more help.