PeopleSoft Books
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page PeopleSoft Books
(→Using Functions in PeopleSoft Query) |
|||
| Line 1: | Line 1: | ||
| - | + | == Using Functions in PeopleSoft Query == | |
| - | + | {| class="wikitable" | |
| + | |- | ||
| + | |[[File:UsingFunctionsInPeopleSoftQuerySmall.jpg|190px|link=http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21]] | ||
| + | |Amazon Kindle: [http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21 Using Functions in PeopleSoft Query] | ||
| - | + | At the heart of a PeopleSoft Query is a SQL query. Knowing some extra tricks with SQL functions will go a long way to extracting the exact results you need. | |
| + | But isn't SQL hard? So completely difficult that only Einstein after 3 Red Bulls could possibly stand a chance of putting a query together? This book aims to dispel this myth and help you increase the number of tasks you can complete with PeopleSoft Query. | ||
| - | + | Harness the power of PeopleSoft Query using the database (both Oracle and SQL Server), use this book to take the raw Query results and fashion them. | |
| + | |} | ||
| - | PeopleSoft | + | == PeopleSoft Users Companion == |
| - | + | {| class="wikitable" | |
| + | |- | ||
| + | |[[File:PeopleSoftUserCompanion.jpg|190px|link=http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24]] | ||
| + | |Amazon Kindle: [http://www.amazon.co.uk/gp/product/B00S74S9MM/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B00S74S9MM&linkCode=as2&tag=springboardso-21&linkId=X4GHKEBKKMKPCO24 PeopleSoft Users Companion] | ||
| - | + | This book is packed full of hints and tips for users of the Oracle PeopleSoft applications. The hints and tips can be applied to HR, Campus, Financials and CRM. | |
| - | PeopleSoft | + | The Oracle PeopleSoft applications are very versatile and powerful. A little knowledge of tricks and techniques can help you make more of the system, and get things completed faster. |
| - | A text of best practices and some expert tricks and techniques such as | + | These tricks will save you time - some every day, some occasionally. Some ideas you may have been vaguely aware of, but not seen how they can be used. |
| + | |||
| + | |} | ||
| + | |||
| + | |||
| + | == Peoplesoft for the Oracle DBA == | ||
| + | |||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | |[[File:Book1.png]] | ||
| + | |||
| + | |Amazon: [http://www.amazon.co.uk/gp/product/1590594223?ie=UTF8&tag=springboardso-21&linkCode=as2&camp=1634&creative=19450&creativeASIN=1590594223 Peoplesoft for the Oracle DBA] | ||
| + | |||
| + | This is an excellent text for PS Admins and developers that want to know more about what goes on under the covers. | ||
| + | |||
| + | * Background of how PeopleSoft makes use of particular Oracle database features. | ||
| + | * Understanding the PeopleSoft Application Server - covers how the Oracle Tuxedo transaction monitor is used by PS App Servers. | ||
| + | * Performance Monitoring - techiques for understanding the many traces and logs and understanding what they mean. | ||
| + | * Performance Tuning - Some tricks and techniques for improving the performance of various components of PeopleSoft. | ||
| + | |||
| + | |||
| + | |} | ||
| + | |||
| + | |||
| + | == PeopleSoft Developers Guide for PeopleTools and PeopleCode == | ||
| + | |||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | |[[File:Book2.png]] | ||
| + | |||
| + | |Amazon: [http://www.amazon.co.uk/gp/product/0071496629?ie=UTF8&tag=springboardso-21&linkCode=as2&camp=1634&creative=19450&creativeASIN=0071496629 PeopleSoft Developer's Guide for PeopleTools & PeopleCode] | ||
| + | |||
| + | A good all round how-to guide - covers: | ||
| + | |||
| + | * Building a page in Application Designer. | ||
| + | * Writing PeopleCode | ||
| + | * Building processes in Application Engine and SQR | ||
| + | * Reporting in XML Publisher. | ||
| + | |||
| + | |} | ||
| + | |||
| + | == PeopleSoft PeopleTools: Tips and Techniques == | ||
| + | |||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | |[[File:Book3.png]] | ||
| + | |||
| + | |Amazon: [http://www.amazon.co.uk/gp/product/0071664939?ie=UTF8&tag=springboardso-21&linkCode=as2&camp=1634&creative=19450&creativeASIN=0071664939 PeopleSoft PeopleTools Tips & Techniques] | ||
| + | |||
| + | A text of best practices and some expert tricks and techniques such as: | ||
| + | |||
| + | * Using object orientated Application Packages. | ||
| + | * Add AJAX to your pages to reduce network round trips | ||
| + | * Using Java from within PeopleCode | ||
| + | * Extending Integration Broker with home grown connectors | ||
| + | |||
| + | A great source book! | ||
| + | |||
| + | |} | ||
