Oracle SQL Revealed Executing Business Logic in the Database Engine 1st Edition by Alex Reprintsev 1484233726 9781484233726

Oracle SQL Revealed: Executing Business Logic in the Database Engine 1st Edition by Alex Reprintsev – Ebook PDF Instant Download/DeliveryISBN:  1484233726, 9781484233726 

Full download Oracle SQL Revealed: Executing Business Logic in the Database Engine 1st Edition after payment.

Product details:

ISBN-10 :   1484233726 

ISBN-13 :  9781484233726

Author:  Alex Reprintsev 

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. 

Oracle SQL Revealed: Executing Business Logic in the Database Engine 1st Table of contents:

Part I. Features and Theory
1. Joins
2. Query Transformations
3. Analytic Functions
4. Aggregate Functions
5. Hierarchical Queries: Connect by
6. Recursive Subquery Factoring
7. Model
8. Row Pattern Matching: match_recognize
9. Logical Execution Order of Query Clauses
10. Turing Completeness
Part II. PL/SQL and SQL solutions
11. When PL/SQL Is Better Than Vanilla SQL
12. Solving SQL Quizzes

People also search for Oracle SQL Revealed: Executing Business Logic in the Database Engine 1st:

oracle business rules
    
oracle sql executed by user
    
oracle transaction business intelligence
    
logical sql reference guide for oracle business intelligence enterprise edition
    
oracle business rules engine

Tags: Oracle SQL, Executing Business, Database Engine, Alex Reprintsev