The item you selected is unavailable, but we found something similar.

Pro Oracle SQL Development: Best Practices for Writing Advanced Queries - Picture 1 of 1

Pro Oracle SQL Development : Best Practices for Writing Advanced Queries by Jon Heller (2019, Trade Paperback)

Be the first towrite a review.

ThriftBooks (3564797)
99% positive feedback

Price:

$30.42

Free shipping

Estimated delivery Thu, May 2 - Mon, May 6

Returns:

30 days returns. Seller pays for return shipping.

Condition:

Good

Pro Oracle SQL Development: Best Practices for Writing Advanced Queries by Heller, Jon Former library book; Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less

About this product

Product Information

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 performance and wrong results. Relevant theories, real-world best practices, and style guidelines help you get the most out of Oracle SQL. 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. What You'll Learn Understand the power of Oracle SQL and where to apply it Create a database development environment that is simple, scalable, and conducive to learning Solve complex problems that were previously solved in a procedural language Write large Oracle SQL statements that are powerful, simple, and fast Apply coding styles to make your SQL statements more readable Tune large Oracle SQL statements to eliminate and avoid performance problems Who This Book Is For Developers, testers, analysts, and administrators who want to harness the full power of Oracle SQL to solve their problems as simply and as quickly as possible. For traditional database professionals the book offers new ways of thinking about the language they have used for so long. For modern full stack developers the book explains how a database can be much more than simply a place to store data.

Product Identifiers

Publisher
Apress L. P.
ISBN-10
1484245164
ISBN-13
9781484245163
eBay Product ID (ePID)
23038394043

Product Key Features

Author
Jon Heller
Publication Name
Pro Oracle Sql Development : Best Practices for Writing Advanced Queries
Format
Trade Paperback
Language
English
Publication Year
2019
Type
Textbook
Number of Pages
Xxxv, 596 Pages

Dimensions

Item Length
10in
Item Width
7in
Item Weight
41.8 Oz

Additional Product Features

Number of Volumes
1 Vol.
Lc Classification Number
Qa76.9.D3
Table of Content
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
Copyright Date
2019
Topic
Desktop Applications / Databases, Programming Languages / Sql, Databases / General
Dewey Decimal
005.74
Dewey Edition
23
Illustrated
Yes
Genre
Computers

Best Selling in Textbooks

See all

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Best Selling in Textbooks

Desk Reference to the Diagnostic Criteria from DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)
5.0 out of 5 stars based on 6 product ratings
$12.19 New
---- Used
Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)
4.6 out of 5 stars based on 15 product ratings
$35.06 New
$34.00 Used
Self Heal by Design : The Role of Micro-organisms for Health by Barbara O'Neill (2018, Trade Paperback)
5.0 out of 5 stars based on 14 product ratings
$33.00 New
$32.00 Used
Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck (2020, Hardcover)
5.0 out of 5 stars based on 4 product ratings
$18.95 New
$17.66 Used
PMBOK® Guide Ser.: Guide to the Project Management Body of Knowledge (PMBOK Guide) and the Standard for Project Management by Project Management Institute (2021, Trade Paperback)
4.9 out of 5 stars based on 7 product ratings
$17.42 New
$13.00 Used
NFPA 70® Handbook with Tabs : 2023 Edition by National Fire Protection Association (NFPA) (2022, Hardcover)
No ratings or reviews yet
$59.50 New
---- Used
Research Design : Qualitative, Quantitative, and Mixed Methods Approaches by J. David Creswell and John W. Creswell (2022, Trade Paperback)
4.0 out of 5 stars based on 4 product ratings
$19.00 New
$5.27 Used

Save on Textbooks

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Save on Textbooks

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR Brand new
$32.00
Trending at $41.99
PMBOK A Guide to the Project Management Body of Knowledge 7th Ed NEW READ No Cov
$17.42
Trending at $21.99
Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck(2020)
$18.95
Trending at $19.89
NEW NFPA 70® NEC Handbook with Index Tabs : 2023 Edition by NFPA USA
$59.50
Trending at $67.45
Designing Data-Intensive Applications : The Big Ideas Behind Reliable Brand New
$15.00
Trending at $18.95
Diagnostic & Statistical Manual of Mental Disorders: DSM-5-TR(Hardcover) Fast...
$41.45
Trending at $43.95

Shop by category

Pro Oracle SQL Development : Best Practices for Writing Advanced Queries by Jon Heller (2019, Trade Paperback)

About this product

Product Information

Product Identifiers

Product Key Features

Dimensions

Additional Product Features

Best Selling in Textbooks

Desk Reference to the Diagnostic Criteria from DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)

Self Heal by Design : The Role of Micro-organisms for Health by Barbara O'Neill (2018, Trade Paperback)

Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck (2020, Hardcover)

PMBOK® Guide Ser.: Guide to the Project Management Body of Knowledge (PMBOK Guide) and the Standard for Project Management by Project Management Institute (2021, Trade Paperback)

NFPA 70® Handbook with Tabs : 2023 Edition by National Fire Protection Association (NFPA) (2022, Hardcover)

Research Design : Qualitative, Quantitative, and Mixed Methods Approaches by J. David Creswell and John W. Creswell (2022, Trade Paperback)

Save on Textbooks

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR Brand new

PMBOK A Guide to the Project Management Body of Knowledge 7th Ed NEW READ No Cov

Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck(2020)

NEW NFPA 70® NEC Handbook with Index Tabs : 2023 Edition by NFPA USA

Designing Data-Intensive Applications : The Big Ideas Behind Reliable Brand New

Diagnostic & Statistical Manual of Mental Disorders: DSM-5-TR(Hardcover) Fast...

You may also like

Joseph Heller Paperbacks Books

Joseph Heller Nonfiction Paperbacks Books

Joseph Heller Fiction Paperbacks Books

Nonfiction Writing Paperbacks Books

Joseph Heller Paperbacks Books in English

Revision/Practice Study Paperbacks Prep