Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

Heller, Jon

ISBN 10: 1484288688 / ISBN 13: 9781484288689

Edité par Apress, 2023

In. N° de réf. du vendeur ria9781484288689_new

Synopsis :

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

Détails bibliographiques

Titre : Pro Oracle SQL Development: Best Practices ...
Éditeur : Apress
Date d'édition : 2023
Reliure : Couverture souple
Etat : New