Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (喬·塞爾科的集合思維：SQL中的輔助、時間和虛擬表格)
Joe Celko
- 出版商: Morgan Kaufmann
- 出版日期: 2008-01-22
- 定價: $1,120
- 售價: 5.0 折 $560
- 語言: 英文
- 頁數: 384
- 裝訂: Paperback
- ISBN: 0123741378
- ISBN-13: 9780123741370
-
相關分類:
SQL
立即出貨 (庫存 < 3)
買這商品的人也買了...
-
$990Joe Celko's Data & Databases: Concepts in Practice -
Oracle PL/SQL 程式設計 (Oracle PL/SQL Programming, 3/e)$1,200$948 -
MCSE Windows Server 2003 網路專礎架構規劃專業認證指南 (Planning a Windows Server 2003 Network Infrastructure Study Guide)
$850$723 -
UML 2 百寶箱 (UML 2 Toolkit)$650$514 -
$399Joe Celko's SQL Programming Style -
計算機組織與設計 (Computer Organization and Design: The Hardware/Software Interface, 3/e)$680$646 -
深入淺出設計模式 (Head First Design Patterns)$880$695 -
Dreamweaver 8 實力養成暨評量$350$277 -
SQL 語法範例辭典$550$468 -
ASP.NET 語法範例辭典
$600$510 -
Visual C# 2005 建構資訊系統實戰經典教本$650$507 -
網路與伺服器監視軟體 Nagios 入門與應用$360$281 -
聖殿祭司的 ASP.NET 2.0 專家技術手冊─使用 C#, 2/e$720$569 -
Oracle Database 10g OCP 專業認證指南 II (考試編號:1Z0-043) (Oracle Database 10g OCP Certification All-in-one Exam Guide)$650$553 -
Microsoft SQL Server 2005 完全實戰$800$632 -
$1,440Joe Celko's Analytics and OLAP in SQL -
MIS 網管聖經$620$527 -
無線區域及個人網路─隨意及感測器網路之技術與應用$480$379 -
C++ Primer, 4/e (中文版)$990$891 -
軟體測試實務講座─來自矽谷的技術經驗與心得分享$290$226 -
ASP.NET AJAX 經典範例 100─使用 VC#$750$593 -
ASP.NET 問題解決實戰$580$493 -
Linux 系統程式設計 (Linux System Programming: Talking Directly to the Kernel and C Library)$780$616 -
Reverse Engineering Code with IDA Pro$2,150$2,043 -
解密 SEO：如何讓網站排名第一$480$408
相關主題
商品描述
Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.
This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you'll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you'll be coding more quickly, writing more efficient code, and applying the full power of SQL
. Filled with the insights of one of the world's leading SQL authorities - noted for his knowledge and his ability to teach what he knows.
. Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance).
. Presents clear guidance for selecting and correctly applying the right table technique.
This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you'll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you'll be coding more quickly, writing more efficient code, and applying the full power of SQL
. Filled with the insights of one of the world's leading SQL authorities - noted for his knowledge and his ability to teach what he knows.
. Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance).
. Presents clear guidance for selecting and correctly applying the right table technique.
商品描述(中文翻譯)
優秀的程式設計師在被迫使用SQL時常常感到困惑。為什麼呢？Joe Celko認為問題在於他們的程序化編程思維，這使他們無法充分利用聲明式語言的威力。結果就是過於複雜和低效的程式碼，更不用說生產力的損失了。
這本書將改變你對使用SQL程式解決問題的思考方式。Celko著重介紹了三種關於表格的關鍵技巧，通過詳細的例子和清晰的解釋展示了它們的威力。當你掌握了這些技巧，你會發現你能夠將問題概念化為集合並通過聲明式編程來解決。不久之後，你將能夠更快地編寫程式碼，寫出更高效的程式碼，並充分應用SQL的全部威力。
這本書充滿了世界頂尖SQL專家的見解，他以其知識和教學能力而聞名。
重點介紹了輔助表格（通過連接計算函數和其他值）、時間表格（用於時間查詢、歷史數據和審計信息）和虛擬表格（用於提高性能）。
提供了選擇和正確應用適當的表格技巧的明確指導。
