Books [Alex Reprintsev] Oracle SQL Revealed

[tttx]

​

DESCRIPTION:

Tagline: Learn about analytic functions, the model clause, row pattern matching, and other powerful features in Oracle SQL

Table of Contents:

• Part I: Features and Theory
• Chapter 1: Joins
• Chapter 2: Query Transformations
• Chapter 3: Analytic Functions
• Chapter 4: Aggregate Functions
• Chapter 5: Hierarchical Queries: Connect by
• Chapter 6: Recursive Subquery Factoring
• Chapter 7: Model
• Chapter 8: Row Pattern Matching: match_recognize
• Chapter 9: Logical Execution Order of Query Clauses
• Chapter 10: Turing Completeness

Part II: PL/SQL and SQL solutions:

• Chapter 11: When PL/SQL Is Better Than Vanilla SQL
• Chapter 12: Solving SQL Quizzes

Appendix A: Useful Oracle Links

DOWNLOAD:

Авторизуйтесь, чтобы посмотреть скрытый контент