​LEARN PEOPLESOFT QUERY

Watch the below video

play

Learn ​PeopleSoft Query and super-charge ​your productivity​!

Register Now and Receive $100 OFF. Offer Ends July 14 2019

12
Days
17
Hours
54
Minutes
57
Seconds

​PeopleSoft Query ​made Ridiculously E​asy​ for you!

As a PeopleSoft consultant, you face undesirable situations many a times.

PeopleSoft Functional Consultant

If you're a PeopleSoft Functional consultant, you may find the task of writing SQLs a bit daunting. Writing simple SQL queries is easy but writing a complex, nested SQL, which is efficient at the same time - it is no easy task.

By using PeopleSoft Query, you can even create complex SQLs with much ease and without deep knowledge of SQLs! 

Our course on PeopleSoft Query will also help you understand how to make those queries efficient!​

PeopleSoft technical Consultant

As a PeopleSoft technical consultant, you may face situations wherein access to the database using a SQL tool won't be provided. Instead you'd be expected to make use of PeopleSoft Query.​

Also, understanding PeopleSoft Query is an absolute must for a PeopleSoft technical consultant because you'll find these queries in several places like when using PeopleSoft Search, BI Publisher, nVision programs etc.

Our course on PeopleSoft Query will ​help you build a solid foundation for creating useful and efficient queries!​

By ​Learning PeopleSoft Query, you'll be able to ​realize higher productivity and have fun at work!

By learning PeopleSoft Query, you'd be able to perform many of your daily tasks much more efficiently. You might not realize it, but as PeopleSoft consultant, you use PeopleSoft Query almost on a daily basis irrespective of whether you work directly on it or it gets called behind the scene.


The goal of our course on PeopleSoft Query is to make you super-efficient in PeopleSoft Query, so that any task you do - you do it highly efficiently and do not end up under-utilizing all the powerful features the technology has to offer. ​

Special offer! 

Enroll now and get a 40% discount !


​Some of the Benefits of Signing up for the Course

This course will start becoming available ​from July 01, 2019. Every day a new module will be released and by mid-July, all the modules will be released! By enrolling in the course now, you'll be unlocking all the great features of the course at rock bottom prices!

​Lifetime 24x7 Access

​You'll receive lifetime access, so learn at your own pace. You can access the course from any device connected to the internet.

​Friendly & Responsive Support

Our support team is here to help you via messaging group, support tickets, emails - whichever you prefer. ​We ​got you covered!

Quizzes

Quizzes will test your learning so you are sure that you're ready to take up any PS Query task.


Exercise & Activities

Activities & Exercise will help you learn understand the concept better and apply the knowledge. 


​Latest Version & Features

​This course is based on latest PeopleTools version and incorporates all the new features offered.

​Certificate of Completion

Complete the course, earn the ​certificate of completion and earn bragging rights!

What you will learn

​This course has been created by PeopleSoft consultants, who use PeopleSoft Query on a daily basis. They understand the pain of other PeopleSoft consultants and have designed the course in such a way that all the topic get covered but at the same time, the learning process would be fun and ​something to look forward to!

1

Module 1: ​Introduction to PeopleSoft Query

​Understand what is PeopleSoft Query and its uses. Understand different types of Queries, advantages ​and how to organize & manage PeopleSoft Query.

2

Module 2: ​Using PeopleSoft Query

​Learn how to create a new PeopleSoft ​Query by adding records, fields, field properties and removing duplicate data. 

3

Module 3: ​Criteria & Prompts

​Learn how to add criteria statements, use effective date field, creating mu​ltiple runtime prompts, 

4

Module 4: Scheduling Queries & Summary Calculation

​Learn how to add criteria statements, use effective date field, creating mu​ltiple runtime prompts, 

5

Module 5: Expressions

Learn how to use expressions and using literals, functions, prompts, links, aggregates with expressions, 

6

Module 6: Drilling URL

Using Drilling URL in PS query. Use drilling URL for Query, Component, External and Free Form URL.

7

