LEARN PEOPLESOFT QUERY
Watch the below video
Learn PeopleSoft Query and super-charge your productivity!
Register Now and Receive $100 OFF. Offer Ends July 14 2019
PeopleSoft Query made Ridiculously Easy 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 multiple runtime prompts,
4
Module 4: Scheduling Queries & Summary Calculation
Learn how to add criteria statements, use effective date field, creating multiple 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!
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 means 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
Discount Ends in...