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 work...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Berg Hansen, Kim (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [Berkeley, CA] : Apress, [2020]
Temas:
Oracle (Computer file)
SQL (Computer program language)
Database design.
SQL (Langage de programmation)
Bases de données > Conception.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
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