Verwandte Artikel zu Pro Oracle SQL Development: Best Practices for Writing...

Pro Oracle SQL Development: Best Practices for Writing Advanced Queries - Softcover

 
9781484288665: Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

Inhaltsangabe

Write SQL statements that are more powerful, simpler, and faster using the advanced features of Oracle SQL. This updated second edition includes the newest advanced features: improved data structures (such as more JSON support and more table options), improved automated processes (such as automatic indexing), and improved SQL language extensions (such as polymorphic table functions, SQL macros, and the multilingual engine).

Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. This book provides a clearer way of thinking about SQL by building sets, and it 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.

Many developers, testers, analysts, and administrators use Oracle databases frequently, but their queries are limited because they do not take advantage of Oracle's advanced features. This book inspires you to achieve more with your Oracle SQL statements by 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 it covers enough advanced topics to put you on the path to becoming an Oracle expert.


What You'll Learn
  • Solve challenging problems with declarative SQL instead of procedural languages
  • Write SQL statements that are large and powerful, but also elegant and fast
  • Create development environments that are simple, scalable, and conducive to learning
  • Visualize and understand SQL more intuitively
  • Apply advanced syntax, objects, and architecture
  • Avoid SQL anti-patterns that accumulate technical debt
  • Tune SQL statements with multiple strategies that can significantly improve performance


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; traditional database professionals looking for new ways of thinking about the language they have used for so long; and modern full stack developers who need an explanation of how a database can be much more than simply a place to store data

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Über die Autorin bzw. 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.

Von der hinteren Coverseite

Write SQL statements that are more powerful, simpler, and faster using the advanced features of Oracle SQL. This updated second edition includes the newest advanced features: improved data structures (such as more JSON support and more table options), improved automated processes (such as automatic indexing), and improved SQL language extensions (such as polymorphic table functions, SQL macros, and the multilingual engine).

Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. This book provides a clearer way of thinking about SQL by building sets, and it 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.

Many developers, testers, analysts, and administrators use Oracle databases frequently, but their queries are limited because they do not take advantage of Oracle’s advanced features. This book inspires you to achieve more with your Oracle SQL statements by 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 it covers enough advanced topics to put you on the path to becoming an Oracle expert.

What You'll Learn
  • Solve challenging problems with declarative SQL instead of procedural languages
  • Write SQL statements that are large and powerful, but also elegant and fast
  • Create development environments that are simple, scalable, and conducive to learning
  • Visualize and understand SQL more intuitively
  • Apply advanced syntax, objects, and architecture
  • Avoid SQL anti-patterns that accumulate technical debt
  • Tune SQL statements with multiple strategies that can significantly improve performance



„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.

Gebraucht kaufen

Zustand: Befriedigend
Ship within 24hrs. Satisfaction...
Diesen Artikel anzeigen

EUR 6,83 für den Versand von USA nach Deutschland

Versandziele, Kosten & Dauer

Suchergebnisse für Pro Oracle SQL Development: Best Practices for Writing...

Internationale Ausgabe
Internationale Ausgabe

Jon Heller
Verlag: Apress, 2022
ISBN 10: 1484288661 ISBN 13: 9781484288665
Neu Softcover
Internationale Ausgabe

Anbieter: Romtrade Corp., STERLING HEIGHTS, MI, USA

Verkäuferbewertung 5 von 5 Sternen 5 Sterne, Erfahren Sie mehr über Verkäufer-Bewertungen

Zustand: New. Brand New. Soft Cover International Edition. Different ISBN and Cover Image. Priced lower than the standard editions which is usually intended to make them more affordable for students abroad. The core content of the book is generally the same as the standard edition. The country selling restrictions may be printed on the book but is no problem for the self-use. This Item maybe shipped from US or any other country as we have multiple locations worldwide. Artikel-Nr. ABNR-209602

Verkäufer kontaktieren

Neu kaufen

EUR 38,30
Währung umrechnen
Versand: Gratis
Von USA nach Deutschland
Versandziele, Kosten & Dauer

Anzahl: 2 verfügbar

In den Warenkorb

Beispielbild für diese ISBN

Heller, Jon
Verlag: Apress (edition 2nd ed.), 2022
ISBN 10: 1484288661 ISBN 13: 9781484288665
Gebraucht Paperback

Anbieter: BooksRun, Philadelphia, PA, USA

Verkäuferbewertung 5 von 5 Sternen 5 Sterne, Erfahren Sie mehr über Verkäufer-Bewertungen

Paperback. Zustand: Good. 2nd ed. Ship within 24hrs. Satisfaction 100% guaranteed. APO/FPO addresses supported. Artikel-Nr. 1484288661-11-1

Verkäufer kontaktieren

Gebraucht kaufen

EUR 36,41
Währung umrechnen
Versand: EUR 6,83
Von USA nach Deutschland
Versandziele, Kosten & Dauer

Anzahl: 1 verfügbar

In den Warenkorb

Foto des Verkäufers

Jon Heller
Verlag: Apress, Apress Dez 2022, 2022
ISBN 10: 1484288661 ISBN 13: 9781484288665
Neu Taschenbuch

Anbieter: buchversandmimpf2000, Emtmannsberg, BAYE, Deutschland

Verkäuferbewertung 5 von 5 Sternen 5 Sterne, Erfahren Sie mehr über Verkäufer-Bewertungen

Taschenbuch. Zustand: Neu. Neuware -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; traditional database professionals looking for new ways of thinking about the language they have used for so long; and modern full stack developers who need an explanation of how a database can be much more than simply a place to store dataAPress in Springer Science + Business Media, Heidelberger Platz 3, 14197 Berlin 660 pp. Englisch. Artikel-Nr. 9781484288665

Verkäufer kontaktieren

Neu kaufen

EUR 69,54
Währung umrechnen
Versand: Gratis
Innerhalb Deutschlands
Versandziele, Kosten & Dauer

Anzahl: 2 verfügbar

In den Warenkorb

Beispielbild für diese ISBN

Heller, Jon
Verlag: Apress, 2022
ISBN 10: 1484288661 ISBN 13: 9781484288665
Neu Softcover

Anbieter: Ria Christie Collections, Uxbridge, Vereinigtes Königreich

Verkäuferbewertung 5 von 5 Sternen 5 Sterne, Erfahren Sie mehr über Verkäufer-Bewertungen

Zustand: New. In. Artikel-Nr. ria9781484288665_new

Verkäufer kontaktieren

Neu kaufen

EUR 64,49
Währung umrechnen
Versand: EUR 5,77
Von Vereinigtes Königreich nach Deutschland
Versandziele, Kosten & Dauer

Anzahl: Mehr als 20 verfügbar

In den Warenkorb

Beispielbild für diese ISBN

Heller, Jon
Verlag: Apress, 2022
ISBN 10: 1484288661 ISBN 13: 9781484288665
Neu Paperback

Anbieter: Revaluation Books, Exeter, Vereinigtes Königreich

Verkäuferbewertung 5 von 5 Sternen 5 Sterne, Erfahren Sie mehr über Verkäufer-Bewertungen

Paperback. Zustand: Brand New. 2nd edition. 658 pages. 10.00x7.01x1.57 inches. In Stock. Artikel-Nr. x-1484288661

Verkäufer kontaktieren

Neu kaufen

EUR 74,93
Währung umrechnen
Versand: EUR 11,58
Von Vereinigtes Königreich nach Deutschland
Versandziele, Kosten & Dauer

Anzahl: 2 verfügbar

In den Warenkorb