Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Buy New
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Mastering SQL Queries for... has been added to your Cart
Trade in your item
Get a $19.12
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Mastering SQL Queries for SAP Business One Paperback – May 24, 2011

4.4 out of 5 stars 7 customer reviews

See all 2 formats and editions Hide other formats and editions
New from Used from
"Please retry"
"Please retry"
$45.04 $48.81

Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
$54.99 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • Mastering SQL Queries for SAP Business One
  • +
  • SAP Business ONE Implementation
  • +
  • SAP Business One: Simple But Powerful
Total price: $147.38
Buy the selected items together

Editorial Reviews

About the Author

Gordon Du studied System Engineering & Computer Science at the Nankai University in Tianjin, China. He has more than 25 years of experience with diversified information technology fields. His experience with SQL goes back to 1987.He has passion for helping others whenever he can. He is the top contributors on the SAP Business One forum ever since August 2008. Over 25% of all his points are related to solving SQL questions and problems posted by other forum members.Gordon has worked and trained in China, Singapore, USA and Canada. In China, he is the first person to successfully implement an international software package in a domestic company. He is also a Microsoft Certified System Administrator, Microsoft Certified System Engineer and Microsoft Certified Database Administrator.
If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $2.99 (Save 85%). Print edition purchase must be sold by Amazon. Learn more.
For thousands of qualifying books, your past, present, and future print-edition purchases now lets you buy the Kindle edition for $2.99 or less. (Textbooks available for $9.99 or less.)
  • Thousands of books are eligible, including current and former best sellers.
  • Look for the Kindle MatchBook icon on print and Kindle book detail pages of qualifying books. You can also see more Kindle MatchBook titles here or look up all of your Kindle MatchBook titles here.
  • Read the Kindle edition on any Kindle device or with a free Kindle Reading App.
  • Print edition must be purchased new and sold by Amazon.com.
  • Gifting of the Kindle edition at the Kindle MatchBook price is not available.
Learn more about Kindle MatchBook.

New York Times best sellers
Browse the New York Times best sellers in popular categories like Fiction, Nonfiction, Picture Books and more. See more

Product Details

  • Paperback: 352 pages
  • Publisher: Packt Publishing (May 24, 2011)
  • Language: English
  • ISBN-10: 1849682364
  • ISBN-13: 978-1849682367
  • Product Dimensions: 7.5 x 0.8 x 9.2 inches
  • Shipping Weight: 1.7 pounds (View shipping rates and policies)
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (7 customer reviews)
  • Amazon Best Sellers Rank: #762,153 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By W Boudville HALL OF FAMEVINE VOICE on July 23, 2011
Format: Paperback
I've some familiarity with SQL and with queries written in it, but no experience using SAP's Business One package, unlike perhaps some of the other reviewers who seem well acquainted with it. It appears that the value of this book is in its extremely detailed examples of how to implement the trendily termed "Business Intelligence" as actual and useful queries.

The specialisation to SAP Business One means that you have this already installed on your computers. While the book does offer an introductory chapter on the general basics of SQL, it's pretty rudimentary. You really should be already up to speed on SQL. The second chapter moves onto SAP, with an all too brief description of their Query Generator and Query Wizard.

But it is the third chapter, on the Query Manager, that you should start to focus. It lets you make complex queries and just as importantly to group them into categories. You can use its user interface to build a first attempt at a query. Then, from looking at the text of how the Manager has instantiated the query, you can if necessary manually edit it to customise it further for exactly your situation.

The ability to group queries is the other key valued added aspect of Manager. Introductory books on SQL rarely talk about this. But in practical situations, and not restricted to the SAP packages, once you starting building a set of interrelated tables and writing queries against them, you start accumulating many queries. In itself, this can be a source of complexity and error.

The rest of the book then goes into several extended examples that let you learn about how to use these tools.
Comment 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Packt Publishing has come out with some good books for IT folks and they are starting to gain a reputation for providing both technical and functional books. "Mastering SQL for SAP Business One" is another example of what this publishing house is striving for: IT books which provide both theory and actual application of a topic with a hands-on, sensible approach. Packt has the catch phrase of "professional expertise distilled" for their publications, which might be more on target of what this book is all about. Many of Packt's books are excellent self-teaching tools, and this book definitely falls into that category and goes a bit beyond.

I might have some skin in the game on this one, but if you deal with SAP Business One (SAP B1) at all, you quickly realize one of the most useful tools to have around is the ability to write SQL to provide additional information which users require throughout the life of SAP B1's usage. The author might refer to it as "Business Intelligence" and "Data Mining", but I tend to be old school and think of SQL's purpose as: the user needs information which is in the databases, and IT needs some special SQL written to get it into the hands of the users.

Besides the obvious benefits of the skills you will receive from the book, an additional benefit of this publication deals with the author: Gordon Du is widely and openly recognized in the SAP B1 Forums as being a complete, well-rounded expert on SAP B1, and one of the best SQL writers to be found in helping others straighten out or improve the SQL that is posted on the SAP B1 sites. If you are at all slightly familiar with the SAP sites, you know this fellow has some pretty incredible credentials.
Read more ›
Comment 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Wow, what can I say - Gordon Du has done a superb job of stitching together everything a SAP Business One implementer needs to know about SAP B1 query support inside the product. It is this query support which makes SAP B1 stand out against its competitors and it is this Query knowledge that makes the end users happy and makes it worthwhile switching to B1; it is this Query support that makes end users of B1 productive every day at work and hence provides a tangible return on investment by consolidating multiple data gathering activities into a single easy to use report from queries. Queries will simplify our clients work flow and data accessibility where it is needed without expensive programming. The great design of Business One allows for use of queries as if it is part of customization of product and will enhance the product and every implementer needs to know about this customization with Queries.

I am a SAP Certified SAP B1 consultant and have done multiple implementations and going forward, I will use many queries right out of this book and modify a few others slightly to fit into my client needs such as client UDFs, UDTs etc.

Mr. Du has done a wonderful job of covering everything one needs to know about Query generation, reports and screen formatting, great real product pictures to show how it is actually customized, securing the queries, great insight into why something is done and not to forget Stored Procedures which may be 10% of implemented query customization.

Mr. Du is very well known to SAP Community and he has been helping them for many years actively and now this great book is a giveaway and will save months if not years of effort and hard learning!
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

Mastering SQL Queries for SAP Business One
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: Mastering SQL Queries for SAP Business One

What Other Items Do Customers Buy After Viewing This Item?