FETCH AND ANALYZE PEOPLESOFT DATA

Learn tips and ltechniques to fetch your data from PeopleSoft's database

What you will learn

  •  SQL
  •  Modifying queries
  •  Finding your data
  •  Effective dating
  •  Prompts
  •  Aggregate functions
  •  Query Manager
  •  Creating queries
  •  Distinct queries
  •  Criteria and conditions
  •  Hierarchy and related joins
  •  Best practices

Also Available as

WHO SHOULD ATTEND?

  • Functional analyst

  • Functional user

  • PeopleSoft Developers

  • Administrators

Certificate

Each course includes a blockchain-enabled digital certificate of achievement to prove your participation in our online course. Since this is a digital certificate, you print it, add it to your LinkedIn profile, or share it on social media!

Duration

Students typically complete this material within 20 hours.

You will have access to the videos for 60 days after purchase and may keep the accompanying activity guide for life.

RECOMMENDED PREREQUISITES

  • There are no prerequisites for this course

Course curriculum

  • 1
    Introduction
    • © Copyright
    • 💡 Hints and Definitions
    • How to use this course
  • 2
    1. Structured Query Language
    • Chapter Overview
    • Watch: SQL
    • Relational Databases and SQL
    • Tables
    • Columns (Fields)
    • Rows
    • SQL Select Statements
    • The WHERE Clause
    • The ORDER BY Clause
    • Views
    • Summary
  • 3
    2. Introduction to Query Manager
    • Chapter Overview
    • Introduction
    • Watch: Query Manager
    • Accessing Query Manager
    • Running an Existing Query
    • Editing an Existing Query
    • Walkthrough 2-1: Modify an Existing Query
    • Walkthrough 2-2: Saving Queries: Save -vs- Save As
    • Activity 2-3: Modify an Existing Query on Your Own
    • Miscellaneous Query Manager Search Page Actions
    • Walkthrough 2-4: Creating a Simple Query
    • Watch: Activity: Creating Queries
    • Activity 2-5: Creating a New Query on Your Own
    • Activity 2-6: Creating Another Query
    • Activity 2-7: Eliminating Duplicate Rows in Query Results
    • Watch: Review: Creating Queries
    • Summary
  • 4
    3. Filtering Output Data
    • Chapter Overview
    • Watch: Filtering Output Data
    • Filtering Query Results
    • Editing Criteria Properties
    • Watch: Condition Types
    • Walkthrough 3-1: Condition Types
    • Watch: Review: Condition Types
    • Watch: Effective Dated Logic
    • Effective Date Logic in PeopleSoft
    • Effective Date and Effective Sequence
    • Watch: Activity: Effective Dated Queries
    • Walkthrough 3-2: Effective Dated Table and PeopleSoft Query
    • Activity 3-3: Filter Using Exact Values
    • Activity 3-4: Filter by Ranges
    • Activity 3-5: Filter Using Exact Values #2
    • Activity 3-6: Boolean Criteria
    • Watch: Review: Filtering Activities
    • Summary
  • 5
    4. Runtime Prompts
    • Chapter Overview
    • Watch: Prompts
    • Runtime Prompts
    • Watch: Creating a Runtime Prompt
    • Defining Runtime Prompts
    • Walkthrough 4-1: Creating a Runtime Prompt
    • Activity 4-2: Employees Paid over $3,000 Monthly
    • Activity 4-3: Employees Paid over $3,000 Monthly with Prompts
    • Walkthrough 4-4: Date Prompts
    • Watch: Review: Prompt Activities
    • Summary
  • 6
    5. Working with Multiple Tables
    • Chapter Overview
    • Watch: Working with Multiple Tables
    • Tables and Views
    • Joins
    • Record Hierarchy and Related Record Joins
    • Watch: Creating a Single Query with Multiple Tables
    • Walkthrough 5-1: Creating a Single Query with Multiple Tables
    • Watch: Review: Creating a Single Query with Multiple Tables
    • Activity 5-2: Create Your Own Joins
    • Watch: Joins
    • Watch: Review: Countries that Don't have a State
    • Watch: Null versus Spaces
    • Watch: Activity: Find Orphaned Security Rows
    • Watch: Review: Find Orphaned Security Rows
    • Summary
  • 7
    6. Using aggregate Functions
    • Chapter Overview
    • Watch: Aggregate Functions
    • What are Aggregate Functions?
    • Walkthrough 6-1: Aggregate Function – Count()
    • Walkthrough 6-2: Aggregate Function – Sum()
    • Activity 6-3: Using Aggregate Functions
    • Activity 6-4: More Aggregate Functions
    • Walkthrough 6-5: Having Criteria
    • Watch: Having Criteria
    • Activity 6-6: Employees per Department
    • Summary
  • 8
    7. Query Viewer and Scheduler
    • Chapter Overview
    • Watch: Query Viewer
    • Query Viewer
    • Scheduling Queries
    • Summary
  • 9
    Appendix A: Where is My Data?
    • Appendix A: Where is my Data?
  • 10
    Next Steps
    • Course Survey