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
    • 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
    • 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
    • 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
    • Summary
  • 4
    3. Filtering Output Data
    • Chapter Overview
    • Filtering Query Results
    • Editing Criteria Properties
    • Walkthrough 3-1: Condition Types
    • Effective Date Logic in PeopleSoft
    • Effective Date and Effective Sequence
    • 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
    • Summary
  • 5
    4. Runtime Prompts
    • Chapter Overview
    • Runtime Prompts
    • Defining Runtime Prompts
    • Walkthrough 4-1: Creating a Runtime Prompt
    • Activity 4-2: Unaccepted Awards
    • Activity 4-3: Unaccepted Awards with Prompts
    • Walkthrough 4-4: Date Prompts
    • Summary
  • 6
    5. Working with Multiple Tables
    • Chapter Overview
    • Tables and Views
    • Joins
    • Record Hierarchy and Related Record Joins
    • Walkthrough 5-1: Creating a Single Query with Multiple Tables
    • Activity 5-2: Create Your Own Joins
    • Summary
  • 7
    6. Using aggregate Functions
    • Chapter Overview
    • 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
    • Activity 6-6: Title IV by State
    • Summary
  • 8
    7. Query Viewer and Scheduler
    • Chapter Overview
    • Query Viewer
    • Scheduling Queries
    • Summary
  • 9
    Appendix A: Where is My Data?
    • Appendix A: Where is my Data?
  • 10
    Next Steps
    • Course Survey