Practical SQL The Sequel
Judith S. Bowman
- 出版商: Addison Wesley
- 出版日期: 2000-12-15
- 定價: $1,360
- 售價: 6.0 折 $816
- 語言: 英文
- 頁數: 352
- 裝訂: Paperback
- ISBN: 0201616386
- ISBN-13: 9780201616385
-
相關分類:
SQL
立即出貨(限量) (庫存=3)
買這商品的人也買了...
-
$680$537 -
$2,760$2,622 -
$1,440The C++ Programming Language Special Edition (Hardcover)
-
$980$774 -
$950Internet Communications Using SIP
-
$1,068Introduction to Cryptography with Coding Theory
-
$1,176Mastering Enterprise JavaBeans, 2/e
-
$1,127Artificial Intelligence, 4/e
-
$1,274Computer Architecture: A Quantitative Approach, 3/e(精裝本)
-
$1,029Operating System Concepts, 6/e (Windows XP Update)
-
$2,300$2,185 -
$1,650$1,568 -
$1,440C++ Templates: The Complete Guide (Hardcover)
-
$750$675 -
$560$504 -
$780$663 -
$550$468 -
$280$218 -
$750$593 -
$580$199 -
$890$703 -
$620$484 -
$760$600 -
$580$493 -
$2,280$2,166
相關主題
商品描述
Description
The business problem-solving sequel to the best selling, The Practical SQL Handbook.
- Built around real business problems and solutions, not SQL features.
- The perfect "next step" for SQL-literate professionals ready to go far beyond the basics.
- CD-ROM: real-world example databases and complete Sybase Adaptive Server Anywhere database system to run them on.
Judith S. Bowman has been involved in databases since the early 1980s at Sybase and other database companies, in publications, sales, technical marketing, product marketing, and engineering. She has been an independent database consultant since 1994. Bowman is lead author of The Practical SQL Handbook (Addison Wesley), 0-201-44787-8.
Table Of Contents
List of Tables.List of Figures.
Acknowledgments.
1. Introduction.
Use, Not Feature.
Lots of Examples.
Multiple Systems.
Legacy.
Tuning.
Who This Book Is For.
Contents.
Appendices.
Speaking Multiple SQLs.
SQL Dialects.
Following Conventions.
Code.
Understanding the MSDPN Database.
Customer.
Supplier.
Product.
Ordermaster.
Orderdetail.
Employee.
Using the Examples.
Summary.
2. Handling Dirty Data.
Dirty Data.
Case.
UPPER and LOWER in Searches.
UPPER and LOWER in UPDATE.
UPPER and LOWER with Dates.
INITCAP.
Space.
Additional Features.
Size.
Defined Size.
LIKE.
LIKE Variants.
Datatypes and LIKE.
Position of Expression in Expression.
Using LOCATE Functions.
Sounds Like.
BETWEEN.
Dealing with Dates.
Doing Math on Dates.
Finding Dates.
Summary.
3. Translating Values.
Why Translate?
CASE/DECODE.
DECODE.
CASE/DECODE Variations.
Translating NULL.
Finding the First Non-NULL: COALESCE.
NULLIF.
Point Functions.
Getting CASE Effects from Multiple Functions.
UNION.
UNION and NULL.
UNION Problems?
Joins and Outer Joins.
Outer Joins.
Subqueries.
Embedded Correlated Subqueries.
Correlated and Non-Correlated Subqueries.
Another Conditional Expression: TRANSLATE.
Summary.
4. Managing Multiples.
What's the Issue with Multiples?
Duplicates.
Using ROWID to Remove Duplicates.
Near Duplicates.
Unequal Joins.
SIMILAR.
Locating Disconnected Rows.
Using NOT IN Subqueries.
Using MINUS.
Counting Items.
Locating the Critical Element.
Groups and Outer Joins.
Figuring Distribution.
Two Products Together?
HAVING.
Summary.
5. Navigating Numbers.
Auto-Numbering.
Transact-SQL: Column Property.
Microsoft SQL Server: IDENTITY (start, increment).
Sybase Adaptive Server Enterprise: IDENTITY.
Oracle: CREATE SEQUENCE.
Informix: SERIAL Datatype.
Associated Issues.
Finding the High Value.
FROM Subquery.
Row Counts of Various Sorts.
Row Numbers.
You Make the Numbers.
Top N: Six Approaches.
2: Row Numbers and HAVING.
3: Subquery.
4: Nested Subqueries.
5: Aggregates & Many Copies.
6: Cursors.
Finding Every Nth.
Modulo in WHERE and HAVING.
Back to Nth Row.
Running Total.
Summary.
6. Tuning Queries.
Perform, #%@!
The Basic Problem.
The Optimizer and Tools for Understanding It.
Checking the Optimizer.
SQL Conventions.
WHERE Clause.
Data Distribution Statistics.
Disabling an Index with a Bad WHERE.
Comparing Columns in the Same Table.
Using Non-Selective Indexes.
Doing Math on a Column.
Using Functions.
Finding Ranges with BETWEEN.
Matching with LIKE.
Comparing to NULL.
Negating with NOT.
Converting Values.
Using OR.
Finding Sets of Values with IN.
Using Multi-Column Indexes.
Covering Indexes.
Joining Columns.
Sorting.
UNION.
WHERE.
HAVING and WHERE.
Views.
Forcing Indexes.
Summary.
USING SQL TO WRITE SQL.
In This Chapter.
Systematically Speaking.
System Catalogs.
Writing Queries Using System Catalogs.
System Functions.
Finding Today's Date.
Writing SQL with SQL.
Removing Junk Objects.
Creating Test Data.
Summary.
Appendix A. Understanding the Sample.
MegaSysDataProNet Co.
Collecting the CREATE Scripts.
Sybase Adaptive Server Enterprise.
Microsoft SQL Server.
Oracle.
Informix.
Explaining the INSERT Scripts.
INSERT INTO supplier.
INSERT INTO product.
INSERT INTO employee.
INSERT INTO ordermaster.
INSERT INTO orderdetail.
Experimenting and Transaction Management.
Removing Data and Objects: DROP and DELETE Commands.
DROP Commands.
DELETE FROM Command.
Summary.
Appendix B. Comparing Datatypes and Functions.
Comparatively Speaking.
Datatype Comparison.
Function Comparison.
Number Functions.
Date Functions.
Conditional Functions.
Sequential Number Methods.
Row Number and Row ID Methods.
Other Functions.
Tuning Functions.
System Functions.
Join Syntax Comparison.
Notes on Environment and Display.
Summary.
Appendix C. Using Resources.
Books.
Informix.
Microsoft SQL Server.
mSQL/MySQL.
Oracle.
Sybase.
Transact-SQL.
Web Sites.
Database Vendors.
Newsgroups.
Index. 0201616386T04062001
商品描述(中文翻譯)
《實用SQL:續集》是暢銷書《實用SQL手冊》的商業問題解決續集。本書圍繞真實的商業問題和解決方案展開,而不是SQL的功能特性。對於已經熟悉SQL並希望深入了解的專業人士來說,這是一個完美的「下一步」。附帶CD-ROM,其中包含真實世界的範例數據庫和完整的Sybase Adaptive Server Anywhere數據庫系統。在現實世界中,你可能會面臨的SQL挑戰遠遠超出了大多數書籍所教授的「通用」基礎知識。無論你是維護現有的SQL代碼、增強它,還是編寫全新的應用程序,你都需要審查各種SQL,了解其內部運作原理,並將SQL的功能轉化為解決問題的實際工具。在《實用SQL:續集》中,Judith Bowman在她的暢銷書《實用SQL》的基礎上,提供了可以立即使用的技巧和代碼,用於編寫解決最複雜問題的查詢。《實用SQL:續集》按照問題類別組織,而不是抽象的SQL特性,包括大量經過多個領先的關聯式數據庫管理系統測試的成熟代碼。Bowman提供了詳細的解決方案,用於使用字符、數字和日期函數控制數據顯示;清理髒數據;以及使用各種方法翻譯值。書中還有一整章關於管理多個數據庫。最後,Bowman介紹了編號解決方案和調優查詢的技巧。書中附有一個廣泛的示例數據庫,以及一個包含有關主要SQL方言變體的信息的單一來源參考資料。適用於所有中高級數據庫和商業專業人士,他們希望更有效地使用SQL。Judith S. Bowman自20世紀80年代初以來一直從事數據庫工作,曾在Sybase和其他數據庫公司擔任出版、銷售、技術營銷、產品營銷和工程等職位。她自1994年起擔任獨立數據庫顧問。Bowman是《實用SQL手冊》(Addison Wesley)的主要作者,書號為0-201-44787-8。
目錄:
1. 簡介
2. 處理髒數據