Pro Oracle SQL development : best practices for writing advanced queries /: best practices for writing advanced queries. ([2019])

• Record Type: Book
• Further Information: Note: Jon Heller.
• Authors: Heller, Jon
• 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 Oracle 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.
• Publisher Details: New York : Apress
• Publication Date: 2019
• Extent: 1 online resource, illustrations
• Subjects: 005.7565; Database management -- Computer programs; SQL (Computer program language); Relational databases; Electronic books
• Languages: English
• ISBNs: 9781484245170; 1484245172
• Related ISBNs: 9781484245163
• Notes: Note: Description based on online resource; title from digital title page (viewed on June 18, 2019).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.