- Shopping Bag ( 0 items )
From Barnes & NobleThe Barnes & Noble Review
Ever notice that real-world SQL isn't the same as the SQL in the introductory books? If you're trying to put your basic SQL knowledge to work solving real business problems, real-world SQL is what you need, and here's where to find it.
Practical SQL: The Sequel was carefully crafted to move you from classroom to reality. To begin with, it's organized around the tasks you're likely to perform, not abstract SQL features. For example, you'll learn about SQL functions and predicates in the context of a discussion of cleaning dirty data containing case problems, size problems, or embedded garbage. In a chapter on translating values, you'll start with simple DECODE and CASE techniques, and move on to characteristic functions, UNION, joins, outer joins, embedded subqueries, and conditional elements
The book's many examples have been tested on enterprise database platforms from Oracle, Microsoft, Sybase, and Informix. Where platform differences exist, as in the case of date conversions, they're duly explained -- making the book a handy resource for anyone switching platforms. All the examples run against the same database -- which is provided on the CD-ROM, along with all the files and scripts needed to recreate that database on each platform.
Whether you're trying to get past the limitations of your report writer, or support queries written just before your predecessor skipped town, Practical SQL: The Sequel is one SQL book that tells it like it is. (Bill Camarda)
Bill Camarda is a consultant and writer with nearly 20 years' experience in helping technology companies deploy and market advanced software, computing, and networking products and services. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition.