Synopsis
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 SQLChapter 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
"synopsis" may belong to another edition of this title.