000756375 000__ 03497cam\a2200481Ii\4500
000756375 001__ 756375
000756375 005__ 20230306142012.0
000756375 006__ m\\\\\o\\d\\\\\\\\
000756375 007__ cr\cn\nnnunnun
000756375 008__ 160712s2016\\\\nyu\\\\\o\\\\\001\0\eng\d
000756375 020__ $$a9781484219553$$q(electronic book)
000756375 020__ $$a1484219554$$q(electronic book)
000756375 020__ $$z9781484219546
000756375 035__ $$aSP(OCoLC)ocn953456417
000756375 035__ $$aSP(OCoLC)953456417
000756375 040__ $$aN$T$$beng$$erda$$epn$$cN$T$$dYDXCP$$dGW5XE$$dN$T$$dIDEBK$$dEBLCP$$dOCLCF$$dAZU
000756375 049__ $$aISEA
000756375 050_4 $$aQA76.73.S67$$bC485 2016eb
000756375 08204 $$a005.75/6$$223
000756375 1001_ $$aChurcher, Clare,$$eauthor.
000756375 24510 $$aBeginning SQL queries$$h[electronic resource] :$$bfrom novice to professional /$$cClare Churcher.
000756375 250__ $$aSecond edition.
000756375 264_1 $$a[United States] :$$bApress,$$c2016.
000756375 264_2 $$aNew York, NY :$$bDistributed to the book trade worldwide by Springer,
000756375 264_4 $$c©2016
000756375 300__ $$a1 online resource.
000756375 336__ $$atext$$btxt$$2rdacontent
000756375 337__ $$acomputer$$bc$$2rdamedia
000756375 338__ $$aonline resource$$bcr$$2rdacarrier
000756375 500__ $$aIncludes index.
000756375 5050_ $$a1. Relational Database Overview -- 2. Simple Queries on One Table -- 3. A First Look at Joins -- 4. Nested Queries -- 5. Self Joins -- 6. Multiple Relationships Between Tables -- 7. Set Operations -- 8. Aggregate Operations -- 9. Window Function -- 10. Efficiency Considerations -- 11. Approaching A Query -- 12. Common Problems -- Chapter 13: Appendix 1: Sample Database -- Chapter 14: Appendix 2: Relational Notation.
000756375 506__ $$aAccess limited to authorized users.
000756375 520__ $$aGet started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporting on large data sets in order to generate knowledge to drive business decisions. Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Every relational database supports SQL for its expressiveness in writing queries underlying reports and business intelligence dashboards. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare Churcher's book, Beginning SQL Queries, 2nd Edition, lays well. Write simple queries to extract data from a single table Combine data from many tables into one business result using set operations Translate natural language questions into database queries providing meaningful information to the business Avoid errors associated with duplicated and null values Summarize data with amazing ease using the newly-added feature of window functions Tackle tricky queries with confidence that you are generating correct results Investigate and understand the effects of indexes on the efficiency of queries.
000756375 588__ $$aOnline resource; title from PDF title page (SpringerLink, viewed July 13, 2016).
000756375 650_0 $$aSQL (Computer program language)
000756375 650_0 $$aQuerying (Computer science)
000756375 650_0 $$aDatabase management.
000756375 650_0 $$aComputer programming.
000756375 650_0 $$aRelational databases.
000756375 852__ $$bebk
000756375 85640 $$3SpringerLink$$uhttps://univsouthin.idm.oclc.org/login?url=http://link.springer.com/10.1007/978-1-4842-1955-3$$zOnline Access$$91397441.1
000756375 909CO $$ooai:library.usi.edu:756375$$pGLOBAL_SET
000756375 980__ $$aEBOOK
000756375 980__ $$aBIB
000756375 982__ $$aEbook
000756375 983__ $$aOnline
000756375 994__ $$a92$$bISE