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...
Gespeichert in:
1. Verfasser: | |
---|---|
Format: | Elektronisch E-Book |
Sprache: | English |
Veröffentlicht: |
Amsterdam ; Boston :
Morgan Kaufmann,
©2005.
|
Ausgabe: | 3rd ed. |
Schriftenreihe: | Morgan Kaufmann series in data management systems.
|
Schlagworte: | |
Online-Zugang: | Volltext Volltext |
Zusammenfassung: | 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. |
Beschreibung: | 1 online resource (xxviii, 808 pages) : illustrations |
Bibliographie: | Includes bibliographical references and index. |
ISBN: | 0080460046 9780080460048 |
Internformat
MARC
LEADER | 00000cam a22000004a 4500 | ||
---|---|---|---|
001 | ZDB-4-EBA-ocm76301229 | ||
003 | OCoLC | ||
005 | 20241004212047.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 |d OCLCL |d EZC |d UKCRE | ||
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 1034898939 |a 1037785952 |a 1038623681 |a 1045519710 |a 1055388119 |a 1081282486 |a 1103257807 |a 1129363363 |a 1153003965 | ||
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) | ||
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)1034898939 |z (OCoLC)1037785952 |z (OCoLC)1038623681 |z (OCoLC)1045519710 |z (OCoLC)1055388119 |z (OCoLC)1081282486 |z (OCoLC)1103257807 |z (OCoLC)1129363363 |z (OCoLC)1153003965 | ||
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 | 7 | |a 005.13/3 |2 22 | |
049 | |a MAIN | ||
100 | 1 | |a Celko, Joe. |0 http://id.loc.gov/authorities/names/n95049103 | |
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. | ||
650 | 0 | |a SQL (Computer program language) |0 http://id.loc.gov/authorities/subjects/sh86006628 | |
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 |
655 | 7 | |a dissertations. |2 aat | |
655 | 7 | |a Academic theses |2 fast | |
655 | 7 | |a Academic theses. |2 lcgft |0 http://id.loc.gov/authorities/genreForms/gf2014026039 | |
655 | 7 | |a Thèses et écrits académiques. |2 rvmgf | |
758 | |i has work: |a SQL for smarties (Text) |1 https://id.oclc.org/worldcat/entity/E39PCGJvCJJt8bYGCFj8FQtgw3 |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
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. |0 http://id.loc.gov/authorities/names/n90627178 | |
856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://www.sciencedirect.com/science/book/9780123693792 |3 Volltext |
856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=166707 |3 Volltext |
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 GEBAY | ||
912 | |a ZDB-4-EBA | ||
049 | |a DE-863 |
Datensatz im Suchindex
DE-BY-FWS_katkey | ZDB-4-EBA-ocm76301229 |
---|---|
_version_ | 1816881642593058816 |
adam_text | |
any_adam_object | |
author | Celko, Joe |
author_GND | http://id.loc.gov/authorities/names/n95049103 |
author_facet | Celko, Joe |
author_role | |
author_sort | Celko, Joe |
author_variant | j c jc |
building | Verbundindex |
bvnumber | localFWS |
callnumber-first | Q - Science |
callnumber-label | QA76 |
callnumber-raw | QA76.73.S67 C44 2005eb |
callnumber-search | QA76.73.S67 C44 2005eb |
callnumber-sort | QA 276.73 S67 C44 42005EB |
callnumber-subject | QA - Mathematics |
collection | ZDB-4-EBA |
contents | 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. |
ctrlnum | (OCoLC)76301229 |
dewey-full | 005.13/3 |
dewey-hundreds | 000 - Computer science, information, general works |
dewey-ones | 005 - Computer programming, programs, data, security |
dewey-raw | 005.13/3 |
dewey-search | 005.13/3 |
dewey-sort | 15.13 13 |
dewey-tens | 000 - Computer science, information, general works |
discipline | Informatik |
edition | 3rd ed. |
format | Electronic eBook |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06233cam a22007454a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocm76301229 </controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu---unuuu</controlfield><controlfield tag="008">061117s2005 ne a ob 001 0 eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="z"> 2005279919</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">N$T</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">N$T</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UBY</subfield><subfield code="d">IDEBK</subfield><subfield code="d">E7B</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">BUF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OPELS</subfield><subfield code="d">OKU</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">COO</subfield><subfield code="d">AZK</subfield><subfield code="d">LOA</subfield><subfield code="d">AGLDB</subfield><subfield code="d">STF</subfield><subfield code="d">MOR</subfield><subfield code="d">PIFAG</subfield><subfield code="d">ZCU</subfield><subfield code="d">MERUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">U3W</subfield><subfield code="d">WRM</subfield><subfield code="d">D6H</subfield><subfield code="d">VTS</subfield><subfield code="d">NRAMU</subfield><subfield code="d">ICG</subfield><subfield code="d">NLE</subfield><subfield code="d">INT</subfield><subfield code="d">VT2</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">LEAUB</subfield><subfield code="d">DKC</subfield><subfield code="d">AU@</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">M8D</subfield><subfield code="d">OL$</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">K6U</subfield><subfield code="d">UKAHL</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield><subfield code="d">EZC</subfield><subfield code="d">UKCRE</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB6H3521</subfield><subfield code="2">bnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">017572954</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">148724010</subfield><subfield code="a">162572911</subfield><subfield code="a">427564028</subfield><subfield code="a">505120348</subfield><subfield code="a">647545619</subfield><subfield code="a">856959687</subfield><subfield code="a">961653360</subfield><subfield code="a">962635363</subfield><subfield code="a">966200259</subfield><subfield code="a">984776166</subfield><subfield code="a">988501258</subfield><subfield code="a">991924242</subfield><subfield code="a">1034898939</subfield><subfield code="a">1037785952</subfield><subfield code="a">1038623681</subfield><subfield code="a">1045519710</subfield><subfield code="a">1055388119</subfield><subfield code="a">1081282486</subfield><subfield code="a">1103257807</subfield><subfield code="a">1129363363</subfield><subfield code="a">1153003965</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0080460046</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080460048</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">0123693799</subfield><subfield code="q">(pbk. ;</subfield><subfield code="q">acid-free paper)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9780123693792</subfield><subfield code="q">(print)</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)76301229</subfield><subfield code="z">(OCoLC)148724010</subfield><subfield code="z">(OCoLC)162572911</subfield><subfield code="z">(OCoLC)427564028</subfield><subfield code="z">(OCoLC)505120348</subfield><subfield code="z">(OCoLC)647545619</subfield><subfield code="z">(OCoLC)856959687</subfield><subfield code="z">(OCoLC)961653360</subfield><subfield code="z">(OCoLC)962635363</subfield><subfield code="z">(OCoLC)966200259</subfield><subfield code="z">(OCoLC)984776166</subfield><subfield code="z">(OCoLC)988501258</subfield><subfield code="z">(OCoLC)991924242</subfield><subfield code="z">(OCoLC)1034898939</subfield><subfield code="z">(OCoLC)1037785952</subfield><subfield code="z">(OCoLC)1038623681</subfield><subfield code="z">(OCoLC)1045519710</subfield><subfield code="z">(OCoLC)1055388119</subfield><subfield code="z">(OCoLC)1081282486</subfield><subfield code="z">(OCoLC)1103257807</subfield><subfield code="z">(OCoLC)1129363363</subfield><subfield code="z">(OCoLC)1153003965</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">113079:113167</subfield><subfield code="b">Elsevier Science & Technology</subfield><subfield code="n">http://www.sciencedirect.com</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.73.S67</subfield><subfield code="b">C44 2005eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">051310</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">051280</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">051130</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.13/3</subfield><subfield code="2">22</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Celko, Joe.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n95049103</subfield></datafield><datafield tag="240" ind1="1" ind2="0"><subfield code="a">SQL for smarties</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Joe Celko's SQL for smarties :</subfield><subfield code="b">advanced SQL programming /</subfield><subfield code="c">Joe Celko.</subfield></datafield><datafield tag="246" ind1="3" ind2="0"><subfield code="a">SQL for smarties</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">3rd ed.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Amsterdam ;</subfield><subfield code="a">Boston :</subfield><subfield code="b">Morgan Kaufmann,</subfield><subfield code="c">©2005.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (xxviii, 808 pages) :</subfield><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">The Morgan Kaufmann series in data management systems</subfield></datafield><datafield tag="504" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references and index.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="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.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">SQL (Computer program language)</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh86006628</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">SQL (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Programming Languages</subfield><subfield code="x">C♯</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Programming Languages</subfield><subfield code="x">Java.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Programming Languages</subfield><subfield code="x">Pascal.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SQL (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1="1" ind2="7"><subfield code="a">Programmeertalen.</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1="1" ind2="7"><subfield code="a">SQL.</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">dissertations.</subfield><subfield code="2">aat</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Academic theses</subfield><subfield code="2">fast</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Academic theses.</subfield><subfield code="2">lcgft</subfield><subfield code="0">http://id.loc.gov/authorities/genreForms/gf2014026039</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Thèses et écrits académiques.</subfield><subfield code="2">rvmgf</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">SQL for smarties (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCGJvCJJt8bYGCFj8FQtgw3</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Celko, Joe.</subfield><subfield code="s">SQL for smarties.</subfield><subfield code="t">Joe Celko's SQL for smarties.</subfield><subfield code="b">3rd ed.</subfield><subfield code="d">Amsterdam ; Boston : Morgan Kaufmann, ©2005</subfield><subfield code="z">0123693799</subfield><subfield code="w">(DLC) 2005279919</subfield><subfield code="w">(OCoLC)61513309</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Morgan Kaufmann series in data management systems.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n90627178</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://www.sciencedirect.com/science/book/9780123693792</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=166707</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH23082173</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10138250</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">166707</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">2491322</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
genre | dissertations. aat Academic theses fast Academic theses. lcgft http://id.loc.gov/authorities/genreForms/gf2014026039 Thèses et écrits académiques. rvmgf |
genre_facet | dissertations. Academic theses Academic theses. Thèses et écrits académiques. |
id | ZDB-4-EBA-ocm76301229 |
illustrated | Illustrated |
indexdate | 2024-11-27T13:15:58Z |
institution | BVB |
isbn | 0080460046 9780080460048 |
language | English |
oclc_num | 76301229 |
open_access_boolean | |
owner | MAIN DE-863 DE-BY-FWS |
owner_facet | MAIN DE-863 DE-BY-FWS |
physical | 1 online resource (xxviii, 808 pages) : illustrations |
psigel | ZDB-4-EBA |
publishDate | 2005 |
publishDateSearch | 2005 |
publishDateSort | 2005 |
publisher | Morgan Kaufmann, |
record_format | marc |
series | Morgan Kaufmann series in data management systems. |
series2 | The Morgan Kaufmann series in data management systems |
spelling | Celko, Joe. http://id.loc.gov/authorities/names/n95049103 SQL for smarties Joe Celko's SQL for smarties : advanced SQL programming / Joe Celko. 3rd ed. Amsterdam ; Boston : Morgan Kaufmann, ©2005. 1 online resource (xxviii, 808 pages) : illustrations text txt rdacontent computer c rdamedia online resource cr rdacarrier The Morgan Kaufmann series in data management systems Includes bibliographical references and index. 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. Print version record. 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. SQL (Computer program language) http://id.loc.gov/authorities/subjects/sh86006628 SQL (Langage de programmation) COMPUTERS Programming Languages C♯ bisacsh COMPUTERS Programming Languages Java. bisacsh COMPUTERS Programming Languages Pascal. bisacsh SQL (Computer program language) fast Programmeertalen. gtt SQL. gtt dissertations. aat Academic theses fast Academic theses. lcgft http://id.loc.gov/authorities/genreForms/gf2014026039 Thèses et écrits académiques. rvmgf has work: SQL for smarties (Text) https://id.oclc.org/worldcat/entity/E39PCGJvCJJt8bYGCFj8FQtgw3 https://id.oclc.org/worldcat/ontology/hasWork Print version: Celko, Joe. SQL for smarties. Joe Celko's SQL for smarties. 3rd ed. Amsterdam ; Boston : Morgan Kaufmann, ©2005 0123693799 (DLC) 2005279919 (OCoLC)61513309 Morgan Kaufmann series in data management systems. http://id.loc.gov/authorities/names/n90627178 FWS01 ZDB-4-EBA FWS_PDA_EBA https://www.sciencedirect.com/science/book/9780123693792 Volltext FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=166707 Volltext |
spellingShingle | Celko, Joe Joe Celko's SQL for smarties : advanced SQL programming / Morgan Kaufmann series in data management systems. 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. SQL (Computer program language) http://id.loc.gov/authorities/subjects/sh86006628 SQL (Langage de programmation) COMPUTERS Programming Languages C♯ bisacsh COMPUTERS Programming Languages Java. bisacsh COMPUTERS Programming Languages Pascal. bisacsh SQL (Computer program language) fast Programmeertalen. gtt SQL. gtt |
subject_GND | http://id.loc.gov/authorities/subjects/sh86006628 http://id.loc.gov/authorities/genreForms/gf2014026039 |
title | Joe Celko's SQL for smarties : advanced SQL programming / |
title_alt | SQL for smarties |
title_auth | Joe Celko's SQL for smarties : advanced SQL programming / |
title_exact_search | Joe Celko's SQL for smarties : advanced SQL programming / |
title_full | Joe Celko's SQL for smarties : advanced SQL programming / Joe Celko. |
title_fullStr | Joe Celko's SQL for smarties : advanced SQL programming / Joe Celko. |
title_full_unstemmed | Joe Celko's SQL for smarties : advanced SQL programming / Joe Celko. |
title_short | Joe Celko's SQL for smarties : |
title_sort | joe celko s sql for smarties advanced sql programming |
title_sub | advanced SQL programming / |
topic | SQL (Computer program language) http://id.loc.gov/authorities/subjects/sh86006628 SQL (Langage de programmation) COMPUTERS Programming Languages C♯ bisacsh COMPUTERS Programming Languages Java. bisacsh COMPUTERS Programming Languages Pascal. bisacsh SQL (Computer program language) fast Programmeertalen. gtt SQL. gtt |
topic_facet | SQL (Computer program language) SQL (Langage de programmation) COMPUTERS Programming Languages C♯ COMPUTERS Programming Languages Java. COMPUTERS Programming Languages Pascal. Programmeertalen. SQL. dissertations. Academic theses Academic theses. Thèses et écrits académiques. |
url | https://www.sciencedirect.com/science/book/9780123693792 https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=166707 |
work_keys_str_mv | AT celkojoe sqlforsmarties AT celkojoe joecelkossqlforsmartiesadvancedsqlprogramming |