SQR in PeopleSoft and Other Applications covers all SQR language elements and features and shows the best ways of utilizing SQR's capabilities. The book is presented in tutorial style; it starts from... This description may be from another edition of this product.
I was working on a problem a couple of years ago and took the suggestion of a co-worker to buy this book. For the last two years I have been using it as a reference. I spent a few months off and came back and embaressed myself puting a report in process scheduler. So I sat down and read the book front to back. I wish I had done this a couple of years ago.I have been working with SQR for five years. I have used examples and the SQR manuals to accomplish what I wanted. This work provided me with a lot of knowledge that I had never taken the time to pick up. Now even if I take the time off and need a refresher the sections are highlighted. I have found this book very useful as both a reference and a knoweldge builder. Also, the writing style was good enough that rereading the portions that I was alread aware of was not too irksome. Interestingly, I could swear some of the interview questions I have been asked came right out of this book.
An Excellent Desk Reference
Published by Thriftbooks.com User , 25 years ago
I work as PeopleSoft technical consultant and use this book at least once a week when writing and/or modifying SQR programs. It's a great desktop reference book - solid examples and easy-to-understand text. I use it to supplement the technical manuals that come with the SQR product.
A 'Must-Have' for PS Developers
Published by Thriftbooks.com User , 25 years ago
I have few than six months of Peoplesoft and SQR experience but was able to code a module that completely replaces the delivered Overtime Calculation for Time and Labor from PS. This book has been a tremendous help and resource. One of the best investments I have ever made.Examples are well illustrated. Explanation is very clear and relevant. A great book for developer with couple years of SQL experience.
GREAT BOOK
Published by Thriftbooks.com User , 25 years ago
The scope of coverage is complete. It is understandable to someone with little experience while briskly moving from one topic to the next, with good examples. The material is organized well - simple to complex SQR, then putting SQR's online into Peoplesoft, then the nitty gritty of working with history and interfaces with Peoplesoft. Glossaries are at the end. It's not too long, not too short. The author is stimulating, not belabored with theory, yet topics are thorough and more than one example is used. Look for a great style - doing something slightly wrong, and then the author pointing it out and repeating the answer with the correct solution. Printing summaries at the end of each chapter is good. Illustrating points with call-out boxes overimposed onto actual programming code is also a great technique. The more advanced techniques the reader is able to master, the more valuable this book becomes. Specifically, arrays in chapter 11, loops in chapter 10, substitution topics in chapter 9, using breaks in reporting in chapter 8, are all intricate tools useful to the serious SQL programmer. Check out the entire table of contents at http://www.manning.com/Landres/Contents.html This book is for SQR programmers, project leaders, DBA's, installation consultants, consulting programmers. There are many books on SQL and SQR, including complete Oracle References. And there is book that is handed out at the Peoplesoft class on SQR. Landres' book is different in that it gives SQR from A to Z, it gives the Peoplesoft related topics, it gives actual upgrade and history topics (which I've seen nowhere). And unlike the Oracle books which are geared for DBA's, the approach is directed towards the specific goal of writing Peoplesoft SQR's. SQR for Peoplesoft is great and I highly recommend it.
ThriftBooks sells millions of used books at the lowest everyday prices. We personally assess every book's quality and offer rare, out-of-print treasures. We deliver the joy of reading in recyclable packaging with free standard shipping on US orders over $15. ThriftBooks.com. Read more. Spend less.