책 이미지
eBook 미리보기
책 정보
· 제목 : Practical Oracle SQL: Mastering the Full Power of Oracle Database (Paperback)
· 분류 : 외국도서 > 컴퓨터 > 데이터베이스 관리 > 일반
· ISBN : 9781484256169
· 쪽수 : 460쪽
· 출판일 : 2020-02-20
· 분류 : 외국도서 > 컴퓨터 > 데이터베이스 관리 > 일반
· ISBN : 9781484256169
· 쪽수 : 460쪽
· 출판일 : 2020-02-20
목차
Introduction
Part I. Core SQL
1. Pitfalls of Set Operations2. Subquery Factoring and the WITH Clause
3. Tree Calculations with Recursion
4. Functions Defined within SQL
5. Iterative Calculations with Multidimensional Data
6. Unpivoting Columns to Rows
7. Pivoting Rows to Columns
8. Splitting Delimited Text
9. Creating Delimited Text
Part II. Analytic Functions
10. PARTITION BY, ORDER BY, and Windowing
11. Answering Top-N Questions
12. Ordered Subsets with Rolling Sums
13. Analyzing Activity Logs with Lead
14. Forecasting with Linear Regression
15. Rolling Sums to Forecast Reaching Minimums
Part III. Row Pattern Matching
16. Up and Down Patterns
17. Grouping Data Through Patterns
18. Merging Date Ranges
19. Finding Abnormal Peaks
20. Bin Fitting
21. Counting Children in Trees
Epilogue. A Final Pep-Talk
