Book description
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.- 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
- 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
Table of contents
- Cover
- Front Matter
-
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
- Part III. Row Pattern Matching
- Back Matter
Product information
- Title: Practical Oracle SQL: Mastering the Full Power of Oracle Database
- Author(s):
- Release date: February 2020
- Publisher(s): Apress
- ISBN: 9781484256176
You might also like
book
Data Analysis with Microsoft Power BI
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
Learning SQL, 3rd Edition
As data floods into your company, you need to put it to work right away—and SQL …
book
How Linux Works, 3rd Edition
Unlike some operating systems, Linux doesn’t try to hide the important bits from you—it gives you …
book
Analytical Skills for AI and Data Science
While several market-leading companies have successfully transformed their business models by following data- and AI-driven paths, …