Practical Oracle Sql Mastering The Full Power Of Oracle Database

Kim Berg Hansen

Practical Oracle Sql Mastering The Full Power Of Oracle Database
Part I. Core SQL
1. Correlating Inline Views2. Pitfalls of Set Operations3. Divide and Conquer with Subquery Factoring4. Tree Calculations with Recursion5. Functions Defined Within SQL6. Iterative Calculations with Multidimensional Data7. Unpivoting Columns to Rows8. Pivoting Rows to Columns9. Splitting Delimited Text10. Creating Delimited Text
Part II. Analytic Functions11. Analytic Partitions, Ordering and Windows12. Answering Top-N Questions13. Ordered...

Practical Oracle Sql Mastering The Full Power Of Oracle...

Practical Oracle Sql Mastering The Full Power Of Oracle Database

Part I. Core SQL

1. Correlating Inline Views

2. Pitfalls of Set Operations

3. Divide and Conquer with Subquery Factoring

4. Tree Calculations with Recursion

5. Functions Defined Within SQL

6. Iterative Calculations with Multidimensional Data

7. Unpivoting Columns to Rows

8. Pivoting Rows to Columns

9. Splitting Delimited Text

10. Creating Delimited Text

Part II. Analytic Functions

11. Analytic Partitions, Ordering and Windows

12. Answering Top-N Questions

13. Ordered Subsets with Rolling Sums

14. Analyzing Activity Logs with Lead

15. Forecasting with Linear Regression

16. Rolling Sums to Forecast Reaching Minimums

Part III. Row Pattern Matching

17. Up and Down Patterns

18. Grouping Data Through Patterns

19. Merging Date Ranges

20. Finding Abnormal Peaks

21. Bin Fitting

22. Counting Children in Trees

Nº de Páginas:
Encadernação: Capa Mole / Paperback
Tema: Databases

Practical Oracle Sql Mastering The Full Power Of Oracle Database

Sê o primeiro a dar
a tua opinião sobre este produto

Editora: Apress

Idiomas: Inglês

Data de lançamento: 20/02/2020

Peso: 0,0

Série/Edição Limitada: 1st ed.

EAN: 9781484256169

Practical Oracle Sql Mastering The Full Power Of Oracle Database

Kim Berg Hansen

Resumo

Avaliações dos nossos clientes

Características