PS Query & SQL

If you're a technical or functional user that is looking to learn the ins and outs of Query Manager, this session is for you. If you are confident in your ability to write queries to determine how many students are ready to matriculate, or have their financial aid packaged; and are looking for ways to be more sophisticated in your data retrieval, then this is the session is also for you!

We will begin with some basic tips and tricks for query writing, and then move to some more complicated topics, like creating smart prompts, or using expressions wisely. Finally, we discuss some advanced topics such as using query manager on 4-tier vs using query builder tool within Application Designer for PeopleTools 8.55. We will end on some tips and tricks to make sure that anything you do with the system keeps your information safe and secure, and keeps your database from spinning out of control.

Topics Covered will include:
1. Introduction – What is a relational database? | Why Do We Query?
2. Queries – The Basics – A Most Basic Query | Query Tools
3. A Tab-by-Tab Explanation of Query Manager
4. Understanding Joins
5. Manipulating Data with Expressions
6. Aggregating Data
7. Sub Queries
8. Unions in Query
9. Drilling URLs
10. A Brief Introduction to Composite Query
10. Query Administration
11. Tips and Tricks
12. Things to Remember

https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=f131b902-98f9-4bd2-aba4-dc0eb89d7089

#Technical
#Functional
#PSQuery
#101