|
Books > Computing & IT > Computer programming
|
Buy Now
Oracle SQL Revealed - Executing Business Logic in the Database Engine (Paperback, 1st ed.)
Loot Price: R661
Discovery Miles 6 610
You Save: R116
(15%)
|
|
|
Oracle SQL Revealed - Executing Business Logic in the Database Engine (Paperback, 1st ed.)
Expected to ship within 10 - 15 working days
|
Write queries using little-known, but powerful, SQL features
implemented in Oracle's database engine. You will be able to take
advantage of Oracle's power in implementing business logic, thereby
maximizing return from your company's investment in Oracle Database
products. Important features and aspects of SQL covered in this
book include the model clause, row pattern matching, analytic and
aggregate functions, and recursive subquery factoring, just to name
a few. The focus is on implementing business logic in pure SQL,
with a comparison of different approaches that can be used to write
SELECT statements to return results that drive good decision making
and competitive action in the marketplace. This book covers
features that are often not well known, and sometimes not
implemented in competing products. Chapters on query transformation
and logical execution order provide a grasp of the big picture in
which the individual SQL features described in the other chapters
are executed. Also included are a discussion on when to use the
procedural capabilities from PL/SQL, and a series of examples
showing different mixes of SQL features being applied in common
types of queries that you are likely to encounter. What You Will
Learn Gain competitive advantage from Oracle SQL Know when to step
up to PL/SQL versus staying in SQL Become familiar with query
transformations and join mechanics Apply the model clause and
analytic functions to business intelligence queries Make use of
features that are specific to Oracle Database, such as row pattern
matching Understand the pros and cons of different SQL approaches
to solving common query tasks Traverse hierarchies using CONNECT BY
and recursive subquery factoring Who This Book Is For Database
programmers with some Oracle Database experience. The book is also
for SQL developers who are moving to the Oracle Database platform
or want to learn unique features of its query engine. Both
audiences will learn to apply the full power of Oracle's own SQL
dialect to commonly encountered types of business questions and
query challenges.
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!
|
You might also like..
|
Email address subscribed successfully.
A activation email has been sent to you.
Please click the link in that email to activate your subscription.
Welcome to Loot.co.za!
Sign in / Register |Wishlists & Gift Vouchers |Help | Advanced search
