Pro Oracle SQL development : best practices for writing advanced queries / Jon Heller.
Heller, Jon, author.
2019
QA76.9.D3 H45 2019
Available Online

Linked e-resources

Linked Resource
Online Access
Concurrent users
Unlimited
Authorized users
Authorized users
Document Delivery Supplied
Can lend chapters, not whole ebooks

Details

Title
Pro Oracle SQL development : best practices for writing advanced queries / Jon Heller.
Author
Heller, Jon, author.
ISBN
9781484245170
1484245172
1484245164
9781484245163
DOI
https://doi.org/10.1007/978-1-4842-4
Published
[New York, New York] : Apress, [2019]
Language
English
Description
1 online resource (611 pages)
Item Number
10.1007/978-1-4842-4
Call Number
QA76.9.D3 H45 2019
Dewey Decimal Classification
005.75/65
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.
Note
Includes index.
Access Note
Access limited to authorized users.
Available in Other Form
Pro Oracle SQL Development : Best Practices for Writing Advanced Queries
Linked Resources
Online Access
Record Appears in
Online Resources > Ebooks
All Resources
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.

Browse Subjects

Show more subjects...

Statistics

from
to
Export