Practical Oracle SQL: Mastering the Full Power of Oracle Database - Softcover

Berg Hansen, Kim

Softcover

ISBN 10: 1484256182 ISBN 13: 9781484256183

Publisher: Apress, 2020

This specific ISBN edition is currently not available.

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

"synopsis" may belong to another edition of this title.

(No Available Copies)

Search Books: Create a Want

Can't find the book you're looking for? We'll keep searching for you. If one of our booksellers adds it to AbeBooks, we'll let you know!

ISBN 10: 1484256166 ISBN 13: 9781484256169
Publisher: Apress, 2020
Softcover