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.

商品描述(中文翻譯)

學習資料庫基礎變得更加容易了!現在您可以輕鬆地設計、建立和管理一個完全功能的資料庫。經過全面更新以涵蓋最新的技術和技巧,《資料庫解密》,第二版為您提供了開始的實用幫助。

這本實用指南以逐步的方式撰寫,涵蓋了可用於任何資料庫的方法,包括Microsoft Access、MySQL、Microsoft SQL Server和Oracle。您將學習關聯式資料庫組件、資料庫查詢、SQL、資料庫生命週期、使用正規化進行邏輯資料庫設計以及物理資料庫設計。還介紹了資料和流程建模、資料庫安全性、線上分析處理(OLAP)和XML。詳細的示例和簡潔的解釋使學習材料易於理解,章末的測驗和期末考試有助於強化學習。

這是一個不需要思考的選擇!您將了解如何:
- 使用Microsoft Access的基於表單的查詢工具創建和執行資料庫查詢
- 編寫SQL語句和查詢
- 使用實體關係圖(ERD)進行資料建模
- 設計物理表
- 將資料庫連接到使用者、電腦系統和應用程式
- 保護資料庫數據
- 處理游標處理、事務管理和性能調整
- 將XML文件和物件整合到資料庫中

對於初學者來說足夠簡單,對於高級學生來說足夠具有挑戰性,《資料庫解密》,第二版是您自學的通用資料庫概念指南。