Practical Oracle SQL : Mastering the Full Power of Oracle Database

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 Oracle’s own extensions to the language have progressed far over the decades in terms of how much you can work...

Descripción completa

Detalles Bibliográficos
Autor principal: Berg Hansen, Kim. author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2020.
Edición:1st ed. 2020.
Materias:
Oracle (Computer file)
Database management.
Database Management.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630983606719
Tabla de Contenidos:
  • 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.

Ejemplares similares