Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems) - Softcover

Celko, Joe

Softcover

ISBN 10: 0123735963 ISBN 13: 9780123735966

Publisher: Morgan Kaufmann, 2006

Synopsis

Joe Celko's SQL Puzzles and Answers, Second Edition, challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations.

Author Joe Celko demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but also help develop the mindset needed to solve the many difficult SQL puzzles you face every day. This updated edition features many new puzzles; dozens of new solutions to puzzles; and new chapters on temporal query puzzles and common misconceptions about SQL and RDBMS that leads to problems.

This book is recommended for database programmers with a good knowledge of SQL.

• A great collection of tricky SQL puzzles with a variety of solutions and explanations
• Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems
• New edition features: Many new puzzles added!, Dozens of new solutions to puzzles, and using features in SQL-99, Code is edited to conform to SQL STYLE rules, New chapter on temporal query puzzles, New chapter on common misconceptions about SQL and RDBMS that leads to problems

About this title

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.

From the Back Cover

Joe Celko has been writing columns for the computer trade press and championing database programming techniques and ANSI/ISO standards via his newsgroup activity for 20 years.

In this complete revision and expansion of his first SQL Puzzles book, he challenges you with his trickiest puzzles―and then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but help develop the mindset needed to solve the many difficult SQL puzzles you face every day. Of course, part of the fun is to see whether or not you can write better solutions than Joe’s.

In addition to updating the solutions for SQL Style and SQL-99 (and beyond) standards, Joe has added many new puzzles, dozens of additional solutions, and new chapters.

•A great collection of tricky SQL puzzles with a variety of solutions and explanations.
•Joe uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems--many of which will help users solve their own problems.
• New edition features:
o Many new puzzles added!
o Dozens of new solutions to puzzles, and using features in SQL-99
o Code is edited to conform to SQL STYLE rules
o New chapter on temporal query puzzles
o New chapter on common misconceptions about SQL and RDBMS that leads to problems.

Joe Celko is a noted consultant, lecturer, teacher, and one of the most-read SQL authors in the world. He is well known for his ten years of service on the ANSI SQL standards committee, his dependable help on assorted SQL newsgroups, his column in Intelligent Enterprise (which won several Reader’s Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celko’s SQL for Smarties: Advanced SQL Programming, Joe Celko’s SQL Puzzles and Answers, Joe Celko’s Trees and Hierarchies in SQL for Smarties, and Joe Celko’s SQL Style, all published by Morgan Kaufmann.

Edition details

• Publisher: Morgan Kaufmann
• Publication date: 2006
• Language: English
• ISBN 10: 0123735963
• ISBN 13: 9780123735966
• Binding: Paperback
• Edition number: 2
• Number of pages: 352