The two-day course provides a practical, hands-on introduction to SQL and SQR development in a PeopleSoft environment. Participants will learn to retrieve and manipulate data using robust SQL techniques, including SELECT statements, joins, subqueries, and group functions. The course also explores performance tuning fundamentals to enhance SQL efficiency.
The second half, attendees will dive into SQR programming—understanding program structure, working with variables, generating formatted output, using SQC libraries, and setting up process definitions. Real-world examples and debugging tips will prepare learners to build and troubleshoot PeopleSoft reports with confidence.
Ideal for developers, analysts, and technical support staff seeking to deepen their PeopleSoft data reporting and programming expertise.
