We will cover:- Subqueries- Unions- Drilling URLs- Composite Query- Intermediate to Advanced Expressions that can help you get the most out of your Query. We will look at using expressions as fields, using regular expressions to identify patterns, count information, and replace data in queries, using ListAgg to consolidate data into columns rather than multiple rows (and how to remove duplicates from ListAgg) and cover using case statements, decode, etc.
https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=4a2b4b26-29fe-41dc-b0b4-18b6fa855603
The Higher Education User Group (HEUG) is a 501(c)(3) nonprofit dedicated to helping member institutions effectively manage administrative technologies to improve the student and user experience. We support executives, managers, and staff who select, deploy, integrate, and manage multiple systems by providing education, professional resources, and opportunities to connect with peers. As the digital landscape continues to evolve, HEUG adapts to meet the changing needs of its members while remaining committed to its core mission of connection, education, and advocacy.
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.