Table of Contents: (click on "SHOW MORE" and click on the time links to advance to that topic)
Query Basics
What is a query? @0:19
How is data stored? @0:42
A Query @2:35
Create & Run the query @3:20
PeopleSoft Queries @3:49
What is PeopleSoft query @4:05
PeopleSoft Query Structure @5:24
Database Elements: Records @6:31
Database Elements: Fields @7:49
Database Elements: Row @9:02
Database Elements: Keys @9:26
Joining Records @10:15
Joining: without using a key @11:25
Joining: using a key field @11:55
Join: Table Relationships @12:27
Join: Hierarchical & Related Record Relationship @13:08
Query Properties: Criterion @13:56
Effective-Dated Tables @14:54
Using Prompts in queries @16:50
PeopleSoft Security @17:28
PeopleSoft Query Options @18:55
