Sql For Smarties. Advanced Sql Programming, Second Edition (The Morgan Kaufmann Series in Data Management Systems) - Softcover

Celko, Joe

Softcover

ISBN 10: 1558605762 ISBN 13: 9781558605763

Verlag: Morgan Kaufmann, 1999

Inhaltsangabe

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques you need to transform yourself into an expert SQL programmer. Now, in this fully updated second edition, SQL mastermind Joe Celko keeps you moving forward, using his entertaining, conversational style to teach you the best solutions to old and new challenges and to convey the way what you need to think if you really want to get the most out of-your SQL programming efforts. Inside, logic- and set-based analyses replace the traditional, procedural approach to problem-solving, helping you make the conceptual leap that separates an SQL guru from the rest of the pack. As you catch on to Celko's approach, you'll devour what he bas to say about sortie of SQL's toughest topics : how aggregate functions really work, the best way to work with NULLs, how and why to fake array structures, and much more. This book gives special emphasis to SQL-92 and product-independent techniques that let you optimize performance or achieve highly specialized behavior, regardless of the RDBMS with which you work. If you serious about SQL, you won't let SQL, for Smarties out of your sight. Presents ail-new war stories that give you insight into real-world SQL programming challenges. Continues to cover SQL-89 but focuses heavily on the SQL-92 standard. Offers still more undocumented tips for working around system deficiencies. Teaches scores of advanced techniques that eau lie used with any product, in an SQL environment. Offers expert advice front a noted SQL authority and award-winning columnist.

Über diesen Titel

Über die Autorin bzw. den Autor

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.

Von der hinteren Coverseite

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques you need to transform yourself into an expert SQL programmer. Now, in this fully updated second edition, SQL mastermind Joe Celko keeps you moving forward, using his entertaining, conversational style to teach you the best solutions to old and new challenges and to convey the way you need to think if you really want to get the most out of your SQL programming efforts.

Inside, logic- and set-based analyses replace the traditional, procedural approach to problem-solving, helping you make the conceptual leap that separates an SQL guru from the rest of the pack. As you catch on to Celko's approach, you'll devour what he has to say about some of SQL's toughest topics: how aggregate functions really work, the best way to work with NULLs, how and why to fake array structures, and much more.

This book gives special emphasis to SQL-92 and product-independent techniques that let you optimize performance or achieve highly specialized behavior, regardless of the RDBMS with which you work. If you're serious about SQL, you won't let SQL for Smarties out of your sight.

Features

• Presents all-new war stories that give you insight into real-world SQL programming challenges.
  
• Continues to cover SQL-89 but focuses heavily on the SQL-92 standard.
  
• Offers still more undocumented tips for working around system deficiencies.
  
• Teaches scores of advanced techniques that can be used with any product, in any SQL environment.
  
• Offers expert advice from a noted SQL authority and award-winning columnist.

|

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques you need to transform yourself into an expert SQL programmer. Now, in this fully updated second edition, SQL mastermind Joe Celko keeps you moving forward, using his entertaining, conversational style to teach you the best solutions to old and new challenges and to conveythe way you need to think if you really want to get the most out of your SQL programming efforts.

Inside, logic- and set-based analyses replace the traditional, procedural approach to problem-solving, helping you make the conceptual leap that separates an SQL guru from the rest of the pack. As you catch on to Celko's approach, you'll devour what he has to say about some of SQL's toughest topics: how aggregate functions really work, the best way to work with NULLs, how and why to fake array structures, and much more.

This book gives special emphasis to SQL-92 and product-independent techniques that let you optimize performance or achieve highly specialized behavior, regardless of the RDBMS with which you work. If you're serious about SQL, you won't letSQL for Smarties out of your sight.

Features

• Presents all-new war stories that give you insight into real-world SQL programming challenges.
  
• Continues to cover SQL-89 but focuses heavily on the SQL-92 standard.
  
• Offers still more undocumented tips for working around system deficiencies.
  
• Teaches scores of advanced techniques that can be used with any product, in any SQL environment.
  
• Offers expert advice from a noted SQL authority and award-winning columnist.

Details zur Ausgabe

• Verlag: Morgan Kaufmann
• Erscheinungsdatum: 1999
• Sprache: Englisch
• ISBN 10: 1558605762
• ISBN 13: 9781558605763
• Einband: Tapa blanda
• Anzahl der Seiten: 555
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar