Pro Oracle SQL Development Best Practices for Writing Advanced Queries /

Pro Oracle SQL Development Best Practices for Writing Advanced Queries /

Write SQL statements that are more powerful, simpler, and faster using Oracle SQL and its full range of features. This book provides a clearer way of thinking about SQL by building sets, and provides practical advice for using complex features while avoiding anti-patterns that lead to poor performan...

Full description

Bibliographic Details
Main Author: Heller, Jon (Author, http://id.loc.gov/vocabulary/relators/aut)
Corporate Author: SpringerLink (Online service)
Format: Electronic eBook
Language:English
Published: Berkeley, CA : Apress : Imprint: Apress, 2019.
Edition:1st ed. 2019.
Subjects:
Database management.
Database Management.
Online Access:Full Text via HEAL-Link
Table of Contents:
  • 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 Oracle 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.

Similar Items