PeopleSoft - Course Details

PSSQRR850 PeopleSoft SQR Rel 8.50

PeopleSoft Course Description:
The course emphasizes the importance of SQL and the PeopleSoft application database structure, and how the two can be used in the SQR programming environment. The course provides participants with practical solutions to business rules-related requests for reports.
PeopleSoft Course Duration:
5 Days Training
PeopleSoft Course Target Audience:
Application Developers,Reports Developer,Developer
PeopleSoft Course Prerequisite:
PeopleSoft PeopleTools II Rel 8.50 Ed 1,PeopleSoft PeopleTools I Rel 8.50 Ed 1,An understanding of programming basics,Familiarity with SQL
Course Content:
Getting Started with SQL and SQR,
Exploring an SQR Program File,
Printing in SQR,
Using SQR Variables and Program Flow Commands,
Manipulating String, Date, and Numeric Data.
Advanced Printing with SQR.
Using Arrays.
Using Business Chart Graphics.
Implementing SQC Files and Local Procedures.
Debugging and Tuning SQR Programs.
Using HTML and Miscellaneous Functions.
Using Interoperability Features.
Creating Multiple Reports.
Using Printer Commands.
Creating Dynamic SQL
Prompting for User Input.
Adding an SQR Program to the Process Scheduler.
Working with External Data.
Using Lookup Tables