Customer Reviews

Sqr in PeopleSoft and Other Applications

5 star:		(25)
4 star:		(3)
3 star:		(1)
2 star:		(0)
1 star:		(0)

 

 

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.

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.

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.

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.

I had the honor (and pleasure) of reviewing the book... It is very solid and will definitely benefit the SQR community as a whole... It seems to cover "all areas" of SQR development including Internet, Graphics and Printing Topics... as well as arrays, functions, I/O, decision logic, SQL, commands, syntax, etc... Although the book has 'PeopleSoft' in the title its' Main Focus is SQR programming in general... Think of the PeopleSoft chapters as an added bonus! (That's one of the things I really liked about the book - it doesn't stop at the basics)... The PeopleSoft chapters explain the ins/outs of Menus, Run Controls (Records/Panels), Process Scheduler, Process Monitor, Effective Date Processing, Interfaces, Conversion... You can find information on the book (including table of contents) at Manning's website (www.manning.com)... I could tell in my review a great deal of time and careful planning went into writing this... I'm especially pleased because I've recently had the opportunity to work with Galina at a "mutual" client and it's been a very positive and rewarding experience... She's very knowledgable, professional and very enthusiastic about her work! As a reviewer it was difficult finding fault with the content! I noticed the first review of this book on amazon.com was unintelligible! I'm curious how this individual derived his 'star-rating'??? New and experienced SQR developers will be very happy with this book!

In 1995, I started into the world of PeopleSoft. I wished I had this book after I took my first SQR class. This book gives practical advice, has many examples which solve typical business problems, and is a great reference book. If I had this book when I started, my SQRs would have been better. I learned a lot by coding and re-doing code. This book would have saved me a lot of time. At my current job, we reference it frequently. I think we all have our own copies and highly recommend it to anyone writing SQRs.

I think I will never finish reading the book as I keep getting more information from it. I think sometimes I am not ready to hear what is said until a later date. I really think this book is filling a void and will be greatly appreciated.

The Landres book provide a very solid introduction and expansion of SQR concepts. This book provides an excellent introduction to novice and new SQR programmers, and it is an excellent reference guide for experienced programmers. The examples of various reports are based on the PeopleSoft HRMS, but can be applied for any other application or RDBMS.

The authors cover version 3.x and 4.x of Scribe's SQR. This is the first comprehensive book on SQR that I have seen and reviewed which presents the material in a logical manner which leaves the reader yearning to read on ahead.

A must have for any SQR developer / programmer.

It is very rare to find a technical book that actually provides superior technical information to a practicing information system professional. This book is organized well, provides good examples, and has detailed descriptions of the various built-in functions.

I consistently refer to this information when I create SQR programs for PeopleSoft systems. Having been away from SQR for a year, I was able to get back up to speed in a half a day by reviewing the book.

If 6 stars were available, I would rate this book at this leve. If you have to use SQR, particularly with PeopleSoft, you can not go wrong.

I have spent $10's of thousands of dollars of my own money as well as my company's money on technical manuals and training and this is by far the best technical manual I have ever put my hands on. I am a NT Admin who is moving into a PeopleSoft role and this book is a Godsend. It took me from clueless to the point where I can intelligently discuss SQR/SQL as well as write small programs that talk to both Oracle/SQLBASE in a relatively short period of time (3weeks).Pick this book up and I guarantee you will appreciate it. I am cutting my teeth on Peoplsoft (HRMS) single user so if anyone out there has some nice learning code they want to share I would appreciate it.

This book is the model for future authors of ERP. ERP is not an easy subject matter to write about since it involves aspects from varied academic and business-practical standpoints.

In particular, the Landres were able to break down elements from SQR and how it integrates with the PeopleSoft application. They do so in a manner which is easy to read (from a programming standpoint) without getting buried in irrelevant academic explanations.

The target audience are technical people who 1) are faced with understanding SQR (with or without PS) at a technical managerial level 2) need to write sqr's from scratch 3) need to modify delivered sqrs 4) really are functional but need to understand how SQR impacts functionality.

The readers who do not fit this profile should not purchase this book since the authors do not really delve into SQR as a strategic tool vs. other reporting tools (Actuate, IBI, Query/Crystal, nVision, Cognos, Essbase, etc).

However, I consider this book to be a breakthrough and should be considered a vital reference book for anyone who can spell PeopleSoft.