Cargando…
Mastering SQL Queries for SAP Business One.
Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2011.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Mu 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_ocn797916717 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 121121s2011 enk o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d OCLCQ |d DEBSZ |d OCLCQ |d MEAUC |d OCLCQ |d FEM |d ZCU |d MERUC |d ICG |d OCLCO |d OCLCF |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d WYU |d DKC |d AU@ |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 019 | |a 847742834 |a 968032713 |a 969016834 |a 1064154664 | ||
| 020 | |a 9781849682374 | ||
| 020 | |a 1849682372 | ||
| 024 | 3 | |a 9781849682374 | |
| 029 | 1 | |a DEBBG |b BV044166812 | |
| 029 | 1 | |a DEBSZ |b 397334729 | |
| 029 | 1 | |a DKDLA |b 820120-katalog:999930655605765 | |
| 035 | |a (OCoLC)797916717 |z (OCoLC)847742834 |z (OCoLC)968032713 |z (OCoLC)969016834 |z (OCoLC)1064154664 | ||
| 037 | |b 01201872 | ||
| 050 | 4 | |a HD62.7 | |
| 082 | 0 | 4 | |a 005.75/85 |a 650.0285 |a 658.02/2 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Du, Gordon. | |
| 245 | 1 | 0 | |a Mastering SQL Queries for SAP Business One. |
| 260 | |a Birmingham : |b Packt Pub., |c 2011. | ||
| 300 | |a 1 online resource (520 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file |2 rda | ||
| 505 | 0 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 505 | 8 | |a 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. | |
| 500 | |a LIKE-similar records can be found. | ||
| 520 | |a Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook. | ||
| 588 | 0 | |a Print version record. | |
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 630 | 0 | 0 | |a SAP Business one. |
| 630 | 0 | 7 | |a SAP Business one |2 fast |
| 650 | 0 | |a Small business |x Management |x Computer programs. | |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 6 | |a Petites et moyennes entreprises |x Gestion |x Logiciels. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 7 | |a Small business |x Management |x Computer programs |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 758 | |i has work: |a Mastering SQL queries for SAP Business One (Text) |1 https://id.oclc.org/worldcat/entity/E39PD3VDCtkjhb3hKXWYXm44fV |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Du, Gordon. |t Mastering SQL Queries for SAP Business One. |d Birmingham : Packt Publishing, ©2011 |z 9781849682367 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=950602 |z Texto completo |
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL950602 | ||
| 994 | |a 92 |b IZTAP | ||