Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Joe Celko's SQL Puzzles and Answers, Second Edition (The Morgan Kaufmann Series in Data Management Systems)

Buy
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 puzzlesand 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 Joes.

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 Readers Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celkos SQL for Smarties: Advanced SQL Programming, Joe Celkos SQL Puzzles and Answers, Joe Celkos Trees and Hierarchies in SQL for Smarties, and Joe Celkos SQL Style, all published by Morgan Kaufmann.

About the Author

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 Readers Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celkos SQL for Smarties: Advanced SQL Programming, Joe Celkos SQL Puzzles and Answers, Joe Celkos Trees and Hierarchies in SQL for Smarties, and Joe Celkos SQL Style, all published by Morgan Kaufmann.
(HTML tags aren't allowed.)

Photoshop CS4 Workflow: The Digital Photographer's Guide
Photoshop CS4 Workflow: The Digital Photographer's Guide
In this latest edition of his bestselling guide, expert digital photographer and author Tim Grey explains how proper workflow can alleviate repetitive parts of a project to allow you to focus on producing stunning results and he reveals expert tips and techniques that automate tasks, optimize output, and reduce time spent at the computer, and...
Algae for Biofuels and Energy (Developments in Applied Phycology)
Algae for Biofuels and Energy (Developments in Applied Phycology)

Microalgae are one of the most studied potential sources of biofuels and bioenergy. This book covers the key steps in the production of renewable biofuels from microalgae - strain selection, culture systems, inorganic carbon utilisation, lipid metabolism and quality, hydrogen production, genetic engineering, biomass harvesting,...

Expert Consolidation in Oracle Database 12c
Expert Consolidation in Oracle Database 12c

Expert Consolidation in Oracle Database 12c is your key to reducing data management costs and increasing data center efficiency. Consolidation and cloud computing are converging trends sweeping the industry. The same technologies enabling cloud computing enable consolidation as well, leading to savings on all fronts from the amount...


How Learning Works: Seven Research-Based Principles for Smart Teaching
How Learning Works: Seven Research-Based Principles for Smart Teaching

Distilling the research literature and translating the scientific approach into language relevant to a college or university teacher, this book introduces seven general principles of how students learn. The authors have drawn on research from a breadth of perspectives (cognitive, developmental, and social psychology; educational research;...

Wired for Innovation: How Information Technology is Reshaping the Economy
Wired for Innovation: How Information Technology is Reshaping the Economy
A wave of business innovation is driving the productivity resurgence in the U.S. economy. In Wired for Innovation, Erik Brynjolfsson and Adam Saunders describe how information technology directly or indirectly created this productivity explosion, reversing decades of slow growth. They argue that the companies with the highest level of...
Encyclopedia of Leadership 4 vol. set
Encyclopedia of Leadership 4 vol. set

The Encyclopedia of Leadership brings together for the first time everything that is known and truly matters about leadership as part of the human experience. Developed by the award-winning editorial team at Berkshire Publishing Group, the Encyclopedia includes hundreds of articles, written by 280 leading scholars and experts...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy