Practical Oracle SQL : mastering the full power of Oracle database /: mastering the full power of Oracle database. ([2020])

• Record Type: Book
• Further Information: Note: Kim Berg Hansen.
• Authors: Berg Hansen, Kim
• Contents: Part I. Core SQL 1. Correlating Inline Views2. Pitfalls of Set Operations3. Divide and Conquer with Subquery Factoring4. Tree Calculations with Recursion5. Functions Defined Within SQL6. Iterative Calculations with Multidimensional Data7. Unpivoting Columns to Rows8. Pivoting Rows to Columns9. Splitting Delimited Text10. Creating Delimited Text Part II. Analytic Functions11. Analytic Partitions, Ordering and Windows12. Answering Top-N Questions13. Ordered Subsets with Rolling Sums14. Analyzing Activity Logs with Lead15. Forecasting with Linear Regression16. Rolling Sums to Forecast Reaching Minimums Part III. Row Pattern Matching17. Up and Down Patterns18. Grouping Data Through Patterns19. Merging Date Ranges20. Finding Abnormal Peaks21. Bin Fitting22. Counting Children in Trees.
• Publisher Details: Berkeley, CA : Apress
• Publication Date: 2020
• Extent: 1 online resource
• Subjects: 005.75/65; SQL (Computer program language); Database design; Electronic books
• Languages: English
• ISBNs: 9781484256176; 1484256174
• Related ISBNs: 9781484256169; 1484256166
• Notes: Note: Description based on online resource; title from digital title page (viewed on March 16, 2020).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.