Joe Celko's SQL for Smarties: Advanced SQL Programming

by JoeCelko (Author)

• Used

  Paperback
  1995

  $3.24

  Get the most from your database applications through clever SQL programming Joe Celko shares his most useful tips and tricks for advanced SQL programming to help the working programmer gain performance and work around system deficiencies. Addressing real problems that people building real applications face, Joe provides new and creative solutions. A noted consultant, lecturer, and columnist for DBMS and Database Programming & Design magazines, Joe uses entertaining anecdotes and war stories to provide real-world insight into SQL programming and warn about potential problems. Become an expert programmer This is the first advanced SQL book available that provides a comprehensive presentation of the techniques necessary to help you progress from a casual user of SQL to an expert programmer. Joe uses an informal, conversational writing style to explain why a particular trick works, so the working programmer can apply it directly to his or her own programming needs. Relying primarily on the SQL-89 features that are now supported by commercial RDBMSs, he also includes an extensive discussion of SQL-92, with information on how it's being implemented in current and future database products. The tips and techniques presented here are not product specific, so they allow programmers to maximize any system's performance.

• Used

  Paperback
  1999

  $3.24

  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.