Pro Oracle SQL Development Best Practices for Writing Advanced Queries /

• Κύριος συγγραφέας: Heller, Jon (Συγγραφέας, http://id.loc.gov/vocabulary/relators/aut)
• Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
• Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
• Γλώσσα: English
• Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2019.
• Έκδοση: 1st ed. 2019.
• Θέματα: Database management.; Database Management.

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 performan...

Πίνακας περιεχομένων:

• 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 SQL
• Chapter 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.