Pro Oracle SQL development : best practices for writing advanced queries /

Mostrar otras versiones (1)

Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. Many developers, analysts, testers, and administrators use Oracle databases frequently, but their queries are limited because they do not have the knowledge, experience, or righ...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Heller, Jon (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [New York, New York] : Apress, [2019]
Temas:
Oracle (Computer file)
Database management > Computer programs.
SQL/ORACLE (Computer program language)
Bases de données > Gestion > Logiciels.
SQL/ORACLE (Langage de programmation)
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Part I. Learn How to Learn :
  • 1. Understand Relational Databases
  • 2. Create an Efficient Database Development Process
  • 3. Increase Confidence and Knowledge with Testing
  • 4. Find Reliable Sources
  • 5. Master the Entire Stack
  • Part II. Write Powerful SQL with Sets and Advanced Features :
  • 6. Build Sets with Inline Views and ANSI Join Syntax
  • 7. Query the Database with Advanced SELECT Features
  • 8. Modify Data with Advanced DML
  • 9. Improve the Database with Advanced Oracle Schema Objects
  • 10. Optimize the Database with Oracle Architecture
  • Part III. Write Elegant SQL with Patterns and Styles :
  • 11. Stop Coding and Start Writing
  • 12. Write Large SQL Statements
  • 13. Write Beautiful SQL Statements
  • 14. Use SQL More Often with Basic Dynamic SQL
  • 15. Avoid Anti-Patterns
  • Part IV. Improve SQL Performance :
  • 16. Understand SQL Performance with Algorithm Analysis
  • 17. Understand SQL Tuning Theories
  • 18. Improve SQL Performance
  • Part V. Solve Anything with Oracle SQL :
  • 19. Solve Challenging Problems with Arcane SQL Features
  • 20. Use SQL More Often with Advanced Dynamic SQL
  • 21. Level Up Your Skills with PL/SQL
  • Part VI. Appendices :
  • Appendix A. SQL Style Guide Cheat Sheet
  • Appendix B. Computer Science Topics.

Ejemplares similares