Module 7: Join, Unions & SubQueries

Standard join, Auto-join, subquery, single-value subquery, creationg Union, Left Outer Join.

8

Module 8: Composite Query

Learn what is composite query, how to edit, copy and delete composite query. Using filters, run time prompt and Drilling URL with Composite query.

9

Module 9: Connected Query

Learn how to use connected query, connected query manager, view and schedule connected query.

10

Module 10: Query Administration & Security

Query Administration, query Logs, query stats, killing a query, change query ownership, understanding query security, access profiles, query tree , query row level security.

11

Module 11: Query Tables

Important Query tables, FSCM tables for query, HR tables for query.

12

Module 12: Query Performance & Advance Settings

Learn about query best practices, parallel hints, database level settings, query timeout, query timeout settings on application server, handling long running queries.

13

Module 13: Query in 2-tier & 3-tier

Understand how to use query in 2-tier and 3-tier.

14

Module 14: Additional Reference

Query Cheatsheet, New Features in PT 8.55,8.56 & 8.57 and lot of other reference material.

​Why ​​do you need this course?

​Every PeopleSoft consultant uses PeopleSoft Query. But unfortunately not everyone uses it efficiently and optimally. Some people end up ​creating poor and inefficient queries, which run slow (making the DBAs upset), whereas some don't know even know all the powerful features offered by Peoplesoft Query and hence, under-utilize the power of the technology.

.

This course has been created to make every PeopleSoft consultant proficient in PeopleSoft Query. ​The course is priced such that every one can enroll, learn and have fun!


GET $100 OFF TODAY! Don't Miss this Opportunity!

12
Days
17
Hours
56
Minutes
17
Seconds

100% Satisfaction Guarantee for ​14-Days

​We're so confident that this will be one of the BEST TRAINING you've ever attended that we're backing it with a 14 day 100% Money Back Guarantee.

Don’t wait! Look at what past students have to say about ​us.

Our sole aim with this course is to make you efficient in PeopleSoft Query. Your success is our success. Nothing would give is more happiness than you completing this course and making the most of the skills gained.


We're here to build a long lasting relationship with you. We're always ready to walk the extra mile for our customers and it gives us immense pleasure and joy.


Over the past few years, we've strong relationships with our customers. ​

​Alicia G​.

​PeopleSoft Upgrade & Implementation Deployment Manager

​I love what you guys do.

​As a deployment manager, I am always working with ​different teams ​of varying skills. ​

I highly recommend ​courses ​sold by PeopleSoft Tutorial as I have bought each and every one of them!

I found all the courses to be ​well laid out. They ​cover all the needful topics without being overwhelming at the same time.

Linda ​O​.

​PeopleSoft ​FSCM Systems Accountant

​Highly cost effective

​My ​employer does not sponsor for any trainings, so I need to pay from my pocket. 

​The courses sold by ​peoplsofttutorial.com cost just a fraction of what Oracle and other training institutes charge but cover all the aspects needed, so they are a ​​great value buy for people like me.

​Trina ​K.

​PeopleSoft Reporting Specialist

​Excellent Support

​I was a legacy system developer before ​our organization replaced it with PeopleSoft in 2016.

Though we were provided some training but it was not enough for day to day job functions. ​

I did a few training courses from SkillsVine and to my amazement, the support staff helped me through all the issues I faced.

I never felt like the course was sold and no one cared. It mean​s a lot to me! ​

Frequently Asked Questions

​When does the course start and finish?

​How long do I have access to the course?

​What if I am unhappy with the course?

​Do you provide on-the-job support?

​Do you help with job placement? 

​I've another question, not listed above?

​PeopleSoft Query training course

​Learn PeopleSoft Query & Quickly Resolve Issues

$

249 149

  • Lifetime Access
  • ​Course​ Available July 01, 2019
  • Access to All Modules by July ​15
  • ​14-Day ​Money Back Guarantee

Discount Ends in...

12
Days
17
Hours
59
Minutes
13
Seconds

Copyright PeopleSoftTutorial.com

>