Oracle SQL by Example, 3/e
暫譯: Oracle SQL 實例解析，第3版

Alice Rischert

Oracle SQL by Example, 3/e
  • 出版商: Prentice Hall
  • 出版日期: 2004-06-27
  • 售價: $2,730
  • 貴賓價: 9.5 折 $2,594
  • 語言: 英文
  • 頁數: 960
  • 裝訂: Paperback
  • ISBN: 0131451316
  • ISBN-13: 9780131451315
  • 相關分類: Oracle、SQL

    • 已過版

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

相關主題

商品描述

Description:

The book ... has enough depth for even a seasoned professional to pick up enough tips to pay back the price of the book many times over.—Dr. Paul Dorsey, President Dulcian, Inc., and President, New York Oracle Users Group.

Students find Oracle SQL by Example to be extremely helpful not only to their coursework but also in preparing them for future careers as Oracle DBAs and developers. The layout of the text is conducive to the learning process. It introduces a concept and then reinforces that concept with an exercise.—Betsy Jenaway, Coordinator, Malcomb Operations, and Senior Lecturer College of Management, Lawrence Technological University, Southfield, MI.

The world's #1 hands-on Oracle SQL workbook ... fully updated for Oracle 10g

Crafted for hands-on learning and tested in classrooms worldwide this book illuminates in-depth every Oracle SQL technique you'll need. From the simplest query fundamentals through the newest regular expression database enhancements, you will focus on the tasks that matter most. Hundreds of guided lab exercises will systematically strengthen your expertise in writing effective, high-performance SQL. Along the way, you will acquire an arsenal of useful Oracle SQL knowledge and techniques: an extraordinary library of solutions for your real-world challenges with Oracle SQL.

  • Creating and using tables, views, indexes, and sequences
  • Working in SQL*Plus and iSQL*Plus environments
  • Oracle functions in depth—especially number, character, date, timestamp, interval, time zone, aggregate, and analytical functions
  • All types of joins, including equijoins, outer joins, self joins and ANSI join syntax options
  • Every type of subquery, including correlated and scalar subqueries, set operators, hierarchical queries, flashback queries, data dictionary, object-relational features, regular expressions, and more
  • Common pitfalls to avoid, and solutions for common mistakes
  • Practical performance, security, and architectural solutions
  • Insights, tips, and tricks-of-the-trade from an experienced Oracle professional
  • For every database developer, administrator, designer or architect, regardless of experience!

 

Table of Contents:

(NOTE: Each chapter concludes with Test Your Thinking.)

Foreword.

Acknowledgments.

About the Author.

Introduction.

1. SQL and Data.

Data, Databases, and the Definition of sql. Table Relationships. The Student Schema Diagram.

2. SQL: The Basics.

The SQL*Plus Environment. The Anatomy of a SELECT Statement. Editing a SQL Statement. The WHERE Clause: Comparison and Logical Operators. The ORDER BY Clause.

3. Character, Number, and Miscellaneous Functions.

Character Functions. Number Functions. Miscellaneous Single-Row Functions.

4. Date and Conversion Functions.

Applying Oracle's Date Format Models. Performing Date and Time Math. Understanding Timestamp and Time Zone Datatypes. Performing Calculations with the Interval Datatypes. Converting from One Datatype to Another.

5. Aggregate Functions, Group By, and Having.

Aggregate Functions. The GROUP BY and HAVING Clauses.

6. Equijoins.

The Two-Table Join. Joining Three or More Tables.

7. Subqueries.

Simple Subqueries. Correlated Subqueries. Inline Views and Scalar Subquery Expressions . ANY, SOME, and ALL Operators in Subqueries.

8. Set Operators.

The Power of UNION and UNION ALL. The MINUS and INTERSECT Set Operators.

9. Complex Joins.

Outer Joins. Self-Joins.

10. Insert, Update, and Delete.

Creating Data and Transaction Control. Updating and Deleting Data.

11. Create, Alter, and Drop Tables.

Creating and Dropping Tables. Altering Tables and Manipulating Constraints.

12. Views, Indexes, and Sequences.

Creating and Modifying Views. Indexes. Sequences.

13. The Data Dictionary and Advanced SQL*Plus Commands.

The Oracle Data Dictionary Views. Advanced SQL*Plus Commands.

14. Security.

Users, Privileges, Roles, and Synonyms.

15. Regular Expressions and Hierarchical Queries.

Regular Expressions. Hierarchical Queries.

16. Exploring Data Warehousing Features.

-Advanced SQL Concepts, Analytical Functions, and the with Clause. ROLLUP and CUBE Operators.

17. SQL Optimization.

-The Oracle Optimizer and Writing Effective SQL Statements.

Appendix A: Answers to Self-Review Questions.

Appendix B: SQL Formatting Guide.

