SQL Fundamentals, 3/e

John J. Patrick

  • 出版商: Prentice Hall
  • 出版日期: 2008-09-01
  • 售價: $2,100
  • 貴賓價: 9.5$1,995
  • 語言: 英文
  • 頁數: 832
  • 裝訂: Paperback
  • ISBN: 0137126026
  • ISBN-13: 9780137126026
  • 相關分類: SQL
  • 立即出貨 (庫存=1)



SQL for the Real World


Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick’s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application–from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before.


SQL Fundamentals,Third Edition, teaches you how to

  • Build simple statements to retrieve, store, or modify data
  • Craft complex queries that draw information from multiple tables
  • Sort and summarize your data just the way you want it
  • Create and edit your own tables
  • Protect the integrity of your data
  • Create more efficient, high-performance queries
  • Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins
  • Use the Oracle Data Dictionary

About the Web Site


The accompanying Web site, http://groups.google.com/group/sqlfun, contains all the SQL code and tables from the book, including the full databases for several versions of Access and code for building the corresponding Oracle databases. It also provides solutions to many of the book’s problems and an open area for discussions with the author and other readers.


《SQL for the Real World》

不要只學習「通用」的 SQL。學習 SQL,以在世界頂尖的資料庫平台上獲得結果 - 企業級的 Oracle 和桌面版的 Microsoft Access。本書基於約翰·帕特里克(John Patrick)在加州大學伯克利分校延伸部開設的實踐 SQL 課程,展示了如何在任何應用程序中按需檢索所需的數據,從臨時報告到數據倉庫。本書已全面更新至最新版本的 Oracle、Access 和 SQL 標準,比以往更多地包含了練習、技巧和解決方案。即使您以前從未使用過數據庫,您也將學會如何撰寫易於理解、驗證、修改和擴展的 SQL 查詢。

《SQL Fundamentals, Third Edition》教您如何:

- 構建簡單的語句以檢索、存儲或修改數據
- 創建從多個表中提取信息的複雜查詢
- 按照您想要的方式對數據進行排序和總結
- 創建和編輯自己的表
- 保護數據的完整性
- 創建更高效、高性能的查詢
- 使用聯合、子查詢、自身連接、交叉連接、內部連接和外部連接
- 使用 Oracle 數據字典


附帶的網站 http://groups.google.com/group/sqlfun 包含了本書中的所有 SQL 代碼和表格,包括幾個版本的 Access 的完整數據庫以及構建相應 Oracle 數據庫的代碼。它還提供了許多問題的解決方案,以及與作者和其他讀者進行討論的開放區域。