Overview

Full Product Details

Author:   Jon Heller
Publisher:   APress
Imprint:   APress
Edition:   2nd ed.
Weight:   1.237kg
ISBN:  

9781484288665

ISBN 10:   1484288661
Pages:   632
Publication Date:   27 December 2022
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand  
We will order this item for you from a manufactured on demand supplier.

Table of Contents

Part I: Learn How to LearnChapter 1: Understand Relational DatabasesChapter 2: Create an Efficient Database Development ProcessChapter 3: Increase Confidence and Knowledge with TestingChapter 4: Find Reliable SourcesChapter 5: Master the Entire Stack Part II: Write Powerful SQL with Sets and Advanced FeaturesChapter 6: Build Sets with Inline Views and ANSI Join SyntaxChapter 7: Query the Database with Advanced SELECT FeaturesChapter 8: Modify Data with Advanced DML Chapter 9: Improve the Database with Advanced Schema ObjectsChapter 10: Optimize the Database with Oracle Architecture Part III: Write Elegant SQL with Patterns and StylesChapter 11: Stop Coding and Start WritingChapter 12: Write Large SQL StatementsChapter 13: Write Beautiful SQL StatementsChapter 14: Use SQL More Often with Basic Dynamic SQLChapter 15: Avoid Anti-Patterns Part IV: Improve SQL PerformanceChapter 16: Understand SQL Performance with Algorithm AnalysisChapter 17: Understand SQL Tuning TheoriesChapter 18: Improve SQL Performance Part V: Solve Anything with Oracle SQLChapter 19: Solve Challenging Problems with Arcane SQL FeaturesChapter 20: Use SQL More Often with Advanced Dynamic SQLChapter 21: Level Up Your Skills with PL/SQL Part VI: AppendixesAppendix A: SQL Style Guide Cheat SheetAppendix B: Computer Science Topics

Reviews

Author Information

Jon Heller is an expert SQL and PL/SQL programmer with 20 years of Oracle experience. He has worked as a database developer, analyst, and administrator. In his spare time, he is active on Stack Overflow where he is a top user in the Oracle and PL/SQL tags. He enjoys creating open-source software. He has a Master of Computer Science degree from North Carolina State University, and lives in Iowa with his wife and two sons.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions