New Learning | Premium Moodle Theme

PeopleSoft Query Reporting Rel 8.50 (Ed 1) Boot Camp

Description

This two-day course covers basic and advanced functions of PeopleSoft Query. You learn how to design reports that use criteria to filter data or that use predefined online calculations. You also learn to create reports with runtime prompts that build flexibility and reusability into your reports and decrease your report design time. In addition, you learn to schedule queries to run while you are away so that your reports always run on time.

The Query Advanced portion of this course teaches you to create complex online reports. You learn advanced techniques to view the exact data that you need, use expressions to perform configurable online calculations, and combine data from unrelated tables or multiple queries to return one set of data.

Learn To:
• Filter output with criteria and runtime prompts
• Work with multiple tables and summary calculations
• Perform administrative tasks
• Create expressions, drilling URLs, Any-Joins, and Outer-Join
• Use sub queries, unions, and Connected Query
• Use Query Manager

Prerequisites

Audience:
• End Users
• Project Manager
• Reports Developer

Curriculum

Using Query Manager
• Searching for Existing Queries
• Editing Existing Queries
Creating a Simple Query
• Selecting Query Output and Editing Query Properties
• Editing Field Properties
• Removing Duplicate Data
• Publishing and Using Query Feed
Filtering Output with Criteria
• Adding Criteria to Queries
• Refining Criteria
• Using Multiple Criteria Statements
• Using the Effective Date Field as Criteria
Filtering Output with Runtime Prompts
• Describing Runtime Prompts
• Creating Runtime Prompts
• Creating Multiple Runtime Prompts
Working with Multiple Tables
• Describing the Purpose of Joins
• Using Record-Hierarchy and Related-Record Joins
Using Summary Calculations
• Describing Aggregate Functions and Having Criteria
• Using Predefined Aggregate Functions
• Using Having Criteria
Performing Administrative Tasks
• Running a Query from Query Viewer
• Scheduling a Query
• Modifying Query Performance and Use
Creating Expressions
• Defining Query Expression
• Creating Simple Expressions
• Using Expressions in Criteria
• Using Links in Expressions
• Using Prompts in Expressions
• Using Aggregates in Expressions
• Using Literals in Expressions
Drilling URLs in PeopleSoft Query
• Describing Drilling URLs in PeopleSoft Query
• Viewing and Editing Expression Properties
• Running Queries that Have Drilling URLs Defined
• Scheduling Queries that Have Drilling URLs Defined
Implementing Any Joins
• Explaining Any Joins
• Creating Any Joins
Using Sub queries
• Explaining Sub queries
• Creating a Single-Value Sub query
• Creating an In-List or Not-In-List Sub query
• Creating a Exits or Does-Not-Exist Sub query
Working with Unions
• Describing Unions
• Using Literals as Placeholder Fields
• Creating Unions
• Viewing Union SQL
Performing an Outer Join
• Describing Outer Joins
• Creating Standard Outer Joins
Using Connected Query
• Describing Connected Query
• Using Connected Query Quick Start
• Using Connected Query Manager
• Using Connected Query Viewer
• Using Connected Query Scheduler

What's included?
 

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers  & Onsite Certification Testing- (excluding 1-day Adobe, 1-day MS Office and PMP Boot Camps) 
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

Training Formats

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

Instructor Led (the best training format we offer)
Live Online Classroom – Online Instructor Led
Self-Paced Video

Speak to an Admissions Representative for complete details

By far the most competitve price we found, which included exam vouchers, hands on labs, practice test and a true Master of Cyber Security concepts as our Instructor. Franklin Mesa was the best trainer I have ever had and i walked out certified on the last day of my CompTIA Security+ certification bootcamp. 

Marc Alfonso - CompTIA Security + Student

 

The Academy is one of the best educational values for today's job market.  I studied hard and got certified (A+ and N+).  Even though I had no prior IT experience, I now have a good job replacing obsolete computers in hospitals throughout the country.  At my job interview, I just slid my test scores and certification across the table to the interviewer, who is now my boss.  I was hired the next day.  

Not bad for a 65 year old.

John Arnett- Student 

"I congratulate The Academy for a great facility and good lab computers. The Academy is great and I will definitely be taking more courses and utilizing the services available. Omer Palo is an excellent instructor that truly knows his material. I never felt bored in his class which is a first for me. Thank You."

IT Director, Burger King Corporation

"The instructor Frank Martinez is excellent – he covered so much material in 2 weeks that was unbelievable! He definitely knows what he does and it shows in the way that he conducts each lecture. He is the greatest!"
"Thanks Academy for allowing me to experience the MCSA / MCSE + Security Boot camp."

IT Professional, Florida International University

 

Schedules

Contact Us


THE ACADEMY

1.800.482.3172

FTL: 954.351.7040

MIA: 305.648.2000


Request More Information

 

Current Promotions!

 

  _____________________________________

 

 

 

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Sign up for our Email Newsletter!

          

 

Students - Orbund Log-In