Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

Heller, Jon

  • 出版商: Apress
  • 出版日期: 2019-05-10
  • 售價: $1,750
  • 貴賓價: 9.5$1,663
  • 語言: 英文
  • 頁數: 596
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1484245164
  • ISBN-13: 9781484245163
  • 相關分類: OracleSQL
  • 立即出貨 (庫存 < 3)

買這商品的人也買了...

商品描述

Write SQL statements that are more powerful, simpler, and faster using Oracle SQL and its full range of features. This book provides a clearer way of thinking about SQL by building sets, and 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.
Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. Many developers, analysts, testers, and administrators use Oracle databases frequently, but their queries are limited because they do not have the knowledge, experience, or right environment to help them take full advantage of Oracle's advanced features. This book will inspire you to achieve more with your Oracle SQL statements through tips for 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 covers advanced topics and shows you how to become an Oracle expert.

What You'll Learn

  • Understand the power of Oracle SQL and where to apply it
  • Create a database development environment that is simple, scalable, and conducive to learning
  • Solve complex problems that were previously solved in a procedural language
  • Write large Oracle SQL statements that are powerful, simple, and fast
  • Apply coding styles to make your SQL statements more readable
  • Tune large Oracle SQL statements to eliminate and avoid performance problems

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. For traditional database professionals the book offers new ways of thinking about the language they have used for so long. For modern full stack developers the book explains how a database can be much more than simply a place to store data.

商品描述(中文翻譯)

使用Oracle SQL及其完整功能範圍,撰寫更強大、更簡單、更快速的SQL語句。本書通過建立集合的方式提供了更清晰的SQL思維方式,並提供了使用複雜功能的實用建議,同時避免了導致性能不佳和錯誤結果的反模式。相關理論、實踐最佳方法和風格指南將幫助您充分利用Oracle SQL。

《Pro Oracle SQL Development》適用於已經熟悉Oracle SQL並準備提升技能的任何人。許多開發人員、分析師、測試人員和管理員經常使用Oracle數據庫,但由於缺乏知識、經驗或正確的環境,他們的查詢受到限制,無法充分利用Oracle的高級功能。本書將激發您通過創建自己的簡潔而強大的SQL寫作風格,以更多方式使用Oracle SQL語句。它教導您如何思考和解決Oracle SQL的性能問題,涵蓋高級主題並展示如何成為Oracle專家。

您將學到什麼:
- 理解Oracle SQL的威力及其應用範圍
- 創建一個簡單、可擴展且有利於學習的數據庫開發環境
- 解決以前在程序語言中解決的複雜問題
- 撰寫強大、簡單、快速的大型Oracle SQL語句
- 應用編碼風格使您的SQL語句更易讀
- 調整大型Oracle SQL語句以消除和避免性能問題

本書適合開發人員、測試人員、分析師和管理員,他們希望以最簡單、最快速的方式充分利用Oracle SQL的全部功能來解決問題。對於傳統的數據庫專業人員,本書提供了對他們長期使用的語言的新思考方式。對於現代全棧開發人員,本書解釋了數據庫可以是更多的,而不僅僅是存儲數據的地方。

作者簡介

Jon Heller is an expert SQL and PL/SQL programmer with 17 years of Oracle experience. During that time he has worked as a database analyst, developer, 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 for Oracle, such as the remote execution program Method5. He has a master of computer science degree from North Carolina State University and lives in Iowa with his wife and two sons.

作者簡介(中文翻譯)

Jon Heller 是一位擁有17年Oracle經驗的SQL和PL/SQL專家。在此期間,他曾擔任過數據庫分析師、開發人員和管理員的角色。在閒暇時間,他活躍於Stack Overflow,是Oracle和PL/SQL標籤中的頂級用戶。他喜歡為Oracle創建開源軟件,例如遠程執行程序Method5。他擁有北卡羅來納州立大學的計算機科學碩士學位,與妻子和兩個兒子居住在愛荷華州。