Practical Oracle SQL mastering the full power of Oracle database
"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 Oracles own extensions to the language have progressed far over the decades in terms of how much you can...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
New York
Apress
[2020]
|
| Schlagworte: | |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Inhaltsangabe:
- Introduction
- Part 1: Core SQL
- Correlating inline views
- Pitfalls of set operations
- Divide and conquer with subquery factoring
- Tree calculations with recursion
- Functions defined within SQL
- Iterative calculations with multidimensional data
- Unpivoting columns to rows
- Pivoting rows to columns
- Splitting delimited text
- Creating delimited text
- Part 2: Analytic functions
- Analytic partitions, ordering, and Windows
- Answering Top-N questions
- Ordered subsets with rolling sums
- Analyzing activity logs with lead
- Forecasting with linear regression
- Rolling sums to forecast reaching minimums
- Part 3: Row pattern matching
- Grouping data through patterns
- Merging date ranges
- Finding abnormal peaks
- Bin fitting
- Counting children in trees