Databases DeMYSTiFieD, 2/e (Paperback)
暫譯: 資料庫解密,第二版 (平裝本)

Andy Oppel

  • 出版商: McGraw-Hill Education
  • 出版日期: 2010-12-01
  • 定價: $770
  • 售價: 8.0$616
  • 語言: 英文
  • 頁數: 448
  • 裝訂: Paperback
  • ISBN: 0071747990
  • ISBN-13: 9780071747998
  • 相關分類: 資料庫
  • 立即出貨 (庫存=1)

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

商品描述

Learning DATABASE fundamentals just got a whole lot EASIER!

Now you can design, build, and manage a fully functional database with ease. Thoroughly updated to cover the latest technologies and techniques, Databases Demystified, Second Edition gives you the hands-on help you need to get started.

Written in a step-by-step format, this practical guide covers methods that can be used with any database, including Microsoft Access, MySQL, Microsoft SQL Server, and Oracle. You'll learn about relational database components, database queries, SQL, the database life cycle, logical database design using normalization, and physical database design. Data and process modeling, database security, Online Analytical Processing (OLAP), and XML are also covered. Detailed examples and concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce learning.

It's a no-brainer! You'll find out how to:

  • Create and run database queries using the forms-based query tool in Microsoft Access
  • Write SQL statements and queries
  • Use entity relationship diagrams (ERDs) for data modeling
  • Design physical tables
  • Connect databases to users, computer systems, and applications
  • Secure database data
  • Handle cursor processing, transaction management, and performance tuning
  • Integrate XML documents and objects into databases

Simple enough for a beginner, but challenging enough for an advanced student, Databases Demystified, Second Edition is your self-paced guide to learning universal database concepts.

商品描述(中文翻譯)

學習資料庫基礎知識變得更加簡單了!

現在,您可以輕鬆設計、建構和管理一個功能完整的資料庫。《資料庫解密》(Databases Demystified)第二版經過全面更新,涵蓋最新的技術和方法,為您提供所需的實作幫助,讓您輕鬆入門。

本實用指南以逐步的格式撰寫,涵蓋可用於任何資料庫的方法,包括 Microsoft Access、MySQL、Microsoft SQL Server 和 Oracle。您將學習關於關聯資料庫組件、資料庫查詢、SQL、資料庫生命週期、使用正規化的邏輯資料庫設計以及物理資料庫設計。資料和過程建模、資料庫安全性、線上分析處理(OLAP)和 XML 也在涵蓋之列。詳細的範例和簡明的解釋使得理解材料變得容易,章末小測和期末考試有助於鞏固學習。

這簡直是小菜一碟!您將學會如何:
- 使用 Microsoft Access 中的表單查詢工具創建和執行資料庫查詢
- 撰寫 SQL 語句和查詢
- 使用實體關係圖(ERD)進行資料建模
- 設計物理表格
- 將資料庫連接到用戶、計算機系統和應用程式
- 確保資料庫資料的安全性
- 處理游標處理、交易管理和性能調優
- 將 XML 文件和物件整合到資料庫中

《資料庫解密》(Databases Demystified)第二版對初學者來說足夠簡單,但對進階學生來說又足夠具挑戰性,是您自學通用資料庫概念的最佳指南。