Query Basics Rel 8.48
Seminar
In München
Beschreibung
-
Kursart
Seminar
-
Niveau
Anfänger
-
Ort
München
-
Dauer
1 Tag
This course teaches you to create online reports using PeopleSoft Query. Many users who need to retrieve the stored information are not comfortable with programming. With PeopleSoft Query, you can extract the precise information that you're looking for using visual representations of the PeopleSoft database without writing Structured Query Language (SQL) statements.By Learning to use PeopleSof.. Gerichtet an: Endbenutzer
Standorte und Zeitplan
Lage
Beginn
Beginn
Hinweise zu diesem Kurs
Empfohlene Vorkenntnisse:- Working knowledge of PeopleSoft Architecture - Understanding of your company's Reporting requirements
Meinungen
Inhalte
This course teaches you to create online reports using PeopleSoft Query. Many users who need to retrieve the stored information are not comfortable with programming. With PeopleSoft Query, you can extract the precise information that you''re looking for using visual representations of the PeopleSoft database without writing Structured Query Language (SQL) statements.By Learning to use PeopleSoft Query, you can view the precise data that you need. Learn to design reports that use criteria to filter data or that use predefined online calculations. Learn to create reports with runtime prompts which builds flexibility and reusability into your reports and decreases your report design time. Also, learn to schedule your queries to run while you are away so that your reports always run on time.
Learn To: - View data online - Build private queries - Run queries as HTML reports - Share public queries
Zielgruppe
Endbenutzer
Seminarinhalte
o Use Query Manager o Create a simple query o Specify the retrieved output o Use prompts to filter data o Work with multiple tables o Use summary calculations o Perform administrative tasks
Sachgebiete:
Using Query Manager
- Searching for Queries - Editing Queries
Creating Simple Queries
Selecting Query Output Editing Query Properties Creating and Saving Queries Removing Duplicate Data
Filtering Output with Criteria
- Adding Criteria to Queries - Refining Criteria - Using Multiple Criteria Statements - Using the Effective Date Field in Criteria
Filtering Output with Runtime Prompts
- Describing Runtime Prompts - Creating Runtime Prompts
Working with Multiple Tables
- Describing the Purpose of Joins - Using Record-Hierarchy and Related-Record Joins
Using Summary Calculations
- Describing and Using Aggregate Functions - Describing and Using Having Criteria
Performing Administrative Tasks
- Using Query Viewer - Scheduling Queries - Monitoring Query Performance
Voraussetzungen
Empfohlene Vorkenntnisse:- Working knowledge of PeopleSoft Architecture - Understanding of your company''s Reporting requirements
Hinweis
Oracle University provides a downloadable eKit containing the training materials for this course.
Query Basics Rel 8.48