Practical SQL Handbook by Bowman, Judith S ISBN 0201616386
From Student Book World
|
[edit] Practical SQL Handbook
Sequel to 'Practical SQL Handbook'.
For those who are working with SQL systems - or preparing to do so - this book offers information organized by use rather than by feature. Therefore, readers can turn to specific business problems and learn how to solve them with the appropriate SQL features. In particular, the book focuses on the real-world challenges of dealing with legacy systems, inherited problematic code, dirty data, and query tuning for better performance. The following important topics are addressed: * Finding and fixing dirty data with LIKE, BETWEEN, and LOCATE * Managing multiples and other complex data problems with ROWID, SIMILAR, GROUP BY, and HAVING * Handling the multiple display formats of dates * Translating values to expand compressed codes with CASE, DECODE, point functions, UNION, and subqueries * Manipulating numbers, including using auto-numbering mechanisms, finding the high value, locating every Nth, and more. * Tuning queries for enhanced performance, focusing on indexes and the optimizer * Comparing vendors system catalogs and system functions * Using SQL to generate SQL for cleanup and permission scripts as well as creating test data A business-based working database serves as a running example throughout the book. It provides the context for numerous code samples, all of which are tested on multiple systems, including Adaptive Server Anywhere, Oracle, Informix, Microsoft SQL Server, and Sybase Adaptive Server Enterprise. The accompanying CD-ROM contains the full sample database as well as Adaptive Server Anywhere.
[edit] Book Details
[edit] Title
Practical SQL Handbook
[edit] Author
Bowman, Judith S
[edit] ISBN
0201616386
[edit] Published
29/11/2000
[edit] Publisher
Addison-Wesley
[edit] Binding
PAPERBACK
[edit] Retail Price
30.99 (GBP)
[edit] Typical Price Online
30.99 (GBP)
[edit] Buy Book Online
If you wish to purchase Practical SQL Handbook, written by Bowman, Judith S and published by Addison-Wesley on 29/11/2000 then we have listed a few select online book retailers who can provide good value and service.
| ISBN 0201616386 |
|---|
You may also wish to visit Stake - Entrepreneurs Networking Community which has access to Internet Business Forums, Business Investment, Sales Forums, Purchasing Forums and Marketing Forums.
