Practical Oracle SQL

• 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

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.