Joe Celko's SQL Puzzles and Answers, 2nd Edition

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 ad...

Full description

Saved in:
Bibliographic Details
Main Author: Celko, Joe (Author)
Corporate Author: Safari, an O’Reilly Media Company
Format: Electronic eBook
Language:English
Published: Morgan Kaufmann, 2006.
Edition:2nd edition.
Subjects:
Online Access: Full text (Wentworth users only)
Description
Summary: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
Physical Description:1 online resource (352 pages)
Format:Mode of access: World Wide Web.
ISBN:9780080491684
9780123735966
Reproduction Note:Electronic reproduction.
Source of Description, Etc. Note:Online resource; Title from title page (viewed October 9, 2006)
Issuing Body Note:Made available through: Safari, an O’Reilly Media Company.