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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| 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 | SCIDIR_ocm76301229 | ||
| 003 | OCoLC | ||
| 005 | 20231117014932.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) | ||
| 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 | ||
| 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 |
| 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. | ||
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 6 | |a SQL (Langage de programmation) |0 (CaQQLa)201-0187580 | |
| 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 |0 (OCoLC)fst01102869 | |
| 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://sciencedirect.uam.elogim.com/science/book/9780123693792 |z Texto completo |