Joe Celko's SQL for Smarties, Fifth Edition: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems)

Valutazione media 3,94
( su 155 valutazioni fornite da Goodreads )
 
9780128007617: Joe Celko's SQL for Smarties, Fifth Edition: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems)

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, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. New to the fifth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth. SQL for Smarties explains some of the principles of SQL programming as well as the code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products. You’ll learn about computed columns and the DEFERRABLE options in constraints. An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions. The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions.

  • New to the 5th Edition:
    • Downloadable data sets, code samples, and vendor-specific implementations!
    • Overview of the bitemporal model
    • Extended coverage of descriptive statistic aggregate functions
    • New chapter covers flaws in DDL
    • Examination of traditional acid versus base transaction models
    • Reorganized to help you navigate related topics with ease
  • Expert advice from a noted SQL authority and award-winning columnist Joe Celko, who served on the ANSI SQL standards committee for over a decade
  • Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is SQL 92 or SQL 2011
  • Offers tips for working around deficiencies and gives insight into real-world challenges

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

About the Author:

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.

Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas.

He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

Review:

"...a must-read book for any SQL programmer, covering advanced topics in an understandable way...aimed at taking experienced SQL programmers and giving them the extras to make them experts." --I Programmer, 2015

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

I migliori risultati di ricerca su AbeBooks

1.

Joe Celko
Editore: ELSEVIER SCIENCE TECHNOLOGY, United States (2014)
ISBN 10: 0128007613 ISBN 13: 9780128007617
Nuovi Paperback Quantità: 10
Da
Book Depository hard to find
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro ELSEVIER SCIENCE TECHNOLOGY, United States, 2014. Paperback. Condizione libro: New. 5th Revised edition. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. Brand New Book. 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, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. New to the fifth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth. SQL for Smarties explains some of the principles of SQL programming as well as the code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products. You ll learn about computed columns and the DEFERRABLE options in constraints. An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions. The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions. Codice libro della libreria EOD9780128007617

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 42,19
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

2.

Joe Celko
ISBN 10: 0128007613 ISBN 13: 9780128007617
Nuovi Quantità: 1
Da
Book Park
(Southfield, MI, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Condizione libro: New. Brand New Book. Codice libro della libreria 0128007613BYR

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 43,45
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi

3.

Joe Celko
Editore: Elsevier Science 2014-12-02, Amsterdam (2014)
ISBN 10: 0128007613 ISBN 13: 9780128007617
Nuovi paperback Quantità: > 20
Da
Blackwell's
(Oxford, OX, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Elsevier Science 2014-12-02, Amsterdam, 2014. paperback. Condizione libro: New. Codice libro della libreria 9780128007617

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 44,23
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,39
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

4.

Joe Celko
Editore: ELSEVIER SCIENCE TECHNOLOGY, United States (2014)
ISBN 10: 0128007613 ISBN 13: 9780128007617
Nuovi Paperback Quantità: 10
Da
The Book Depository
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro ELSEVIER SCIENCE TECHNOLOGY, United States, 2014. Paperback. Condizione libro: New. 5th Revised edition. Language: English . Brand New Book. 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, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. New to the fifth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth. SQL for Smarties explains some of the principles of SQL programming as well as the code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products. You ll learn about computed columns and the DEFERRABLE options in constraints. An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions. The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions. Codice libro della libreria AAZ9780128007617

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 48,78
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

5.

Joe Celko
Editore: ELSEVIER SCIENCE TECHNOLOGY, United States (2014)
ISBN 10: 0128007613 ISBN 13: 9780128007617
Nuovi Paperback Quantità: 10
Da
The Book Depository US
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro ELSEVIER SCIENCE TECHNOLOGY, United States, 2014. Paperback. Condizione libro: New. 5th edition. Language: English . Brand New Book. 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, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. New to the fifth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth. SQL for Smarties explains some of the principles of SQL programming as well as the code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products. You ll learn about computed columns and the DEFERRABLE options in constraints. An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions. The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions. Codice libro della libreria AAZ9780128007617

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 48,93
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

6.

Celko, Joe (Independent Consultant, Austin, Texas)
Editore: Morgan Kaufmann (2014)
ISBN 10: 0128007613 ISBN 13: 9780128007617
Nuovi Quantità: > 20
Da
Books2Anywhere
(Fairford, GLOS, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Morgan Kaufmann, 2014. PAP. Condizione libro: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Codice libro della libreria GB-9780128007617

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 40,07
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 10,17
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

7.

Joe Celko
Editore: Elsevier Science & Technology
ISBN 10: 0128007613 ISBN 13: 9780128007617
Nuovi Paperback Quantità: > 20
Da
THE SAINT BOOKSTORE
(Southport, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Elsevier Science & Technology. Paperback. Condizione libro: new. BRAND NEW, Joe Celko's SQL for Smarties: Advanced SQL Programming (5th Revised edition), Joe Celko, 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, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. New to the fifth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth. SQL for Smarties explains some of the principles of SQL programming as well as the code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products. You'll learn about computed columns and the DEFERRABLE options in constraints. An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions. The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions. * New to the 5th Edition: * Downloadable data sets, code samples, and vendor-specific implementations!* Overview of the bitemporal model* Extended coverage of descriptive statistic aggregate functions* New chapter covers flaws in DDL* Examination of traditional acid versus base transaction models* Reorganized to help you navigate related topics with ease* Expert advice from a noted SQL authority and award-winning columnist Joe Celko, who served on the ANSI SQL standards committee for over a decade* Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is SQL 92 or SQL 2011 * Offers tips for working around deficiencies and gives insight into real-world challenges. Codice libro della libreria B9780128007617

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 45,52
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 7,86
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

8.

Celko, Joe
Editore: Morgan Kaufmann (2014)
ISBN 10: 0128007613 ISBN 13: 9780128007617
Nuovi Brossura Quantità: > 20
Valutazione libreria
[?]

Descrizione libro Morgan Kaufmann, 2014. Condizione libro: New. Series: The Morgan Kaufmann Series in Data Management Systems. Num Pages: 852 pages, colour illustrations. BIC Classification: UMT. Category: (P) Professional & Vocational. Dimension: 233 x 192 x 45. Weight in Grams: 1566. . 2014. 5th Edition. Paperback. . . . . . Codice libro della libreria V9780128007617

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 54,14
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Irlanda a: U.S.A.
Destinazione, tempi e costi

9.

CELKO, JOE
Editore: Morgan Kaufmann (2014)
ISBN 10: 0128007613 ISBN 13: 9780128007617
Nuovi Paperback Quantità: 10
Da
Herb Tandree Philosophy Books
(Stroud, GLOS, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Morgan Kaufmann, 2014. Paperback. Condizione libro: NEW. 9780128007617 This listing is a new book, a title currently in-print which we order directly and immediately from the publisher. Codice libro della libreria HTANDREE0895711

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 46,57
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 9,04
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

10.

CELKO, JOE
Editore: Morgan Kaufmann (2014)
ISBN 10: 0128007613 ISBN 13: 9780128007617
Nuovi Paperback Quantità: 10
Da
Herb Tandree Philosophy Books
(Stroud, GLOS, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Morgan Kaufmann, 2014. Paperback. Condizione libro: NEW. 9780128007617 This listing is a new book, a title currently in-print which we order directly and immediately from the publisher. Codice libro della libreria HTANDREE01199705

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 46,57
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 9,04
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

Vedi altre copie di questo libro

Vedi tutti i risultati per questo libro