Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

by Jon Heller

Part Learn How to Learn Chapter 1: Understand Relational DatabasesChapter 2: Create an Efficient Database Development ProcessChapter 3: Increase Confidence and Knowledge with TestingChapter 4: Find Reliable SourcesChapter 5: Master the Entire Stack
Part Write Powerful SQL with Sets and Advanced Features Chapter 6: Build Sets with Inline Views and ANSI Join SyntaxChapter 7: Query the Database with Advanced SELECT FeaturesChapter 8: Modify Data with Advanced DML Chapter 9: Improve the Database with Advanced Schema ObjectsChapter 10: Optimize the Database with Oracle Architecture
Part Write Elegant SQL with Patterns and Styles Chapter 11: Stop Coding and Start WritingChapter 12: Write Large SQL StatementsChapter 13: Write Beautiful SQL StatementsChapter 14: Use SQL More Often with Basic Dynamic SQLChapter 15: Avoid Anti-Patterns
Part Improve SQL Performance Chapter 16: Understand SQL Performance with Algorithm AnalysisChapter 17: Understand SQL Tuning TheoriesChapter 18: Improve SQL Performance
Part Solve Anything with Oracle SQL Chapter 19: Solve Challenging Problems with Arcane SQL FeaturesChapter 20: Use SQL More Often with Advanced Dynamic SQLChapter 21: Level Up Your Skills with PL/SQL
Part Appendixes Appendix SQL Style Guide Cheat SheetAppendix Computer Science Topics

660 pages, Paperback

Published January 27, 2023

Reviews

[Mike · Rating 4 out of 5]

When you take out the bits that are basically "my unpopular opinions, let me tell you them," and the bits I already knew because I've had to learn them to solve a problem, and the bits I'll never use... there are still some useful bits left. Worthwhile, if you already have a good background in Oracle SQL, but you will probably find yourself skimming as I did.

Not suitable for absolute beginners, since some things are simply not explained on the assumption that you already understand them.