PeopleSoft People Tools SQR Rel 8.53

Duration : 5 Days

What you will learn

This five-day PeopleSoft SQR Rel 8.53 training equips you with the knowledge and skills to understand the fundamentals of the Structured Query Report (SQR) language and to use SQR for PeopleSoft for reporting and batch processing.

Learn to:

Perform reporting and batch processing.

Format reports, use variables and write procedures to develop modular reusable code.

Use an array and business chart.

Produce multiple reports and create dynamic SQL.

Understand the fundamentals of the Structured Query Report (SQR) language.

Use interoperability features, National Language Support and HTML.

Develop modular reusable code and prompt for user input.

Explore SQL & PeopleSoft Database Structure

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.


  • Application Developers
  • Developer
  • Reports Developer

Related Training

Required Prerequisites

  • PeopleSoft PeopleTools II Rel 8.53 Ed 1
  • PeopleSoft PeopleTools I Rel 8.53 Ed 1
  • PeopleSoft PeopleTools I Rel 8.53
  • PeopleSoft PeopleTools II Rel 8.53

Suggested Prerequisites

  • An understanding of programming basics
  • Familiarity with SQL

Course Objectives

  • Using HTML and Miscellaneous Functions
  • Exploring an SQR Program File
  • Creating Multiple Reports
  • Using Interoperability Features
  • Printing in SQR
  • Using SQR Variables and Program Flow Commands
  • Advanced Printing with SQR
  • Using Arrays
  • Using Business Chart Graphics
  • Implementing SQC Files and Local Procedures
  • Working with External Data
  • Using Lookup Tables
  • Working with External Data
  • Prompting for User Input
  • Creating Dynamic SQL

Course Outline :

Popular Courses

Related Courses


Thank you EZY Intellect and Trainer for your support to become an Oracle Certified Professional

thumb Mr. Tint Aung Shwe
Assistant Manager (IT Department)-AYA Bank,August 29, 2017

This training helped me identify clear and do-able next steps toward my goal. Thank you EZY Intellect and Mr.Kushantha ( EC-Council Certified Trainer) for very valuable training.

thumb Mr. Kyaw Htet
CEH V10,21,22,23,29,30 Sep 2018