PeopleSoft - Course Details

PSPTSQRR853 PeopleSoft PeopleTools SQR Rel 8.53

PeopleSoft Course Description:
This course emphasizes the importance of SQL and the PeopleSoft application database structure, as well as how the two can be used in the SQR programming environment. Learn practical solutions for business rules-related requests for reports.
PeopleSoft Course Duration:
5 Days Training
PeopleSoft Course Target Audience:
Application Developers, Developer,Reports Developer
PeopleSoft Course Prerequisite:
PeopleSoft PeopleTools II Rel 8.53 Ed 1, An understanding of programming basics,PeopleSoft PeopleTools I Rel 8.53 Ed 1,Familiarity with SQL
Course Content:
  • Getting Started with SQL and SQR
  • Exploring an SQR Program
  • 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
  • Using Lookup Tables
  • Working with External Data
  • Adding an SQR Program to the Process Scheduler
  • Prompting for User Input
  • Creating Dynamic SQL
  • Using Printer Commands
  • Creating Multiple Reports
  • Using Interoperability Features
  • Using HTML and Miscellaneous Functions
  • Debugging and Tuning SQR Programs