SQL Server 2014 Database Design

Kalman Toth

  • 出版商: CreateSpace Independ
  • 出版日期: 2014-05-06
  • 售價: $980
  • 貴賓價: 9.5$931
  • 語言: 英文
  • 頁數: 462
  • 裝訂: Paperback
  • ISBN: 1499367678
  • ISBN-13: 9781499367676
  • 相關分類: MSSQLSQL資料庫
  • 海外代購書籍(需單獨結帳)

商品描述

The #1 Best Guide to Microsoft SQL Server 2014 Database Design! Learn the latest SQL Server 2014 practical database design methods for career advancement; among them in-memory OLTP tables, FileTable FILESTREAM storage and ColumnStore indexes. Relational database design teach-by-practical-diagrams-&-examples book for developers, programmers, systems analysts and project managers who are new to relational database and client/server technologies. Also for database developers, database designers and database administrators (DBA), who know some database design, and who wish to refresh & expand their RDBMS design technology horizons. Familiarity with at least one computer programming language, Windows file system & Excel is assumed. Since the book is career advancement oriented, it has a great number of 3NF database design examples with metadata explanations along with practical SQL queries (over 700 SELECT queries) and T-SQL scripts, plenty to learn indeed. Great emphasis is placed on explaining the FOREIGN KEY - PRIMARY KEY constraints among tables, the connections which make the collection of individual tables a database. The database diagrams and queries are based on historic and current SQL Server sample databases: pubs (PRIMARY KEYs 9, FOREIGN KEYs 10) , Northwind (PRIMARY KEYs 13, FOREIGN KEYs 13) and the latest AdventureWorks series. Among them: AdventureWorks, AdventureWorks2008, AdventureWorks2012 (PRIMARY KEYs 71, FOREIGN KEYs 90), & AdventureWorksDW2012 (PRIMARY KEYs 27, FOREIGN KEYs 44). The last one is a data warehouse database which is the basis for multi-dimensional OLAP cubes. The book teaches through vivid database diagrams and T-SQL queries how to think in terms of sets at a very high level, focusing on set-based operations instead of loops like in procedural programming languages. The best way to master relational database design & T-SQL programming is to type the query in your own SQL Server Management Studio Query Editor, test it, examine it, change it and study it. Wouldn't it be easier just to copy & paste it? It would, but the learning value would diminish rapidly. You need to feel relational database design and the SQL language in your DNA. SQL queries, "CREATE TABLEs" must "pour" out from your fingers into the keyboard. Why is knowing SQL queries by heart so important? After all everything can be found on the web so why not just copy & paste? Well not exactly. If you want to be an database designer expert, it has to be in your head not on the web. Second, when your supervisor is looking over your shoulder, "Chuck, can you create a new table for our electric pumps inventory?", you have to be able to type the CREATE TABLE query without documentation or SQL forum search and explain how it will work to your superior promptly. The book was designed to be readable in any environment, even on the beach laptop around or no laptop in sight at all. All queries are followed by results row count and /or full/partial results listing in tabular (grid) format. Screenshots are used when dealing with GUI tools such as SQL Server Management Studio (SSMS). Mastery of the relational database design book likely to be sufficient for career advancement as a database designer and database developer.

商品描述(中文翻譯)

#1 最佳指南:Microsoft SQL Server 2014資料庫設計!學習最新的SQL Server 2014實用資料庫設計方法,以提升職業發展;其中包括內存OLTP表、FileTable FILESTREAM儲存和ColumnStore索引。這本以實例和範例教授關聯式資料庫設計的書籍適合開發人員、程式設計師、系統分析師和專案經理,他們對關聯式資料庫和客戶端/伺服器技術尚不熟悉。同樣適用於已經具備一定資料庫設計知識的資料庫開發人員、資料庫設計師和資料庫管理員(DBA),他們希望更新和擴展他們的關聯式資料庫管理系統設計技術。預設讀者對至少一種程式語言、Windows檔案系統和Excel有基本了解。由於這本書著重於職業發展,因此提供了大量的第三正規化資料庫設計範例,並附有元數據解釋,以及實用的SQL查詢(超過700個SELECT查詢)和T-SQL腳本,絕對有很多東西可以學習。書中非常強調解釋表之間的外鍵-主鍵約束,這些連接使得個別表的集合成為一個資料庫。資料庫圖表和查詢基於歷史和當前的SQL Server示範資料庫:pubs(主鍵9,外鍵10),Northwind(主鍵13,外鍵13)和最新的AdventureWorks系列。其中包括:AdventureWorks,AdventureWorks2008,AdventureWorks2012(主鍵71,外鍵90)和AdventureWorksDW2012(主鍵27,外鍵44)。最後一個是基於多維OLAP立方體的數據倉庫資料庫。本書通過生動的資料庫圖表和T-SQL查詢教授如何以非常高的層次思考集合,專注於基於集合的操作,而不是像程序設計語言中的循環。掌握關聯式資料庫設計和T-SQL編程的最佳方法是在自己的SQL Server Management Studio查詢編輯器中輸入、測試、檢查、更改和學習查詢。只要複製和貼上不是更容易嗎?確實如此,但學習價值會迅速減少。你需要將關聯式資料庫設計和SQL語言融入你的基因中。SQL查詢和“CREATE TABLE”必須從你的手指流入鍵盤。為什麼熟悉SQL查詢如此重要?畢竟,一切都可以在網上找到,為什麼不只是複製和貼上?嗯,不完全是這樣。如果你想成為一個資料庫設計專家,它必須存在於你的頭腦中,而不是在網上。其次,當你的主管在你肩膀上看著你時,“Chuck,你能為我們的電泵庫存創建一個新表嗎?”你必須能夠立即輸入CREATE TABLE查詢,而不需要文檔或SQL論壇搜索,並解釋它的工作原理給你的上級。這本書設計成在任何環境下都可閱讀,即使是在海灘上,無論是帶著筆記型電腦還是根本沒有筆記型電腦。所有查詢都附有結果行數和/或完整/部分結果的表格(網格)格式。在處理SQL Server Management Studio(SSMS)等圖形化工具時使用屏幕截圖。掌握關聯式資料庫設計的書籍可能足以讓你在職業發展中成為一名資料庫設計師和資料庫開發人員。