"Oracle SQL Recipes" by Darl Kuhn, Grant Allen, and Bob Bryla offers its readers tested and working examples of SQL that have been used to solve common problems faced by developers and database administrators on a daily basis. The book covers a vast variety of SQL solutions; covering topics such as common query patterns, XML, large objects, tuning, and troubleshooting.
Targeted at developers and database administrators who write SQL to run against an Oracle database, "Oracle SQL Recipes" is for those wanting a good example to help them get on with their work. The book promises to provide:
- Example-based, quality solutions to everyday problems
- Solutions first, keeping discussions short
- Solves the most commonly encountered SQL problems
Lessons expected to be taken away from the book include the ability to:
- Recognize common query patterns and apply their corresponding solutions.
- Solve common reporting problems such as sorting rows into buckets.
- Troubleshoot SQL performance problems.
- Create and manage database objects such as tables, indexes, and views.
- Work with XML and tree-structured data.
- Take advantage of analytic functions, regular expressions, hierarchical query support, and other powerful aspects of Oracle SQL.
Currently there are 18 chapters of this upcoming book available under the Apress Alpha Program, which allows readers to purchase books as they are being written at the listed eBook price and have access to chapters as they are published. Participants are encouraged to read and review via a nonpublic feedback button as the book develops. The Alpha Book Price for "Oracle SQL Recipes" is listed at $34.99.
More Information
Oracle SQL Recipes: A Problem-Solution Approach - book from Apress
Apress Alpha Program
[...read more...]