Oracle/PeopleSoft Query Reporting Tools Ed 1

PeopleSoft Query Reporting Tools Ed 1 Certification Training Course Overview

Enrol in this 3-day course from Koenig Solutions accredited by Oracle. In this course helps you to understand and use PeopleSoft query reporting tools to extract the precise information you need from your PeopleSoft database to create reports and visual representations of your data, without having to write SQL statements.

This PeopleSoft Query Reporting Tools training covers the following PeopleSoft query reporting tools: 

  • Simple Query
  • Composite Query
  • Connected Query

Target Audience:

 

  • Developer
  • End User
  • Manager
  • Suitable for students using PeopleTools 8.54 or later.

Learning Objectives:

  • Perform PeopleSoft Query administrative tasks
  • Create expressions
  • Use drilling URLs
  • Implement standard joins
  • Work with unions
  • Use subqueries
  • Perform left outer joins
  • Use Composite Query
  • Use Connected Query
  • Describe query reporting
  • Create simple queries
  • Filter output with criteria and runtime prompts
  • Work with multiple tables
  • Use summary calculations

PeopleSoft Query Reporting Tools Ed 1 (8 Hours) Download Course Contents

Live Virtual Classroom Fee On Request
Group Training Date On Request
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Filtering Output with Runtime Prompts
  • Creating Runtime Prompts
  • Creating Multiple Runtime Prompts
Module 2: Using Summary Calculations
  • Aggregate Functions and Having Criteria
  • Using Predefined Aggregate Functions
Module 3: Performing PeopleSoft Query Administrative Tasks
  • Running a Query from Query Viewer
  • Scheduling a Query
  • Monitoring Query Performance and Use
Module 4: Working with Unions
  • Using Literals as Placeholder Fields
  • Creating Unions
  • Viewing Union SQL
Module 5: Using Composite Query
  • Editing, Copying and Deleting Composite Queries
  • Adding Additional Base Queries to Composite Queries
  • Adding Runtime Prompts to Composite Queries
  • Adding Drilling URLs to Composite Queries
Module 6: Using Connected Query
  • Using Connected Query Quick Start
  • Using Connected Query Manager
Download Course Contents

Request More Information

Course Prerequisites
  • Basic Computer Knowledge.