Practical oracle sql : (Record no. 222494)

MARC details
000 -LEADER
fixed length control field 04367nam a22005295i 4500
001 - CONTROL NUMBER
control field ssj0002288960
003 - CONTROL NUMBER IDENTIFIER
control field WaSeSS
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20250123113248.0
006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS
fixed length control field m d
007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION
fixed length control field cr n
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 200219s2020 xxu| o |||| 0|eng d
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9781484256169
024 7# - OTHER STANDARD IDENTIFIER
Source of number or code doi
040 ## - CATALOGING SOURCE
Modifying agency WaSeSS
Transcribing agency AIMIT LIBRARY
050 #4 - LIBRARY OF CONGRESS CALL NUMBER
Classification number QA76.9.D3
072 #7 - SUBJECT CATEGORY CODE
Subject category code UN
Source bicssc
072 #7 - SUBJECT CATEGORY CODE
Subject category code COM021000
Source bisacsh
072 #7 - SUBJECT CATEGORY CODE
Subject category code UN
Source thema
072 #7 - SUBJECT CATEGORY CODE
Subject category code UMT
Source thema
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 005.7401
Edition number 1
Item number HANK
092 ## - LOCALLY ASSIGNED DEWEY CALL NUMBER (OCLC)
Classification number EBOOK
999 ## - SYSTEM CONTROL NUMBERS (KOHA)
Koha Dewey Subclass [OBSOLETE] 03658644
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Hansen, Kim Berg.
9 (RLIN) 30484
245 10 - TITLE STATEMENT
Title Practical oracle sql :
Remainder of title mastering the full power of oracle database /
Statement of responsibility, etc. By Kim Berg Hansen.
250 ## - EDITION STATEMENT
Edition statement 1st ed.
260 ## - PUBLICATION, DISTRIBUTION, ETC.
Place of publication, distribution, etc. New York :
Name of publisher, distributor, etc. Apress ,
Date of publication, distribution, etc. 2022
300 ## - PHYSICAL DESCRIPTION
Extent xxiii, 460p. ;
Dimensions PB
Other physical details 25 cm.
347 ## - DIGITAL FILE CHARACTERISTICS
File type text file
Encoding format PDF
Source rda
505 0# - FORMATTED CONTENTS NOTE
Formatted contents note 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.
506 ## - RESTRICTIONS ON ACCESS NOTE
Terms governing access Requires an SPL library card.
520 ## - SUMMARY, ETC.
Summary, etc. Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92. Both standard SQL and Oracle's own extensions to the language have progressed far over the decades in terms of how much you can work with your data in a single, albeit sometimes complex, SQL statement. If you already know the basics of SQL, this book provides many examples of how to write even more advanced SQL to huge benefit in your applications, such as: Pivoting rows to columns and columns to rows Recursion in SQL with MODEL and WITH clauses Answering Top-N questions Forecasting with linear regressions Row pattern matching to group or distribute rows Using MATCH_RECOGNIZE as a row processing engine The process of starting from simpler statements in SQL, and gradually working those statements stepwise into more complex statements that deliver powerful results, is covered in each example. By trying out the recipes and examples for yourself, you will put together the building blocks into powerful SQL statements that will make your application run circles around your competitors. You will: Take full advantage of advanced and modern features in Oracle SQL Recognize when modern SQL constructs can help create better applications Improve SQL query building skills through stepwise refinement Apply set-based thinking to process more data in fewer queries Make cross-row calculations with analytic functions Search for patterns across multiple rows using row pattern matching Break complex calculations into smaller steps with subquery factoring.
538 ## - SYSTEM DETAILS NOTE
System details note Mode of access: World Wide Web.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Pitfalls of set operations
9 (RLIN) 30485
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Divide and conquer with subquery factoring
9 (RLIN) 194823
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Tree calculations with recursion
9 (RLIN) 194824
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Functions defined within sql
9 (RLIN) 194825
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Unpivoting columns to rows
9 (RLIN) 194826
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Splitting delimited text
9 (RLIN) 194827
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Analytic functions
9 (RLIN) 30486
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Row pattern matching
9 (RLIN) 30487
655 #7 - INDEX TERM--GENRE/FORM
Genre/form data or focus term Electronic books.
Source of term local
9 (RLIN) 30488
776 08 - ADDITIONAL PHYSICAL FORM ENTRY
International Standard Book Number 9781484256169
776 08 - ADDITIONAL PHYSICAL FORM ENTRY
International Standard Book Number 9781484256183
856 40 - ELECTRONIC LOCATION AND ACCESS
Link text View this electronic item in O'Reilly Online Learning: Academic/Public Library Edition.
Uniform Resource Identifier <a href="https://ezproxy.spl.org/login?url=https://learning.oreilly.com/library/view/~/9781484256176/?ar">https://ezproxy.spl.org/login?url=https://learning.oreilly.com/library/view/~/9781484256176/?ar</a>
Public note An e-book available through full-text database.
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Source of classification or shelving scheme Dewey Decimal Classification
Koha item type Book
Edition 1st
Call number prefix 005.7401 HANK
Holdings
Withdrawn status Lost status Source of classification or shelving scheme Damaged status Not for loan Collection code Home library Current library Date acquired Source of acquisition Cost, normal purchase price Inventory number Total Checkouts Full call number Barcode Date last seen Cost, replacement price Price effective from Koha item type
    Dewey Decimal Classification     MCA St Aloysius Institute of Management & Information Technology St Aloysius Institute of Management & Information Technology 03/24/2022 Biblios Book Point 1799.00 Bill no:6625; Bill dt:2022-03-23   005.7401 HANK MCA17101 07/21/2025 1439.00 04/20/2022 Book