Pro Oracle SQL development best practices for writing advanced queries /
Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. Many developers, analysts, testers, and administrators use Oracle databases frequently, but their queries are limited because they do not have the knowledge, experience, or righ...
| Main Author: | Heller, Jon, |
|---|---|
| Other Authors: | SpringerLink (Online service) |
| Format: | eBook |
| Language: | English |
| Published: |
[New York, New York] :
Apress,
[2019]
|
| Physical Description: |
1 online resource (611 pages) |
| Subjects: |
| Summary: |
Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. Many developers, analysts, testers, and administrators use Oracle databases frequently, but their queries are limited because they do not have the knowledge, experience, or right environment to help them take full advantage of Oracle's advanced features. This book will inspire you to achieve more with your Oracle SQL statements through tips for 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 covers advanced topics and shows you how to become an Oracle expert. |
|---|---|
| Item Description: |
Includes index. Part I. Learn How to Learn : -- 1. Understand Relational Databases -- 2. Create an Efficient Database Development Process -- 3. Increase Confidence and Knowledge with Testing -- 4. Find Reliable Sources -- 5. Master the Entire Stack -- Part II. Write Powerful SQL with Sets and Advanced Features : -- 6. Build Sets with Inline Views and ANSI Join Syntax -- 7. Query the Database with Advanced SELECT Features -- 8. Modify Data with Advanced DML -- 9. Improve the Database with Advanced Oracle Schema Objects -- 10. Optimize the Database with Oracle Architecture -- Part III. Write Elegant SQL with Patterns and Styles : -- 11. Stop Coding and Start Writing -- 12. Write Large SQL Statements -- 13. Write Beautiful SQL Statements -- 14. Use SQL More Often with Basic Dynamic SQL -- 15. Avoid Anti-Patterns -- Part IV. Improve SQL Performance : -- 16. Understand SQL Performance with Algorithm Analysis -- 17. Understand SQL Tuning Theories -- 18. Improve SQL Performance -- Part V. Solve Anything with Oracle SQL : -- 19. Solve Challenging Problems with Arcane SQL Features -- 20. Use SQL More Often with Advanced Dynamic SQL -- 21. Level Up Your Skills with PL/SQL -- Part VI. Appendices : -- Appendix A. SQL Style Guide Cheat Sheet -- Appendix B. Computer Science Topics. Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. Many developers, analysts, testers, and administrators use Oracle databases frequently, but their queries are limited because they do not have the knowledge, experience, or right environment to help them take full advantage of Oracle's advanced features. This book will inspire you to achieve more with your Oracle SQL statements through tips for 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 covers advanced topics and shows you how to become an Oracle expert. |
| Physical Description: |
1 online resource (611 pages) |
| ISBN: |
9781484245170 1484245172 9781484245187 1484245180 |