Pro Oracle SQL development : best practices for writing advanced queries /

Pro Oracle SQL development : best practices for writing advanced queries /

Saved in:

Bibliographic Details
Author / Creator:	Heller, Jon, author.
Imprint:	[New York, New York] : Apress, [2019]
Description:	1 online resource (611 pages)
Language:	English
Subject:	Oracle (Computer file) Oracle (Computer file) Database management -- Computer programs. SQL/ORACLE (Computer program language) Database management -- Computer programs. SQL/ORACLE (Computer program language)
Format:	E-Resource Book
URL for this record:	http://pi.lib.uchicago.edu/1001/cat/bib/11895485

Hidden Bibliographic Details
ISBN:	9781484245170 1484245172 9781484245187 1484245180 1484245164 9781484245163
Digital file characteristics:	text file PDF
Notes:	Includes index.
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.
Other form:	Print version: Heller, Jon. Pro Oracle SQL Development : Best Practices for Writing Advanced Queries. Berkeley, CA : Apress L.P., ©2019 9781484245163
Standard no.:	10.1007/978-1-4842-4517-0 10.1007/978-1-4842-4

Table of Contents:

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.