Practical Oracle SQL: Mastering the Full Power of Oracle Database
暫譯: 實用 Oracle SQL：掌握 Oracle 數據庫的全部功能
Berg Hansen, Kim
買這商品的人也買了...
-
JavaScript 大全, 6/e (JavaScript: The Definitive Guide: Activate Your Web Pages, 6/e)$1,200$948 -
$2,575Chaos Engineering: System Resiliency in Practice (Paperback) -
JavaScript 無所不在 (JavaScript Everywhere: Building Cross-Platform Applications with Graphql, React, React Native, and Electron)$580$458 -
使用 Python 取代 Excel VBA 的 10堂課$520$411 -
簡報美學｜簡報x設計x呈現$520$411 -
【圖解】從入門到精通 Excel ╳ Python 資料處理術：搭配工作實務場景，輕鬆學會除錯、擷取、排序、彙整指定數據，製作QR碼也沒問題$500$395 -
動手就能上手 - 看 Excel VBA 學 Python 資料處理自動化$880$695 -
PHP 錦囊妙計 (PHP Cookbook: Modern Code Solutions for Professional Developers)$880$695 -
機器學習 : 最強入門邁向 AI 高手 王者歸來$1,080$853
相關主題
商品描述
Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92.
Both standard SQL and Oracle's own extensions to the language have progressed far over the decades in terms of how much you can work with your data in a single, albeit sometimes complex, SQL statement. If you already know the basics of SQL, this book provides many examples of how to write even more advanced SQL to huge benefit in your applications, such as:
- Pivoting rows to columns and columns to rows
- Recursion in SQL with MODEL and WITH clauses
- Answering Top-N questions
- Forecasting with linear regressions
- Row pattern matching to group or distribute rows
- Using MATCH_RECOGNIZE as a row processing engine
The process of starting from simpler statements in SQL, and gradually working those statements stepwise into more complex statements that deliver powerful results, is covered in each example. By trying out the recipes and examples for yourself, you will put together the building blocks into powerful SQL statements that will make your application run circles around your competitors.
What You Will Learn
- Take full advantage of advanced and modern features in Oracle SQL
- Recognize when modern SQL constructs can help create better applications
- Improve SQL query building skills through stepwise refinement
- Apply set-based thinking to process more data in fewer queries
- Make cross-row calculations with analytic functions
- Search for patterns across multiple rows using row pattern matching
- Break complex calculations into smaller steps with subquery factoring
Who This Book Is For
Oracle Database developers who already know some SQL, but rarely use features of the language beyond the SQL-92 standard. And it is for developers who would like to apply the more modern features of Oracle SQL, but don't know where to start. The book also is for those who want to write increasingly complex queries in a stepwise and understandable manner. Experienced developers will use the book to develop more efficient queries using the advanced features of the Oracle SQL language.
商品描述(中文翻譯)
撰寫強大的查詢，盡可能利用功能豐富的 Oracle SQL 語言，超越 SQL-92 標準中的基本 SQL 簡單查詢。
標準 SQL 和 Oracle 自身對該語言的擴展在過去幾十年中已經取得了很大進展，您可以在單個 SQL 語句中處理數據的能力雖然有時複雜，但已經大幅提升。如果您已經了解 SQL 的基本知識，本書提供了許多示例，展示如何編寫更高級的 SQL，這將對您的應用程序帶來巨大的好處，例如：
- 將行轉換為列，將列轉換為行
- 使用 MODEL 和 WITH 子句進行 SQL 遞歸
- 回答 Top-N 問題
- 使用線性回歸進行預測
- 行模式匹配以分組或分配行
- 使用 MATCH_RECOGNIZE 作為行處理引擎
本書涵蓋了從簡單的 SQL 語句開始，逐步將這些語句轉化為更複雜的語句以產生強大結果的過程。通過親自嘗試這些食譜和示例，您將組合出強大的 SQL 語句，使您的應用程序在競爭對手中脫穎而出。
**您將學到什麼**
- 充分利用 Oracle SQL 中的高級和現代功能
- 辨識現代 SQL 結構何時能幫助創建更好的應用程序
- 通過逐步改進提高 SQL 查詢構建技能
- 應用基於集合的思維，以更少的查詢處理更多數據
- 使用分析函數進行跨行計算
- 使用行模式匹配在多行中搜索模式
- 通過子查詢分解將複雜計算拆分為更小的步驟
**本書適合誰**
本書適合已經了解一些 SQL 的 Oracle 數據庫開發人員，但很少使用超出 SQL-92 標準的語言功能。也適合希望應用 Oracle SQL 更現代功能的開發人員，但不知道從何開始。本書同樣適合那些希望以逐步且易於理解的方式編寫日益複雜查詢的人。經驗豐富的開發人員將利用本書開發更高效的查詢，使用 Oracle SQL 語言的高級功能。
作者簡介
Kim Berg Hansen is a database developer from Middelfart in Denmark. As a youngster he originally wanted to work with electronics, and he tried computer programming and discovered that the programs he wrote worked well--unlike the electronics projects he soldered that often failed. This led to a VIC-20 with 5 kilobytes RAM and many hours programming in Commodore Basic.
Having discovered his talent, Kim financed computer science studies at Odense University with a summer job as sheriff of Legoredo, while learning methodology and programming in Modula-2 and C. From there he moved into consulting as a developer making customizations to ERP software. That gave him his first introduction to Oracle SQL and PL/SQL, with which he has worked extensively since the year 2000.
His professional passion is to work with data inside the database utilizing the SQL language to the fullest to achieve the best application experience for his application users. With a background fitting programs into 5 KB RAM, Kim hates to waste computing resources unnecessarily.
Kim shares his experience and knowledge by blogging at the kibeha.dk website, presenting at various Oracle User Group conferences, and being the SQL quizmaster at the Oracle Dev Gym. His motivation comes from peers who say "now I understand" after his explanations, and from end users who "can't live without" his application coding. He is a certified Oracle OCE in SQL, and an Oracle ACE Director.
Outside the coding world, Kim is married, loves to cook, and is a card-carrying member of the Danish Beer Enthusiasts Association.
作者簡介(中文翻譯)
金·伯格·漢森（Kim Berg Hansen）是一位來自丹麥米德爾法特的資料庫開發人員。年輕時，他最初想從事電子工程，並嘗試了電腦程式設計，發現自己寫的程式運行良好——這與他焊接的電子專案經常失敗形成了鮮明對比。這使他擁有了一台擁有5KB RAM的VIC-20，並花了許多小時在Commodore Basic上編程。
在發現自己的才能後，金利用在Legoredo擔任治安官的暑期工作資助了奧登塞大學的計算機科學學習，同時學習Modula-2和C的編程方法。之後，他轉向顧問工作，作為開發人員對ERP軟體進行定制，這讓他首次接觸到Oracle SQL和PL/SQL，自2000年以來，他一直在這方面廣泛工作。
他的專業熱情在於利用SQL語言充分處理資料庫中的數據，以為應用程式用戶提供最佳的應用體驗。由於背景是將程式適配到5KB RAM，金厭惡不必要地浪費計算資源。
金通過在kibeha.dk網站上寫博客、在各種Oracle用戶組會議上演講，以及擔任Oracle Dev Gym的SQL測驗主持人來分享他的經驗和知識。他的動力來自於同行在聽完他的解釋後說「現在我明白了」，以及那些「無法沒有」他的應用程式編碼的最終用戶。他是Oracle SQL的認證OCE，並且是Oracle ACE Director。
在編程世界之外，金已婚，喜愛烹飪，並且是丹麥啤酒愛好者協會的正式會員。
