Joe Celko's SQL for smarties: advanced SQL programming
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Amsterdam
Morgan Kaufmann
©2005
|
| Ausgabe: | 3rd ed |
| Schriftenreihe: | Morgan Kaufmann series in data management systems
|
| Schlagworte: | |
| Online-Zugang: | FAW01 FAW02 Volltext |
| Beschreibung: | 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. 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-Ressource (xxviii, 808 pages) |
| ISBN: | 0080460046 0123693799 9780080460048 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043076753 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 151126s2005 |||| o||u| ||||||eng d | ||
| 020 | |a 0080460046 |c electronic bk. |9 0-08-046004-6 | ||
| 020 | |a 0123693799 |c pbk. : acidfree paper |9 0-12-369379-9 | ||
| 020 | |a 9780080460048 |c electronic bk. |9 978-0-08-046004-8 | ||
| 035 | |a (OCoLC)76301229 | ||
| 035 | |a (DE-599)BVBBV043076753 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1046 |a DE-1047 | ||
| 082 | 0 | |a 005.13/3 |2 22 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Celko, Joe |e Verfasser |4 aut | |
| 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 | 1 | 3 | |a SQL for smarties |
| 250 | |a 3rd ed | ||
| 264 | 1 | |a Amsterdam |b Morgan Kaufmann |c ©2005 | |
| 300 | |a 1 Online-Ressource (xxviii, 808 pages) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 490 | 0 | |a Morgan Kaufmann series in data management systems | |
| 500 | |a Includes bibliographical references and index | ||
| 500 | |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. | ||
| 500 | |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 | 7 | |a COMPUTERS / Programming Languages / C♯ |2 bisacsh | |
| 650 | 7 | |a COMPUTERS / Programming Languages / Java |2 bisacsh | |
| 650 | 7 | |a COMPUTERS / Programming Languages / Pascal |2 bisacsh | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 650 | 7 | |a Programmeertalen |2 gtt | |
| 650 | 7 | |a SQL. |2 gtt | |
| 650 | 4 | |a SQL (Computer program language) | |
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Programmierung |0 (DE-588)4076370-5 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 0 | 1 | |a Programmierung |0 (DE-588)4076370-5 |D s |
| 689 | 0 | |8 1\p |5 DE-604 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druckausgabe |z 978-0-12-369379-2 |
| 856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=166707 |x Aggregator |3 Volltext |
| 912 | |a ZDB-4-EBA | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-028500945 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=166707 |l FAW01 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=166707 |l FAW02 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1804175464961409024 |
|---|---|
| any_adam_object | |
| author | Celko, Joe |
| author_facet | Celko, Joe |
| author_role | aut |
| author_sort | Celko, Joe |
| author_variant | j c jc |
| building | Verbundindex |
| bvnumber | BV043076753 |
| classification_rvk | ST 271 |
| collection | ZDB-4-EBA |
| ctrlnum | (OCoLC)76301229 (DE-599)BVBBV043076753 |
| 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>04618nmm a2200601zc 4500</leader><controlfield tag="001">BV043076753</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151126s2005 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0080460046</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">0-08-046004-6</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0123693799</subfield><subfield code="c">pbk. : acidfree paper</subfield><subfield code="9">0-12-369379-9</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080460048</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-0-08-046004-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)76301229</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043076753</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1046</subfield><subfield code="a">DE-1047</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.13/3</subfield><subfield code="2">22</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Celko, Joe</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</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="1" ind2="3"><subfield code="a">SQL for smarties</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">3rd ed</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Amsterdam</subfield><subfield code="b">Morgan Kaufmann</subfield><subfield code="c">©2005</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xxviii, 808 pages)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Morgan Kaufmann series in data management systems</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references and index</subfield></datafield><datafield tag="500" ind1=" " 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="500" 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="7"><subfield code="a">COMPUTERS / Programming Languages / C♯</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / Java</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / 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=" " ind2="7"><subfield code="a">Programmeertalen</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SQL.</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Programmierung</subfield><subfield code="0">(DE-588)4076370-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Programmierung</subfield><subfield code="0">(DE-588)4076370-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druckausgabe</subfield><subfield code="z">978-0-12-369379-2</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=166707</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028500945</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=166707</subfield><subfield code="l">FAW01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=166707</subfield><subfield code="l">FAW02</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV043076753 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:16:43Z |
| institution | BVB |
| isbn | 0080460046 0123693799 9780080460048 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028500945 |
| oclc_num | 76301229 |
| open_access_boolean | |
| owner | DE-1046 DE-1047 |
| owner_facet | DE-1046 DE-1047 |
| physical | 1 Online-Ressource (xxviii, 808 pages) |
| psigel | ZDB-4-EBA ZDB-4-EBA FAW_PDA_EBA |
| publishDate | 2005 |
| publishDateSearch | 2005 |
| publishDateSort | 2005 |
| publisher | Morgan Kaufmann |
| record_format | marc |
| series2 | Morgan Kaufmann series in data management systems |
| spelling | Celko, Joe Verfasser aut SQL for smarties Joe Celko's SQL for smarties advanced SQL programming Joe Celko 3rd ed Amsterdam Morgan Kaufmann ©2005 1 Online-Ressource (xxviii, 808 pages) txt rdacontent c rdamedia cr rdacarrier 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. 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 COMPUTERS / Programming Languages / C♯ bisacsh COMPUTERS / Programming Languages / Java bisacsh COMPUTERS / Programming Languages / Pascal bisacsh SQL (Computer program language) fast Programmeertalen gtt SQL. gtt SQL (Computer program language) SQL (DE-588)4134010-3 gnd rswk-swf Programmierung (DE-588)4076370-5 gnd rswk-swf SQL (DE-588)4134010-3 s Programmierung (DE-588)4076370-5 s 1\p DE-604 Erscheint auch als Druckausgabe 978-0-12-369379-2 http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=166707 Aggregator Volltext 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Celko, Joe Joe Celko's SQL for smarties advanced SQL programming COMPUTERS / Programming Languages / C♯ bisacsh COMPUTERS / Programming Languages / Java bisacsh COMPUTERS / Programming Languages / Pascal bisacsh SQL (Computer program language) fast Programmeertalen gtt SQL. gtt SQL (Computer program language) SQL (DE-588)4134010-3 gnd Programmierung (DE-588)4076370-5 gnd |
| subject_GND | (DE-588)4134010-3 (DE-588)4076370-5 |
| 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 | COMPUTERS / Programming Languages / C♯ bisacsh COMPUTERS / Programming Languages / Java bisacsh COMPUTERS / Programming Languages / Pascal bisacsh SQL (Computer program language) fast Programmeertalen gtt SQL. gtt SQL (Computer program language) SQL (DE-588)4134010-3 gnd Programmierung (DE-588)4076370-5 gnd |
| topic_facet | COMPUTERS / Programming Languages / C♯ COMPUTERS / Programming Languages / Java COMPUTERS / Programming Languages / Pascal SQL (Computer program language) Programmeertalen SQL. SQL Programmierung |
| url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=166707 |
| work_keys_str_mv | AT celkojoe sqlforsmarties AT celkojoe joecelkossqlforsmartiesadvancedsqlprogramming |