PeopleSoft Query Reporting Tools Ed 1

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