skip to content
Mastering SQL Queries for SAP Business One. Preview this item
ClosePreview this item
Checking...

Mastering SQL Queries for SAP Business One.

Author: Gordon Du
Publisher: Birmingham : Packt Pub., 2011.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook.
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Du, Gordon.
Mastering SQL Queries for SAP Business One.
Birmingham : Packt Publishing, ©2011
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Gordon Du
ISBN: 9781849682374 1849682372
OCLC Number: 797916717
Notes: LIKE-similar records can be found.
Description: 1 online resource (520 pages)
Contents: Mastering SQL Queries for SAP Business One; Mastering SQL Queries for SAP Business One; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; Business Intelligence (BI); What this book covers; Section 1: SQL Query Basic; Section 2: SQL Query in Action; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions. 1. SQL Query Basic1. SAP Business One Query Users and Query Basics; Who can benefit from using SQL Queries in SAP Business One?; Consultant; Developer; SAP Business One end user; Non-SAP Business One users; SQL query and related terms; RDBMS; Table; Field; SQL; T-SQL; Subsets of SQL; Query; Data dictionary; SAP Business One-Database tables reference; Naming convention of tables for SAP Business One; Three letter words; ""O"" tables; ""A"" tables; Document header tables; Document line tables; Important table examples; Table links-the key for the right query; Primary key; Foreign key. Example of table links within SAP Business OneBase tables versus target tables; Keeping it simple-The key to build a good query; Summary; 2. Query Generator and Query Wizard; Query Generator; Query Generator overview; Left part of Query Generator form; Middle and right parts of Query Generator form; Executing a query from query generator form; Query wizard; Query Wizard overview; Step 1-Splash screen; Step 2-Select tables for the report; Step 3-Select fields and sort orders; Step 4-Conditions and relations; Step 5-Query wizard completion. What is the difference between Query generator and Query wizard?Benefitting from built-in system queries; Summary; 3. Query Manager and Query Statements; Query manager user interface; Display all existing queries; Creating and saving user queries; Deleting user queries; Managing query categories; Commonly used statements; SELECT-first statement to retrieve data; The scope of the value that can be retrieved; A single value; A group of values; Return a single database table column; Return a group of database table columns; Return complete database table columns; Used in a subquery. The numbers of columns to be includedColumn name descriptions; Clauses can follow this statement; DISTINCT-duplicated records can be removed; TOP-number of lines returned by ranking; FROM-data resource can be assigned; A single table; A group of linked tables; Multiple tables separated by commas; JOIN-addition table or tables can be linked; Inner Join; Outer Join; Left Outer Join; Right Outer Join; Full Outer Join; Self-Join; WHERE-query conditions to be defined; BETWEEN-ranges to be defined from lower to higher end; IN/EXISTS-the value list that may satisfy the condition.

Abstract:

Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/797916717> # Mastering SQL Queries for SAP Business One.
    a schema:MediaObject, schema:CreativeWork, schema:Book ;
   library:oclcnum "797916717" ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/949196986#Place/birmingham> ; # Birmingham
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/enk> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/949196986#Topic/sql_computer_program_language> ; # SQL (Computer program language)
   schema:about <http://dewey.info/class/005.7585/> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/949196986#Topic/small_business_management_computer_programs> ; # Small business--Management--Computer programs
   schema:about <http://experiment.worldcat.org/entity/work/data/949196986#Topic/sap_business_one> ; # SAP Business one
   schema:about <http://experiment.worldcat.org/entity/work/data/949196986#Topic/database_searching> ; # Database searching
   schema:about <http://experiment.worldcat.org/entity/work/data/949196986#Topic/client_server_computing> ; # Client/server computing
   schema:bookFormat schema:EBook ;
   schema:creator <http://experiment.worldcat.org/entity/work/data/949196986#Person/du_gordon> ; # Gordon Du
   schema:datePublished "2011" ;
   schema:description "Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook."@en ;
   schema:description "Mastering SQL Queries for SAP Business One; Mastering SQL Queries for SAP Business One; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; Business Intelligence (BI); What this book covers; Section 1: SQL Query Basic; Section 2: SQL Query in Action; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions."@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/949196986> ;
   schema:genre "Electronic books"@en ;
   schema:inLanguage "en" ;
   schema:isSimilarTo <http://worldcat.org/entity/work/data/949196986#CreativeWork/mastering_sql_queries_for_sap_business_one> ;
   schema:name "Mastering SQL Queries for SAP Business One."@en ;
   schema:productID "797916717" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/797916717#PublicationEvent/birmingham_packt_pub_2011> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/949196986#Agent/packt_pub> ; # Packt Pub.
   schema:url <http://ebookcentral.proquest.com/lib/columbia/detail.action?docID=950602> ;
   schema:url <http://cdn.totalboox.com/static/covers/PT/db29a47a0d5a53f-b.jpg> ;
   schema:url <http://libguides.aucegypt.edu/content.php?pid=376187&sid=3081544> ;
   schema:url <http://www.totalboox.com/book/id-987020900779271487> ;
   schema:url <http://ebookcentral.proquest.com/lib/ucm/detail.action?docID=950602> ;
   schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=950602> ;
   schema:workExample <http://worldcat.org/isbn/9781849682374> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/797916717> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/949196986#Topic/client_server_computing> # Client/server computing
    a schema:Intangible ;
   schema:name "Client/server computing"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/949196986#Topic/small_business_management_computer_programs> # Small business--Management--Computer programs
    a schema:Intangible ;
   schema:name "Small business--Management--Computer programs"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/949196986#Topic/sql_computer_program_language> # SQL (Computer program language)
    a schema:Intangible ;
   schema:name "SQL (Computer program language)"@en ;
    .

<http://worldcat.org/entity/work/data/949196986#CreativeWork/mastering_sql_queries_for_sap_business_one>
    a schema:CreativeWork ;
   rdfs:label "Mastering SQL Queries for SAP Business One." ;
   schema:description "Print version:" ;
   schema:isSimilarTo <http://www.worldcat.org/oclc/797916717> ; # Mastering SQL Queries for SAP Business One.
    .

<http://worldcat.org/isbn/9781849682374>
    a schema:ProductModel ;
   schema:isbn "1849682372" ;
   schema:isbn "9781849682374" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.