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, ...
Read More
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 e
Read Less
Add this copy of Practical Sql: the Sequel [With Cdrom] to cart. $11.18, good condition, Sold by ThriftBooks-Reno rated 5.0 out of 5 stars, ships from Reno, NV, UNITED STATES, published 2001 by Addison Wesley Longman.
Add this copy of Practical Sql: the Sequel to cart. $39.00, very good condition, Sold by Books International rated 3.0 out of 5 stars, ships from Toronto, ON, CANADA, published 2001 by Addison Wesley Longman.
Add this copy of Practical Sql the Sequel (With Cd-Rom) to cart. $40.56, good condition, Sold by Bonita rated 4.0 out of 5 stars, ships from Santa Clarita, CA, UNITED STATES, published 2000 by Addison-Wesley.
Add this copy of Practical Sql: the Sequel to cart. $48.29, new condition, Sold by Books International rated 3.0 out of 5 stars, ships from Toronto, ON, CANADA, published 2001 by Addison Wesley Longman.
Add this copy of Practical Sql: the Sequel to cart. $53.10, new condition, Sold by discount_scientific_books rated 5.0 out of 5 stars, ships from Sterling Heights, MI, UNITED STATES, published 2001 by Addison Wesley Longman.
![Practical Sql: the Sequel [With Cdrom]](https://www3.alibris-static.com/isbn/9780201616385_t.gif)