Appendix C: SQL*Plus Command Reference.

Appendix D: Student Database Schema.

Appendix E: Table and Column Descriptions.

Appendix F: Additional Example Tables.

Appendix G: Navigating through the Oracle Documentation.

Appendix H: Resources.

Appendix I: Oracle Datatypes.

Index.

商品描述(中文翻譯)

描述：
「這本書...即使對於經驗豐富的專業人士來說，也有足夠的深度，可以獲得足夠的技巧，讓書本的價值多倍回報。」—保羅·多爾西博士，Dulcian, Inc. 總裁，紐約 Oracle 使用者小組總裁。

「學生們發現《Oracle SQL by Example》對他們的課程非常有幫助，也為他們未來成為 Oracle DBA 和開發人員做好準備。文本的佈局有助於學習過程。它介紹一個概念，然後通過練習來加強該概念。」—貝茜·詹納威，Malcomb Operations 協調員，Lawrence Technological University 管理學院高級講師，南菲爾德，密歇根州。

世界第一本實作型 Oracle SQL 工作手冊... 完全更新至 Oracle 10g

這本書專為實作學習而設計，並在全球教室中進行測試，深入闡述您所需的每一種 Oracle SQL 技術。從最簡單的查詢基礎到最新的正則表達式數據庫增強，您將專注於最重要的任務。數百個指導實驗室練習將系統性地加強您撰寫有效、高效能 SQL 的專業知識。在這個過程中，您將獲得一系列有用的 Oracle SQL 知識和技術：為您在 Oracle SQL 中面對的現實挑戰提供非凡的解決方案庫。

- 創建和使用表、視圖、索引和序列
- 在 SQL*Plus 和 iSQL*Plus 環境中工作
- 深入了解 Oracle 函數—特別是數字、字符、日期、時間戳、間隔、時區、聚合和分析函數
- 所有類型的連接，包括等值連接、外部連接、自連接和 ANSI 連接語法選項
- 每種類型的子查詢，包括相關子查詢和標量子查詢、集合運算符、層次查詢、閃回查詢、數據字典、物件關聯特性、正則表達式等
- 常見的陷阱及避免方法，常見錯誤的解決方案
- 實用的性能、安全性和架構解決方案
- 來自經驗豐富的 Oracle 專業人士的見解、技巧和行業秘訣
- 適合每位數據庫開發人員、管理員、設計師或架構師，無論經驗如何！

目錄：
（注意：每章結尾都有「測試你的思維」。）
前言。
致謝。
關於作者。
介紹。
1. SQL 和數據。
數據、數據庫及 SQL 的定義。表關係。學生架構圖。
2. SQL：基礎知識。
SQL*Plus 環境。SELECT 語句的結構。編輯 SQL 語句。WHERE 子句：比較和邏輯運算符。ORDER BY 子句。
3. 字符、數字和其他函數。
字符函數。數字函數。其他單行函數。
4. 日期和轉換函數。
應用 Oracle 的日期格式模型。進行日期和時間計算。理解時間戳和時區數據類型。使用間隔數據類型進行計算。從一種數據類型轉換為另一種。
5. 聚合函數、GROUP BY 和 HAVING。
聚合函數。GROUP BY 和 HAVING 子句。
6. 等值連接。
兩表連接。連接三個或更多表。
7. 子查詢。
簡單子查詢。相關子查詢。內聯視圖和標量子查詢表達式。子查詢中的 ANY、SOME 和 ALL 運算符。
8. 集合運算符。
UNION 和 UNION ALL 的威力。MINUS 和 INTERSECT 集合運算符。
9. 複雜連接。
外部連接。自連接。
10. 插入、更新和刪除。
創建數據和事務控制。更新和刪除數據。
11. 創建、修改和刪除表。
創建和刪除表。修改表和操作約束。
12. 視圖、索引和序列。
創建和修改視圖。索引。序列。
13. 數據字典和高級 SQL*Plus 命令。
Oracle 數據字典視圖。高級 SQL*Plus 命令。
14. 安全性。
用戶、權限、角色和同義詞。
15. 正則表達式和層次查詢。
正則表達式。層次查詢。
16. 探索數據倉儲功能。
- 高級 SQL 概念、分析函數和 WITH 子句。ROLLUP 和 CUBE 運算符。
17. SQL 優化。
- Oracle 優化器和撰寫有效 SQL 語句。
附錄 A：自我檢測問題的答案。
附錄 B：SQL 格式指南。
附錄 C：SQL*Plus 命令參考。
附錄 D：學生數據庫架構。
附錄 E：表和列描述。
附錄 F：其他示例表。
附錄 G：導航 Oracle 文檔。
附錄 H：資源。
附錄 I：Oracle 數據類型。
索引。

類似商品

最後瀏覽商品 (20)