Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

Description

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 performance and wrong results. Relevant theories, real-world best practices, and style guidelines help you get the most out of Oracle SQL. 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 right environment to help them take full advantage of Oracle’s advanced features. This book will inspire you to achieve more with your Oracle SQL statements through tips for creating your own style for writing simple, yet powerful, SQL. It teaches you how to think about and solve performance problems in Oracle SQL, and covers advanced topics and shows you how to become an Oracle expert. What You'll LearnUnderstand the power of Oracle SQL and where to apply it Create a database development environment that is simple, scalable, and conducive to learningSolve complex problems that were previously solved in a procedural language Write large Oracle SQL statements that are powerful, simple, and fast Apply coding styles to make your SQL statements more readable Tune large Oracle SQL statements to eliminate and avoid performance problems Who This Book Is For Developers, testers, analysts, and administrators who want to harness the full power of Oracle SQL to solve their problems as simply and as quickly as possible. For traditional database professionals the book offers new ways of thinking about the language they have used for so long. For modern full stack developers the book explains how a database can be much more than simply a place to store data. Front Matter ....Pages i-xxxv Front Matter ....Pages 1-1 Understand Relational Databases (Jon Heller)....Pages 3-28 Create an Efficient Database Development Process (Jon Heller)....Pages 29-50 Increase Confidence and Knowledge with Testing (Jon Heller)....Pages 51-75 Find Reliable Sources (Jon Heller)....Pages 77-85 Master the Entire Stack (Jon Heller)....Pages 87-103 Front Matter ....Pages 105-105 Build Sets with Inline Views and ANSI Join Syntax (Jon Heller)....Pages 107-126 Query the Database with Advanced SELECT Features (Jon Heller)....Pages 127-190 Modify Data with Advanced DML (Jon Heller)....Pages 191-218 Improve the Database with Advanced Oracle Schema Objects (Jon Heller)....Pages 219-263 Optimize the Database with Oracle Architecture (Jon Heller)....Pages 265-289 Front Matter ....Pages 291-291 Stop Coding and Start Writing (Jon Heller)....Pages 293-308 Write Large SQL Statements (Jon Heller)....Pages 309-325 Write Beautiful SQL Statements (Jon Heller)....Pages 327-338 Use SQL More Often with Basic Dynamic SQL (Jon Heller)....Pages 339-353 Avoid Anti-Patterns (Jon Heller)....Pages 355-378 Front Matter ....Pages 379-379 Understand SQL Performance with Algorithm Analysis (Jon Heller)....Pages 381-410 Understand SQL Tuning Theories (Jon Heller)....Pages 411-448 Improve SQL Performance (Jon Heller)....Pages 449-503 Front Matter ....Pages 505-505 Solve Challenging Problems with Arcane SQL Features (Jon Heller)....Pages 507-521 Use SQL More Often with Advanced Dynamic SQL (Jon Heller)....Pages 523-535 Level Up Your Skills with PL/SQL (Jon Heller)....Pages 537-577 Front Matter ....Pages 579-579 SQL Style Guide Cheat Sheet (Jon Heller)....Pages 581-582 Computer Science Topics (Jon Heller)....Pages 583-584 Back Matter ....Pages 585-596