Pro Oracle SQL Development

Part I: Learn How to LearnChapter 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 II: Write Powerful SQL with Sets and Advanced FeaturesChapter 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 III: Write Elegant SQL with Patterns and StylesChapter 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 IV: Improve SQL PerformanceChapter 16: Understand SQL Performance with Algorithm AnalysisChapter 17: Understand SQL Tuning TheoriesChapter 18: Improve SQL Performance

Part V: Solve Anything with Oracle SQLChapter 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 VI: AppendixesAppendix A: SQL Style Guide Cheat SheetAppendix B: Computer Science Topics