Advanced Oracle SQL Programming: The Expert Guide to Writing Complex Queries (Oracle In-Focus series) (Volume 28)

Amazon.com Price: $39.95 (as of 05/05/2019 14:22 PST- Details)

Categories: , , , , , ,

Description

Oracle SQL is among the world’s most powerful dialects, packed with advanced functions and features that give Oracle SQL procedural language capabilities. The use of these powerful features it’s no longer necessary to embed Oracle SQL inside a procedural language, and native Oracle SQL can now be used to solve complex query problems. This is an indispensable book for all Oracle DBA’s and developers who want to be mindful the best way to apply Oracle SQL features for complex queries. Written by a certified Oracle Master and Oracle ACE, this advanced book shows working examples of the best way to leverage Oracle SQL’s powerful built-in functions for fast extraction of complex data and the best way to use native SQL for procedural processing. Each developer needs to know the way to use Oracle SQL to summarize and aggregate data from large tables and the best way to use powerful features such as the “model” clause to make SQL act as a procedural language. This book shows important techniques on the best way to leverage Oracle’s powerful XML interface to quickly format Oracle data with XML for instant publication. This isn’t a book for beginners or dilettantes and it’s designed for the professional Oracle developer, covering many advanced Oracle SQL techniques including XML queries, Oracle SQL analytics, SQL for aggregation, and traversing Hierarchies. Best of all, the writer reveals secrets for retrieving Oracle data faster and more elegantly than the traditional approaches to writing SQL.

Related products

Home » Shop » Books » Subjects » Computers and Technology » Databases and Big Data » Oracle » Advanced Oracle SQL Programming: The Expert Guide to Writing Complex Queries (Oracle In-Focus series) (Volume 28)

Recent Products