Pro SQL Server 2008 Relational Database Design and Implementation (Paperback)

Louis Davidson, Kevin Kline, Scott Klein, Kurt Windisch

Pro SQL Server 2008 Relational Database Design and Implementation (Paperback)
  • 出版商: Apress
  • 出版日期: 2008-08-21
  • 定價: $1,980
  • 售價: 5.0 折 $990
  • 語言: 英文
  • 頁數: 680
  • 裝訂: Paperback
  • ISBN: 143020866X
  • ISBN-13: 9781430208662
  • 相關分類: MSSQL、SQL、資料庫

    • 立即出貨(限量) (庫存=4)

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

商品描述

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to “get it right” in SQL Server database design and lay a solid groundwork for the future use of valuable business data.

  • Solid foundation in best practices and relational theory
  • Maximize SQL Server features to enhance security, performance, scalability
  • Thorough treatment from conceptual design to an effective, physical implementation

What you’ll learn

  • Develop conceptual models of client data using interviews and client documentation.
  • Normalize data models to enhance scalability and the long term use of valuable data.
  • Translate conceptual models into high–performing SQL Server databases.
  • Secure and protect the integrity of data as part of meeting regulatory requirements.
  • Take full advantage of new SQL Server features such as the spatial datatype, XML support, transparent data encryption, and more.
  • Create effective indexing to speed query performance.

Who is this book for?

Pro SQL Server 2008 Relational Database Design and Implementation is designed for programmers of all types who want to use SQL Server 2008 to store data. Rookie database programmers will find a complete course on the fundamentals of database design that includes conceptual designs and physical implementation. Seasoned veterans will find many tips and tricks for implementing database systems that will be well worth the time invested in reading this book.

About the Apress Pro Series

The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.

You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.

商品描述(中文翻譯)

在 SQL Server 環境中學習有效且可擴展的資料庫設計技巧。《Pro SQL Server 2008 關聯式資料庫設計與實作》涵蓋了從商業使用者能理解的設計邏輯到在 SQL Server 資料庫中實作設計的所有內容。作者 Louis Davidson、Kevin Kline、Scott Klein 和 Kurt Windisch 基於最佳實踐和對底層理論的深入理解，展示了如何在 SQL Server 資料庫設計中做到「正確」，並為未來使用寶貴的商業數據奠定堅實基礎。


  • 基於最佳實踐和關聯理論的堅實基礎

  • 最大化 SQL Server 功能以增強安全性、性能和可擴展性

  • 從概念設計到有效的實作的全面處理

你將學到什麼



  • 使用訪談和客戶文件開發客戶數據的概念模型

  • 對數據模型進行規範化以增強可擴展性和長期使用寶貴數據

  • 將概念模型轉化為高效的 SQL Server 資料庫

  • 作為滿足監管要求的一部分，保護和維護數據的完整性

  • 充分利用新的 SQL Server 功能，如空間數據類型、XML 支持、透明數據加密等

  • 創建有效的索引以加快查詢性能

這本書適合誰閱讀？


《Pro SQL Server 2008 關聯式資料庫設計與實作》適用於所有希望使用 SQL Server 2008 儲存數據的程式設計師。新手資料庫程式設計師將找到一個完整的課程，涵蓋了資料庫設計的基礎，包括概念設計和實作。經驗豐富的專業人士將找到許多實施資料庫系統的技巧和訣竅，閱讀這本書所投入的時間將是非常值得的。

關於 Apress Pro 系列


Apress Pro 系列書籍是實用的專業教程，可幫助您在職業生涯中不斷提升。


您已經得到了工作，現在您需要在這個競爭激烈的時代中磨練自己的技能。Apress Pro 系列擴展了您在所需領域的技能和專業知識。掌握 Pro 系列書籍的內容，您將始終能夠在專業開發項目中完成工作。Apress 的 Pro 系列書籍由各自領域的專家撰寫，為您提供了在職業程式設計生涯中所面臨問題的寶貴解決方案。

類似商品