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 /
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 (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | OR_ocn742282647 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 110724s2011 enka of 001 0 eng d | ||
| 040 | |a N$T |b eng |e pn |c N$T |d E7B |d OCLCQ |d UMI |d COO |d OCLCQ |d DEBSZ |d OCLCQ |d DKDLA |d OCLCQ |d YDXCP |d OCLCQ |d OCLCF |d OCLCQ |d AGLDB |d OCLCQ |d OCLCO |d JBG |d CNNOR |d OCLCQ |d OCLCO |d MOR |d PIFAG |d OCLCQ |d U3W |d STF |d WRM |d BRL |d OCLCQ |d CEF |d NRAMU |d NLE |d INT |d VT2 |d AU@ |d UKMGB |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d A6Q |d UKAHL |d HS0 |d BOL |d UKCRE |d VLY |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO | ||
| 016 | 7 | |a 018015094 |2 Uk | |
| 019 | |a 794554424 |a 961691066 |a 962725284 |a 988499353 |a 992062749 |a 1037784632 |a 1038665705 |a 1039187470 |a 1045582167 |a 1055347169 |a 1058228876 |a 1081240207 |a 1083554514 |a 1103262032 |a 1114371565 |a 1129356308 |a 1153015657 |a 1162530245 |a 1192337930 |a 1228528816 |a 1240508861 | ||
| 020 | |a 9781849682374 |q (electronic bk.) | ||
| 020 | |a 1849682372 |q (electronic bk.) | ||
| 020 | |a 1283349582 | ||
| 020 | |a 9781283349581 | ||
| 020 | |a 9786613349583 | ||
| 020 | |a 6613349585 | ||
| 020 | |z 9781849682367 | ||
| 020 | |z 1849682364 | ||
| 029 | 1 | |a AU@ |b 000050967806 | |
| 029 | 1 | |a AU@ |b 000053023908 | |
| 029 | 1 | |a AU@ |b 000058967621 | |
| 029 | 1 | |a AU@ |b 000067103176 | |
| 029 | 1 | |a DEBBG |b BV040902372 | |
| 029 | 1 | |a DEBBG |b BV042959569 | |
| 029 | 1 | |a DEBSZ |b 37829881X | |
| 029 | 1 | |a DEBSZ |b 381384446 | |
| 029 | 1 | |a DEBSZ |b 423778390 | |
| 029 | 1 | |a NZ1 |b 14692180 | |
| 029 | 1 | |a UKMGB |b 018015094 | |
| 029 | 1 | |a DKDLA |b 820120-katalog:999930655605765 | |
| 035 | |a (OCoLC)742282647 |z (OCoLC)794554424 |z (OCoLC)961691066 |z (OCoLC)962725284 |z (OCoLC)988499353 |z (OCoLC)992062749 |z (OCoLC)1037784632 |z (OCoLC)1038665705 |z (OCoLC)1039187470 |z (OCoLC)1045582167 |z (OCoLC)1055347169 |z (OCoLC)1058228876 |z (OCoLC)1081240207 |z (OCoLC)1083554514 |z (OCoLC)1103262032 |z (OCoLC)1114371565 |z (OCoLC)1129356308 |z (OCoLC)1153015657 |z (OCoLC)1162530245 |z (OCoLC)1192337930 |z (OCoLC)1228528816 |z (OCoLC)1240508861 | ||
| 037 | |a CL0500000140 |b Safari Books Online | ||
| 050 | 4 | |a QA76.73.S67 |b D8 2011eb | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.756 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Du, Gordon. | |
| 245 | 1 | 0 | |a Mastering SQL queries for SAP Business one : |b utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / |c Gordon Du. |
| 246 | 3 | |a Mastering Structured Query Language queries for SAP Business One | |
| 260 | |a Birmingham : |b Packt Pub., |c 2011. | ||
| 300 | |a 1 online resource (1 electronic resource (331 pages)) : |b color illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 340 | |g polychrome. |2 rdacc |0 http://rdaregistry.info/termList/RDAColourContent/1003 | ||
| 347 | |a text file |2 rdaft |0 http://rdaregistry.info/termList/fileType/1002 | ||
| 505 | 0 | |a Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: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 | |
| 505 | 8 | |a Important table examplesTable links-the key for the right query; Primary key; Foreign key; Example of table links within SAP Business One; Base tables versus target tables; Keeping it simple-The key to build a good query; Summary; Chapter 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 | |
| 505 | 8 | |a Step 4-Conditions and relationsStep 5-Query wizard completion; What is the difference between Query generator and Query wizard?; Benefitting from built-in system queries; Summary; Chapter 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; The numbers of columns to be included; Column name descriptions; Clauses can follow this statement | |
| 505 | 8 | |a DISTINCT-duplicated records can be removedTOP-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; 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; LIKE-similar records can be found; GROUP BY-summarizing the data according to the list; HAVING-conditions to be defined in summary report | |
| 505 | 8 | |a ORDER BY-report result can be by your preferred orderUNION/UNION ALL-to put two or more queries together; Some important functions to return values; ISNULL() predicate; SUM() function; MAX() function; MIN() function; COUNT() function; DATEDIFF() function; DATEADD() function; DATEPART() function; CAST()/CONVERT() function; CASE expressions; IF expressions; Summary; Chapter 4:Query Examples; Why three categories have been chosen; Defining variables for queries; Case 4-R1: Four variables in one query; Case 4-R2: Variables first or last; Date function-where the most problems emerge | |
| 520 | |a Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook. | ||
| 546 | |a English. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a SAP Business one |v Handbooks, manuals, etc. |
| 630 | 0 | 7 | |a SAP Business one. |2 blmlsh |
| 630 | 0 | 7 | |a SAP Business one |2 fast |
| 650 | 0 | |a SQL (Computer program language) |v Handbooks, manuals, etc. | |
| 650 | 6 | |a SQL (Langage de programmation) |v Guides, manuels, etc. | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 655 | 7 | |a manuals (instructional materials) |2 aat | |
| 655 | 7 | |a handbooks. |2 aat | |
| 655 | 7 | |a Handbooks and manuals |2 fast | |
| 655 | 7 | |a Handbooks and manuals. |2 lcgft | |
| 655 | 7 | |a Guides et manuels. |2 rvmgf | |
| 776 | 0 | 8 | |i Print version: |a Du, Gordon. |t Mastering SQL queries for SAP Business one. |d Birmingham : Packt Publishing, 2011 |z 9781849682367 |w (OCoLC)773258124 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781849682367/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26944015 | ||
| 938 | |a ebrary |b EBRY |n ebr10477269 | ||
| 938 | |a EBSCOhost |b EBSC |n 369133 | ||
| 938 | |a YBP Library Services |b YANK |n 6939153 | ||
| 994 | |a 92 |b IZTAP | ||