Updates
Latest Tweet
What's New?
Check out for latest innovation, a computer based training video collection
Like this Page
SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8 Review by Mike Tarrani
*The* standard reference on SQR
Aside from the fact that there is no other book that teaches SQR, this book is unique and valuable for following reasons:
- It teaches good programming practices. Anyone who has developed in any procedural language (including scripting and query languages) can quickly learn SQR. Therein lies a problem that this book overcomes: the excellent advice given about program development and structure can offset bad habits picked up in other languages.
- It's a definitive resource for SQR developers. Although SQR is relatively easy to learn, it's also rich with features missing from most other languages, such as complete control over printed and screen output, built-in constructs for graphs and charts, and multiple output file formats. Using many of these features not easy for beginners or programmers more used to other languages, but this book shows by example how to exploit every feature SQR has to offer.
- It dispels the common notion that SQR is a PeopleSoft-only tool. In fact, PeopleSoft doesn't own the language, and SQR will work in any database environment. More important, the book shows how to develop application and database independent programs that will work in any environment. This is an awakening for those who are going down proprietary paths, such as standardizing on Oracle's PL/SQL. While PL/SQL itself a powerful language, but is limited to Oracle - migrating from Oracle to, say, DB2 requires that all PL/SQL programs be scrapped. Had the applications and reports been developed in SQR the only changes would be to tables referenced.
In addition to the above, this book also provides good practices for forming SQL queries and understanding how a poorly formed join can make the difference between a resource hog and an unintrusive application. Since SQL, like SQR, is easy to learn many developers take the path of least resistance and develop queries with no thought on their effect on production systems. This book gives sound advice for avoiding that mistake.
The section on PeopleSoft, while out of date with respect to version 8, still contains valuable information for the majority of SQR developers whose exposure to SQR is via PeopleSoft.
There is something for everyone in this book - beginners can learn SQR the right way, and seasoned developers will have a ready reference that covers almost every facet of SQR in practical terms. If your job is primarily SQR development I also recommend that you also get a copy of "SQR Programmer Reference" by Don Mellen (ISBN 0967773008) as a quick reference to the features and nuances of SQR.