Jon Heller: Pro Oracle SQL Development

Cover: 9781484288665 | Pro Oracle SQL Development | Jon Heller | Taschenbuch | xxvi | 2022

Rückseite: 9781484288665 | Pro Oracle SQL Development | Jon Heller | Taschenbuch | xxvi | 2022

Dekorationsartikel gehören nicht zum Leistungsumfang.

Sprache: Englisch

58,35 €

inkl. MwSt.

Versandkostenfrei per Post / DHL

Lieferzeit 2-4 Werktage

Kategorien:

Beschreibung

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 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.

Über den Autor

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.

Zusammenfassung

Reveals the powerful features available in Oracle SQL

Shows you how to write readable SQL

Combines relevant theories, real-world best practices, and an idealistic style

Inhaltsverzeichnis

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 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.

Details

Erscheinungsjahr:	2022
Genre:	Importe , Informatik
Rubrik:	Naturwissenschaften & Technik
Medium:	Taschenbuch
Inhalt:	xxvi 632 S. 54 s/w Illustr. 632 p. 54 illus.
ISBN-13:	9781484288665
ISBN-10:	1484288661
Sprache:	Englisch
Einband:	Kartoniert / Broschiert
Autor:	Heller, Jon
Auflage:	Second Edition
Hersteller:	Apress Apress L.P.
Verantwortliche Person für die EU:	APress in Springer Science + Business Media, Heidelberger Platz 3, D-14197 Berlin, juergen.hartmann@springer.com
Maße:	254 x 178 x 36 mm
Von/Mit:	Jon Heller
Erscheinungsdatum:	27.12.2022
Gewicht:	1,221 kg