Authors:
Reveals the powerful features available in Oracle SQL
Shows you how to write readable SQL
Combines relevant theories, real-world best practices, and an idealistic style
Buy it now
Buying options
Tax calculation will be finalised at checkout
Other ways to access
This is a preview of subscription content, access via your institution.
Table of contents (23 chapters)
-
Front Matter
-
Write Powerful SQL with Sets and Advanced Features
-
Front Matter
-
-
Write Elegant SQL with Patterns and Styles
-
Front Matter
-
-
Improve SQL Performance
-
Front Matter
-
About this book
Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. This book provides a clearer way of thinking about SQL by building sets, and it 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.
Many developers, testers, analysts, and administrators use Oracle databases frequently, but their queries are limited because they do not take advantage of Oracle’s advanced features. This book inspires you to achieve more with your Oracle SQL statements by 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 it covers enough advanced topics to put you on the path to becoming an Oracle expert.
What You'll Learn
- Solve challenging problems with declarative SQL instead of procedural languages
- Write SQL statements that are large and powerful, but also elegant and fast
- Create development environments that are simple, scalable, and conducive to learning
- Visualize and understand SQL more intuitively
- Apply advanced syntax, objects, and architecture
- Avoid SQL anti-patterns that accumulate technical debt
- Tune SQL statements with multiple strategies that can significantly improve performance
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; traditional database professionals looking for new ways of thinking about the language they have used for so long; and modern full stack developers who need an explanation of how a database can be much more than simply a place to store data
Keywords
- SQL Design Patterns
- SQL Antipatterns
- Relational Theory
- Oracle SQL Developer
- SQL*Plus
- JSON and XML
- Oracle Architecture
- Large SQL
- Dynamic SQL
- SQL Performance
- Optimizing SQL
- SQL Tuning
- Oracle Tuning
- Oracle Performance
- Database Performance
- Execution Plans
- JSON
- Automatic Indexing
- Polymorphic Table Functions
Authors and Affiliations
-
Clive, USA
Jon Heller
About the author
Bibliographic Information
Book Title: Pro Oracle SQL Development
Book Subtitle: Best Practices for Writing Advanced Queries
Authors: Jon Heller
DOI: https://doi.org/10.1007/978-1-4842-8867-2
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books
Copyright Information: Jon Heller 2023
Softcover ISBN: 978-1-4842-8866-5Published: 27 December 2022
eBook ISBN: 978-1-4842-8867-2Published: 26 December 2022
Edition Number: 2
Number of Pages: XXVI, 632
Number of Illustrations: 54 b/w illustrations
Topics: Database Management