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
Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional
Start developing with Oracle SQL. This book is a one-stop introduction to everything you need to …
video
Oracle Databases
This course offers a solid foundation in Oracle databases, from the fundamentals of the SQL language …
book
Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
Level up your skill set to the latest that Oracle Database can offer. This book introduces …
video
Oracle SQL
Overview Oracle SQL LiveLessons covers the basics of the Oracle SQL programming language. This course covers …