SQL Cookbook (Paperback)

Anthony Molinaro

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

商品描述

Description

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.


Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT FROM WHERE . But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:

 

  • Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out
     
  • Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function
     
  • Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set
     
  • Bucketization, and why you should never use that term in Brooklyn.
     
  • How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques
     
  • The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string

 

 

商品描述(中文翻譯)

描述

你已經了解 SQL 查詢語言的基本知識,但你覺得自己沒有充分利用 SQL 的表達能力。你希望在將數據推送到應用程序之前,在數據庫內部學習如何更多地使用 SQL 進行工作。你希望將你的 SQL 技能提升到更高的水平。

讓我們面對現實,SQL 是一種看似簡單的語言,許多數據庫開發人員從未超越簡單的語句:SELECT FROM WHERE 。但是,你可以用這種語言做更多的事情。在《SQL Cookbook》中,經驗豐富的 SQL 開發人員 Anthony Molinaro 分享了他最喜歡的 SQL 技巧和功能。你將學到以下內容:

- 窗口函數,可以說是過去十年來 SQL 最重要的增強功能。如果你沒有使用這些功能,你就錯過了很多。
- 強大的、特定於數據庫的功能,例如 SQL Server 的 PIVOT 和 UNPIVOT 運算符、Oracle 的 MODEL 子句以及 PostgreSQL 的非常有用的 GENERATE_SERIES 函數。
- 將行轉換為列,將列轉換為行,使用轉換來進行行間計算,以及對結果集進行雙重轉換。
- "Bucketization",以及為什麼你不應該在布魯克林使用這個詞。
- 如何創建直方圖,將數據總結到桶中,對一個移動的值範圍進行聚合,生成運行總計和小計,以及其他高級的數據倉庫技術。
- "Walking a string" 技術,允許你使用 SQL 解析字符串的字符、單詞或分隔元素。