東華大學圖書館 |

Language: English

Help

回圖書館首頁

手機版館藏查詢

Back

Switch To: Labeled | MARC Mode | ISBD

Practical Oracle SQL = mastering the...

Berg Hansen, Kim.

Linked to FindBook

Google Book

Amazon

博客來

Practical Oracle SQL = mastering the full power of Oracle database /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Practical Oracle SQL/ by 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.
[NT 15003449]:	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.
Contained By:	Springer eBooks
Subject:	SQL (Computer program language) -
Online resource:	https://doi.org/10.1007/978-1-4842-5617-6
ISBN:	9781484256176

Practical Oracle SQL = mastering 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

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

Oracle (Computer file)
Subjects--Topical Terms:

606987
SQL (Computer program language)

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

Dewey Class. No.: 005.7565

Practical Oracle SQL = mastering the full power of Oracle database /
LDR:01902nmm a2200325 a 4500 001 2216635
003 DE-He213
005 20200219143856.0
006 m d
007 cr nn 008maaau
008 201120s2020 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 3449095
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 539566
650 0 $a SQL (Computer program language) $3 606987
650 0 $a Database design. $3 559853
650 1 4 $a Database Management. $3 891010
710 2 $a SpringerLink (Online service) $3 836513
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)