This session reviews query basics for new users. It provides a listing of frequently used tables and fields. We will also review some “generic” queries. These queries serve two purposes: (1) to allow staff members who do not have query manager to get data quickly and easily without having to ask for a new query, and (2) to provide a basis for more complex queries (i.e. do not need to start from scratch).
If time permits, we will dig into more advanced topics, such as case statements in expressions, in-list or not-in-list with subqueries and unions.
https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=ad10bad6-e27b-4c39-9ce8-26c6b65ca526
#Ellen_Fishman#Theresa_Allen#PSQuery#Basics#New_staff
HEUG is a 501(c)(3) nonprofit dedicated to helping member institutions manage administrative technologies that improve the student and user experience. We support the people who select, deploy, integrate, and manage the systems that run higher ed, through education, professional resources, and peer connection.
As the landscape keeps evolving, we adapt with it, while staying committed to our core mission of connection, education, and advocacy.
Membership is free for higher ed institutions. Whether it's one login or your whole campus, the answers, the savings, and the people are waiting.
Higher Education User GroupMesa, AZ 85212 United States
support@heug.org
M-F 8 AM to 5 PM MST
Join HEUG
Community Council
Interest Areas
Resources
Alliance Conference
Global Meetings
Online Webinars
Code of Conduct
Privacy Policy
Terms of Service
Copyright 2026 Higher Education User Group, Inc.
Copyright © 2026 Higher Education User Group, Inc.