國立高雄大學圖資館 |

Language: English

Back

Practical Oracle SQLmastering the fu...

Berg Hansen, Kim.

Practical Oracle SQLmastering the full power of Oracle database /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Practical Oracle SQLby Kim Berg Hansen.
Reminder of title:	mastering the full power of Oracle database /
Author:	Berg Hansen, Kim.
Published:	Berkeley, CA :Apress :2020.
Description:	xxiii, 460 p. :ill., digital ;24 cm.
Contained By:	Springer eBooks
Subject:	SQL (Computer program language)
Online resource:	https://doi.org/10.1007/978-1-4842-5617-6
ISBN:	9781484256176$q(electronic bk.)

Practical Oracle SQLmastering the full power of Oracle database /
Berg Hansen, Kim.

Practical Oracle SQLmastering the full power of Oracle database /[electronic resource] :by Kim Berg Hansen. - Berkeley, CA :Apress :2020. - xxiii, 460 p. :ill., digital ;24 cm.

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.

ISBN: 9781484256176$q(electronic bk.)

Standard No.: 10.1007/978-1-4842-5617-6doiSubjects--Uniform Titles:

Oracle (Computer file)
Subjects--Topical Terms:

189402
SQL (Computer program language)

LC Class. No.: QA76.73.S67 / B47 2020

Dewey Class. No.: 005.7565

Practical Oracle SQLmastering the full power of Oracle database /
LDR:01902nmm a2200325 a 4500 001 575281
003 DE-He213
005 20200219143856.0
006 m d
007 cr nn 008maaau
008 201016s2020 cau s 0 eng d
020 $a 9781484256176$q(electronic bk.)
020 $a 9781484256169$q(paper)
024 7 $a 10.1007/978-1-4842-5617-6 $2 doi
035 $a 978-1-4842-5617-6
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.73.S67 $b B47 2020
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
072 7 $a UMT $2 thema
082 0 4 $a 005.7565 $2 23
090 $a QA76.73.S67 $b B493 2020
100 1 $a Berg Hansen, Kim. $3 863156
245 1 0 $a Practical Oracle SQL $h [electronic resource] : $b mastering the full power of Oracle database / $c by Kim Berg Hansen.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2020.
300 $a xxiii, 460 p. : $b ill., digital ; $c 24 cm.
505 0 $a 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.
630 0 0 $a Oracle (Computer file) $3 200209
650 0 $a SQL (Computer program language) $3 189402
650 0 $a Database design. $3 184445
650 1 4 $a Database Management. $3 273994
710 2 $a SpringerLink (Online service) $3 273601
773 0 $t Springer eBooks
856 4 0 $u https://doi.org/10.1007/978-1-4842-5617-6
950 $a Professional and Applied Computing (Springer-12059)