PeopleSoft Query Reporting Tools Ed 1

This PeopleSoft Query Reporting Tools training teaches you how to design and run query reports using PeopleSoft Query, Composite Query, and Connected Query in a PeopleTools environment. You learn how to create queries, filter and refine output, run and download query data to popular output formats, and more.

Prerequisite skills include

  • PeopleSoft PeopleTools I
  • Working knowledge of the PeopleTools development environment.

Suggested Prerequisites

  • PeopleSoft PeopleTools II
  • Experience developing PeopleSoft applications.
  • Programming experience, preferably in an object-oriented language.

STUDENTS WILL LEARN TO

  • 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
Phone
Phone
Product
Oracle
Code
D105740GC10
Duration
3 Days
Price (baht)
42,300

About the course

COURSE TOPICS

Module 1 : Query Reporting Tools Course Overview

  • Query Reporting Tools Course Overview

Module 2 : Query Reporting Tools Technology Overview

  • Query Reporting Tools Technology Overview

Module 3 : Working with PeopleSoft Query

  • Working with PeopleSoft Query
  • Ordering and Sorting Column Data
  • Activity 1: Working with Existing Queries

Module 4 : Creating a Simple Query

  • Creating a Simple Query
  • Query Properties
  • Editing Field Properties in Existing Queries
  • Activity 2: Creating a New Query
  • Activity 3: Editing Field Properties
  • Activity 4: Removing Duplicate Data

Module 5 : Filtering Output with Criteria

  • Filtering Output with Criteria
  • Understanding Adding Criteria to Queries
  • Adding Criteria Using Commonly Used Condition Types
  • Using Multiple Criteria Statements
  • Using the Effective Date Field in Criteria
  • Activity 5: Adding Rows of Criteria
  • Activity 6: Creating Queries with Multiple Criteria
  • Activity 7: Creating Queries with Effective-Dated Criteria

Module 6 : Filtering Output with Runtime Prompts

  • Filtering Output with Runtime Prompts
  • Activity 8: Creating Runtime Prompts
  • Activity 9: Enhancing Queries with Multiple Prompts
  • Activity 10: Creating Date Range Prompts

Module 7 : Working with Multiple Tables

  • Working with Multiple Tables
  • Related-Record Joins
  • Activity 11: Accessing Data in Multiple Tables

Module 8 : Using Summary Calculations

  • Using Summary Calculations
  • Activity 12: Applying the Average Aggregate Function
  • Activity 13: Using the Having Criteria in Queries
  • Activity 14: Creating Queries with Complex Join Criteria Aggregates

Module 9 : Performing PeopleSoft Query Administrative Tasks

  • Performing PeopleSoft Query Administrative Tasks
  • Monitoring Query Performance and Use
  • Activity 15: Scheduling and Monitoring Queries
  • Activity 16: Using Query Administration

Module 10 : Creating Expressions

  • Creating Expressions
  • Using Literals in Expressions
  • Using Expressions in Criteria
  • Activity 17: Creating Simple Expressions
  • Activity 18: Using the SUBSTR Function in Expressions
  • Activity 19: Using Aggregate Functions in Expressions

Module 11 : Drilling URLs in PeopleSoft Query

  • Drilling URLs in PeopleSoft Query
  • Activity 20: Defining Free-Form Drilling URL for an Existing Query
  • Activity 21: Defining a REST Drilling URL for an Existing Query

Module 12 : Implementing Standard Joins

  • Implementing Standard Joins
  • Activity 22: Joining Multiple Records
  • Activity 23: Using Advanced Selection Criteria

Module 13 : Using Subqueries

  • Using Subqueries
  • Creating an In-List or Not-In-List Subquery
  • Creating an Exists or Does-Not-Exist Subquery
  • Activity 24: Creating Subqueries
  • Activity 25: Creating a Not-In-List Subquery
  • Activity 26: Creating a Does-Not-Exist (True/False) Subquery

Module 14 : Working with Unions

  • Working with Unions
  • Activity 27: Creating Queries with Unions
  • Activity 28: Using Joins in Unions

Module 15 : Performing Left Outer Joins

  • Performing Left Outer Joins
  • Activity 29: Creating a Left Outer Join

Module 16 : Using Composite Query

  • Using Composite Query
  • Adding Additional Base Queries to Composite Queries
  • Adding Drilling URLs to Composite Queries
  • Activity 30: Creating Basic Composite Queries
  • Activity 31: Applying Field Aggregates to Composite Queries
  • Activity 32: Adding Additional Queries and Filtering Criteria to Composite Queries
  • Activity 33: Adding Runtime Prompts to Composite Queries
  • Activity 34: Adding Component Drilling URLs to Composite Queries

Module 17 : Using Connected Query

  • Using Connected Query
  • Using Connected Query Manager
  • Activity 35: Using Connected Query Quick Start
  • Activity 36: Using Connected Query Manager and Connected Query Viewer

Module 18 : Query Reporting Tools Course Review

  • Query Reporting Tools Course Review

Register for Training

Schedule

Start DateEnd DateDuration (days)PriceRegisterCourseCodeProduct

เราใช้คุกกี้เพื่อพัฒนาประสิทธิภาพ และประสบการณ์ที่ดีในการใช้เว็บไซต์ของคุณ คุณสามารถศึกษารายละเอียดได้ที่ นโยบายความเป็นส่วนตัว และสามารถจัดการความเป็นส่วนตัวเองได้ของคุณได้เองโดยคลิกที่ ตั้งค่า

Privacy Preferences

คุณสามารถเลือกการตั้งค่าคุกกี้โดยเปิด/ปิด คุกกี้ในแต่ละประเภทได้ตามความต้องการ ยกเว้น คุกกี้ที่จำเป็น

Allow All
Manage Consent Preferences
  • Always Active

Save