Cargando…

Joe Celko's SQL for smarties : advanced SQL programming /

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL m...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Celko, Joe
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Amsterdam ; Boston : Morgan Kaufmann, ©2005.
Edición:3rd ed.
Colección:Morgan Kaufmann series in data management systems.
Temas:
Acceso en línea:Texto completo

MARC

LEADER 00000cam a22000004a 4500
001 EBSCO_ocm76301229
003 OCoLC
005 20231017213018.0
006 m o d
007 cr cnu---unuuu
008 061117s2005 ne a ob 001 0 eng d
010 |z  2005279919 
040 |a N$T  |b eng  |e pn  |c N$T  |d YDXCP  |d OCLCQ  |d UBY  |d IDEBK  |d E7B  |d OCLCQ  |d BUF  |d OCLCQ  |d OCLCF  |d OCLCQ  |d OPELS  |d OKU  |d DEBSZ  |d OCLCQ  |d COO  |d AZK  |d LOA  |d AGLDB  |d STF  |d MOR  |d PIFAG  |d ZCU  |d MERUC  |d OCLCQ  |d U3W  |d WRM  |d D6H  |d VTS  |d NRAMU  |d ICG  |d NLE  |d INT  |d VT2  |d OCLCQ  |d UKMGB  |d OCLCQ  |d LEAUB  |d DKC  |d AU@  |d OCLCQ  |d M8D  |d OL$  |d OCLCQ  |d K6U  |d UKAHL  |d OCLCO  |d OCLCQ  |d OCLCO 
015 |a GBB6H3521  |2 bnb 
016 7 |a 017572954  |2 Uk 
019 |a 148724010  |a 162572911  |a 427564028  |a 505120348  |a 647545619  |a 856959687  |a 961653360  |a 962635363  |a 966200259  |a 984776166  |a 988501258  |a 991924242  |a 1037785952  |a 1038623681  |a 1045519710  |a 1055388119  |a 1081282486  |a 1103257807  |a 1129363363 
020 |a 0080460046  |q (electronic bk.) 
020 |a 9780080460048  |q (electronic bk.) 
020 |z 0123693799  |q (pbk. ;  |q acid-free paper) 
020 |z 9780123693792  |q (print) 
029 1 |a AU@  |b 000051860399 
029 1 |a CHNEW  |b 000850355 
029 1 |a CHNEW  |b 001004926 
029 1 |a DEBBG  |b BV042307416 
029 1 |a DEBBG  |b BV043076753 
029 1 |a DEBBG  |b BV044084325 
029 1 |a DEBSZ  |b 405307829 
029 1 |a DEBSZ  |b 422261076 
029 1 |a DEBSZ  |b 43035181X 
029 1 |a NZ1  |b 12434931 
029 1 |a NZ1  |b 14539943 
029 1 |a UKMGB  |b 017572954 
029 1 |a YDXCP  |b 2491322 
035 |a (OCoLC)76301229  |z (OCoLC)148724010  |z (OCoLC)162572911  |z (OCoLC)427564028  |z (OCoLC)505120348  |z (OCoLC)647545619  |z (OCoLC)856959687  |z (OCoLC)961653360  |z (OCoLC)962635363  |z (OCoLC)966200259  |z (OCoLC)984776166  |z (OCoLC)988501258  |z (OCoLC)991924242  |z (OCoLC)1037785952  |z (OCoLC)1038623681  |z (OCoLC)1045519710  |z (OCoLC)1055388119  |z (OCoLC)1081282486  |z (OCoLC)1103257807  |z (OCoLC)1129363363 
037 |a 113079:113167  |b Elsevier Science & Technology  |n http://www.sciencedirect.com 
050 4 |a QA76.73.S67  |b C44 2005eb 
072 7 |a COM  |x 051310  |2 bisacsh 
072 7 |a COM  |x 051280  |2 bisacsh 
072 7 |a COM  |x 051130  |2 bisacsh 
082 0 4 |a 005.13/3  |2 22 
049 |a UAMI 
100 1 |a Celko, Joe. 
240 1 0 |a SQL for smarties 
245 1 0 |a Joe Celko's SQL for smarties :  |b advanced SQL programming /  |c Joe Celko. 
246 3 0 |a SQL for smarties 
250 |a 3rd ed. 
260 |a Amsterdam ;  |a Boston :  |b Morgan Kaufmann,  |c ©2005. 
300 |a 1 online resource (xxviii, 808 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 1 |a The Morgan Kaufmann series in data management systems 
504 |a Includes bibliographical references and index. 
505 0 |a Database design -- Normalization -- Numeric data in SQL -- Temporal data types in SQL -- Character data types in SQL -- NULLs : missing data in SQL -- Multiple column data elements -- Table operations -- Comparison or theta operators -- Valued predicates -- CASE expressions -- LIKE predicate -- Between and overlaps predicates -- The [NOT] IN() predicate -- EXISTS() predicate -- Quantified subquery predicates -- The SELECT statement -- VIEWs, derived tables, materialized tables, and temporary tables -- Partitioning data in queries -- Grouping operations -- Aggregate functions -- Auxiliary tables -- Statistics in SQL -- Regions, runs, gaps, sequences, and series -- Arrays in SQL -- Set operations -- Subsets -- Trees and hierarchies in SQL -- Temporal queries -- Graphs in SQL -- OLAP in SQL -- Transactions and concurrency control -- Optimizing SQL. 
588 0 |a Print version record. 
520 |a SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. In the third edition, Joe features new examples and updates to SQL-99, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics. * Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums. * Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment. * Offers tips for working around system deficiencies. * Continues to use war stories--updated!--that give insights into real-world SQL programming challenges. 
590 |a eBooks on EBSCOhost  |b EBSCO eBook Subscription Academic Collection - Worldwide 
650 0 |a SQL (Computer program language) 
650 6 |a SQL (Langage de programmation) 
650 7 |a COMPUTERS  |x Programming Languages  |x C♯  |2 bisacsh 
650 7 |a COMPUTERS  |x Programming Languages  |x Java.  |2 bisacsh 
650 7 |a COMPUTERS  |x Programming Languages  |x Pascal.  |2 bisacsh 
650 7 |a SQL (Computer program language)  |2 fast 
650 1 7 |a Programmeertalen.  |2 gtt 
650 1 7 |a SQL.  |2 gtt 
776 0 8 |i Print version:  |a Celko, Joe.  |s SQL for smarties.  |t Joe Celko's SQL for smarties.  |b 3rd ed.  |d Amsterdam ; Boston : Morgan Kaufmann, ©2005  |z 0123693799  |w (DLC) 2005279919  |w (OCoLC)61513309 
830 0 |a Morgan Kaufmann series in data management systems. 
856 4 0 |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=166707  |z Texto completo 
938 |a Askews and Holts Library Services  |b ASKH  |n AH23082173 
938 |a ebrary  |b EBRY  |n ebr10138250 
938 |a EBSCOhost  |b EBSC  |n 166707 
938 |a YBP Library Services  |b YANK  |n 2491322 
994 |a 92  |b IZTAP