Pro Oracle SQL Development : Best Practices for Writing Advanced Queries

Pro Oracle SQL Development Best Practices for Writing Advanced Queries

Mostrar otras versiones (1)

Write SQL statements that are more powerful, simpler, and faster using the advanced features of Oracle SQL. This updated second edition includes the newest advanced features: improved data structures (such as more JSON support and more table options), improved automated processes (such as automatic...

Descripción completa

Detalles Bibliográficos
Otros Autores: Heller, Jon, author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2023.
Edición:2nd ed. 2023.
Materias:
Oracle (Computer file)
Database management > Computer programs.
SQL/ORACLE (Computer program language)
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009711810206719
Tabla de Contenidos:
  • Part I: Learn How to Learn
  • Chapter 1: Understand Relational Databases
  • Chapter 2: Create an Efficient Database Development Process
  • Chapter 3: Increase Confidence and Knowledge with Testing
  • Chapter 4: Find Reliable Sources
  • Chapter 5: Master the Entire Stack
  • Part II: Write Powerful SQL with Sets and Advanced Features
  • Chapter 6: Build Sets with Inline Views and ANSI Join Syntax
  • Chapter 7: Query the Database with Advanced SELECT Features
  • Chapter 8: Modify Data with Advanced DML
  • Chapter 9: Improve the Database with Advanced Schema Objects
  • Chapter 10: Optimize the Database with Oracle Architecture
  • Part III: Write Elegant SQL with Patterns and Styles
  • Chapter 11: Stop Coding and Start Writing
  • Chapter 12: Write Large SQL Statements
  • Chapter 13: Write Beautiful SQL Statements
  • Chapter 14: Use SQL More Often with Basic Dynamic SQL
  • Chapter 15: Avoid Anti-Patterns
  • Part IV: Improve SQL Performance
  • Chapter 16: Understand SQL Performance with Algorithm Analysis
  • Chapter 17: Understand SQL Tuning Theories
  • Chapter 18: Improve SQL Performance
  • Part V: Solve Anything with Oracle SQL
  • Chapter 19: Solve Challenging Problems with Arcane SQL Features
  • Chapter 20: Use SQL More Often with Advanced Dynamic SQL
  • Chapter 21: Level Up Your Skills with PL/SQL
  • Part VI: Appendixes
  • Appendix A: SQL Style Guide Cheat Sheet
  • Appendix B: Computer Science Topics.

Ejemplares similares